Replacing IBM DB2 Omegamon with CA SYSVIEW for DB2 monitor and I need to have the same level of reporting on as it was for Omegamon.
With a -DISPLAY TRACE (*) command I see there are IFCIDs records that I need to know to create some reports that are not in the output.
DSNW127I ]DSNE CURRENT TRACE ACTIVITY IS -
TNO TYPE CLASS DEST QUAL IFCID
01 STAT 01,03,04,05, SMF NO
02 ACCTG 01,02 SMF NO
03 MON 30 OP1 NO 003,006,007,008,009,020,023,024,025
04 MON 01,02,03,05, OP1 NO
For example, looking for trace records IFCID 106, 202, and 230 which will help to capture the historical ZPARM values but the values are not in the output.
Release : 20.0
Component : CA Insight Database Performance Monitor for DB for z/OS
The MONITOR TRACE will only collect asynchronous IFCIDs that are placed by DB2 into the READA buffer. Records that can only be obtained synchronously by the IFI READS function will not be in the list.
Here is a link the the list of READS trace records:
Note there was the following in the CA SYSVIEW for DB2 Data Collector output:
DBG04006I DSNE 13:41:53 FOLLOWING IFCIDS ARE USED BY REQUEST NAMED HSPARMS :
DBG04005I DSNE 13:41:53 START SUCCESSFUL FOR REQUEST HSPARMS .
DBG04006I DSNE 13:41:53 FOLLOWING IFCIDS ARE USED BY REQUEST NAMED HSPRMBP :
DBG04005I DSNE 13:41:53 START SUCCESSFUL FOR REQUEST HSPRMBP .
DBG04006I DSNE 13:41:53 FOLLOWING IFCIDS ARE USED BY REQUEST NAMED HSPRGBP :
And you can display the 'DB2 Subsystem Parameters History' panel from Main Menu.
2 System History
Select an interval.
3 System Parameters (106, 202, 230)