CAST Imaging - Profile execution time of extracting application – CAST

This page provides you with detailed information about time required for extracting applications.

AIP Version	Yes/No
8.3.x

Imaging version	Yes/No
2.x

RDBMS	Yes/No
CSS

You need to run the extraction in debug mode - CAST Imaging System - Information - Export application in debug mode

Run the following on the KB:

SELECT Substring (START_HIST.step_name, 1, Length(START_HIST.step_name) - 5) AS 
       Step, 
       START_HIST.action_date 
       Start_date, 
       END_HIST.action_date 
       end_date, 
       ( END_HIST.action_date - START_HIST.action_date )                     AS 
       consumed_time 
FROM   deltatcc_local.aaa_is_logs START_HIST, 
       deltatcc_local.aaa_is_logs END_HIST 
WHERE  START_HIST.log_id + 1 = END_HIST.log_id 
       AND START_HIST.step_name LIKE '%Begin' 
       AND END_HIST.step_name LIKE '%End' 
ORDER  BY ( END_HIST.action_date - START_HIST.action_date ) DESC

Query result sample:

step	start_date	end_date	consumed_time
aaa_is_dtg_create_all	43:15.7	43:19.9	00:04.3
aaa_is_init	43:12.1	43:13.5	00:01.4
aaa_is_dtg_table_reindex	43:20.6	43:21.7	00:01.1
aaa_is_tra_projection_to_parent	43:15.4	43:15.6	00:00.2
aaa_is_lnk_process_init	43:14.4	43:14.6	00:00.2
aaa_is_lnk_extract	43:14.2	43:14.3	0:00:00
aaa_is_lnk_good_to_go	43:14.9	43:15.1	0:00:00
aaa_is_tra_extract	43:15.1	43:15.3	00:00.2
aaa_is_dtg_process_init	43:20.0	43:20.1	00:00.2
aaa_is_lnk_projection_to_parent	43:14.7	43:14.8	00:00.2
aaa_is_obj_color_db	43:13.7	43:13.9	00:00.1
aaa_is_tra_process_init	43:15.3	43:15.4	00:00.1
aaa_is_obj_extract	43:13.5	43:13.6	0:00:00
aaa_is_lnk_projection_to_called	43:14.8	43:14.9	00:00.1
aaa_is_lnk_ignore_identification	43:14.4	43:14.4	0:00:00
aaa_is_obj_color_dao	43:13.9	43:13.9	0:00:00
aaa_is_obj_good_to_go	43:14.1	43:14.2	00:00.1
aaa_is_obj_ignore_identification	43:13.6	43:13.7	00:00.0
aaa_is_dtg_projection_to_parent	43:20.1	43:20.2	00:00.0
aaa_is_obj_process_init	43:13.7	43:13.7	00:00.0
aaa_is_obj_color_transac	43:13.9	43:14.0	0:00:00
aaa_is_dtg_extract	43:19.9	43:19.9	00:00.0
aaa_is_lnk_projection_to_parent_init	43:14.6	43:14.7	00:00.0
aaa_is_obj_color_struts	43:14.1	43:14.1	00:00.0
aaa_is_obj_color_mq	43:20.5	43:20.5	00:00.0
aaa_is_obj_color_batch	43:14.0	43:14.0	00:00.0
aaa_is_obj_color_servlet	43:14.1	43:14.1	00:00.0
aaa_is_obj_defaultmap_by_type	43:13.7	43:13.7	0:00:00
aaa_is_tra_projection_to_called	43:15.6	43:15.7	0:00:00
aaa_is_obj_color_mq	43:14.0	43:14.0	00:00.0
aaa_is_obj_good_to_go	43:20.6	43:20.6	00:00.0
aaa_is_logs	43:20.6	43:20.6	00:00.0
aaa_is_obj_color_mvc	43:14.0	43:14.1	0:00:00
aaa_is_obj_color_thread	43:14.0	43:14.0	00:00.0
aaa_is_obj_color_ws	43:13.9	43:13.9	00:00.0
aaa_is_obj_color_transac	43:20.5	43:20.6	0:00:00
aaa_is_obj_cobol_reassign	43:20.6	43:20.6	0:00:00
aaa_is_obj_defaultmap_by_dependency	43:13.7	43:13.7	00:00.0
aaa_is_obj_defaultmap_by_name	43:13.7	43:13.7	00:00.0
aaa_is_tra_ignore_identification	43:15.3	43:15.3	00:00.0
aaa_is_dtg_ignore_identification	43:19.9	43:19.9	0:00:00
aaa_is_lnk_projection_to_caller	43:14.8	43:14.8	00:00.0
aaa_is_lnk_projection_to_child	43:14.8	43:14.8	00:00.0
aaa_is_dtg_projection_to_child	43:20.2	43:20.2	0:00:00
aaa_is_dtg_projection_to_caller	43:20.2	43:20.2	0:00:00
aaa_is_dtg_projection_to_called	43:20.2	43:20.2	0:00:00
aaa_is_obj_color_userinterface	43:14.0	43:14.0	00:00.0
aaa_is_obj_finalmap	43:14.1	43:14.1	00:00.0
aaa_is_obj_color_batch	43:20.6	43:20.6	0:00:00
aaa_is_obj_color_richclient	43:14.0	43:14.0	00:00.0
aaa_is_obj_color_io	43:14.0	43:14.0	00:00.0
aaa_is_tra_good_to_go	43:20.6	43:20.6	0:00:00
aaa_is_tra_projection_to_child	43:15.6	43:15.6	00:00.0
aaa_is_tra_projection_to_caller	43:15.6	43:15.6	00:00.0

Comments