Performance Monitoring

Performance monitoring can be activated using Input_Flags = INPUT_FLAGS_PM_ACTIVE. During or after a script execution the following variables can be evaluated:

PM_O.PM_Start_TS TS: Script begin
PM_O.PM_StartWork_TS TS: Begin of processing after initialization
PM_O.PM_End_TS TS: End of processing
PM_O.PM_Duration T: Duration of processing
PM_O.PM_Initialization T: Duration of initialization
PM_O.PM_Waiting_Source T: Waiting for data source
PM_O.PM_Reading_Source T: Reading data source
PM_O.PM_Writing_Target T: Writing output
PM_O.PM_Reading_Structures T: Reading structure information
PM_O.PM_Reading_Dictionaries T: Reading Db2 z/OS 'compression dictionaries'
PM_O.PM_CDC_Exit T: Processing in CDC Exits
PM_O.PM_Last_NearRealTime_Gap T: Last time difference between log record timestamp and current UTC
PM_O.PM_Last_NearRealTime_Gap_TS TS: time when PM_Last_NearRealTime_Gap has been set
PM_O.PM_Max_NearRealTime_Gap T: Maximum time difference between log record TS and current UTC
PM_O.PM_Max_NearRealTime_Gap_TS TS: time when PM_Max_NearRealTime_Gap has been set

TS: Variable contains a timestamp

T: Variable contains the total elapsed time as well as a percentage relative to PM_O.PM_Duration

All timings are in UTC.

Example for a script epilog:

IF PM_O.PM_Start_TS <> 'PM_O.PM_Start_TS'  THEN DO
	SAY 'PM_Start_TS:                ' PM_O.PM_Start_TS
	SAY 'PM_StartWork_TS:            ' PM_O.PM_StartWork_TS
	SAY 'PM_End_TS:                  ' PM_O.PM_End_TS
	SAY 'PM_Duration:                ' PM_O.PM_Duration
	SAY 'PM_Initialization:          ' PM_O.PM_Initialization      
	SAY 'PM_Waiting_Source:          ' PM_O.PM_Waiting_Source       
	SAY 'PM_Reading_Source:          ' PM_O.PM_Reading_Source      
	SAY 'PM_Writing_Target:          ' PM_O.PM_Writing_Target        
	SAY 'PM_Reading_Structures:      ' PM_O.PM_Reading_Structures    
	SAY 'PM_Reading_Dictionaries:    ' PM_O.PM_Reading_Dictionaries  
	SAY 'PM_CDC_Exit:                ' PM_O.PM_CDC_Exit             
	SAY 'PM_Last_NearRealTime_Gap:   ' PM_O.PM_Last_NearRealTime_Gap
	SAY 'PM_Last_NearRealTime_Gap_TS:' PM_O.PM_Last_NearRealTime_Gap_TS
	SAY 'PM_Max_NearRealTime_Gap:    ' PM_O.PM_Max_NearRealTime_Gap
	SAY 'PM_Max_NearRealTime_Gap_TS: ' PM_O.PM_Max_NearRealTime_Gap_TS
END