Data Discrepancy between APPL_PGM_DAILY and APPLICATION_DAILY Tables

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite

Issue/Introduction

Deadlock and timeout data are available in the APPLICATION_DAILY table but they are all zeros for APPL_PGM_DAILY table. Data loaded to these tables came from the same SMF file and were loaded using the same process(JCL and IQLs). Why the discrepency between the two?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

If the MONITOR trace classes 7,8, and 10 are not activated, theAPPL_PGM_DAILY tables would have almost no data in them, probably not much more than the package name.

From the DB2 manual for the START TRACE command, and for a MONITOR trace classes 7,8, and 10 are activated to get package details. 

Here is the pertinent information, from the DSNDQTXA macro:

* NOTE2: *

* If accounting class 10 is enabled, a QTXA section will be *

* written per pacakge in IFCID239. The above cited fields are *

* invalid for package detail. *

**********************************************************************/

*/*

MACRO

DSNDQTXA &DSECT=YES

* SCC STATISTICS DATA FOR TYPE 100 SUBTYPE 1 RECORD

* SCC ACCOUNTING DATA FOR TYPE 101 SUBTYPE 0 RECORD

AIF ('&DSECT' NE 'YES').NODESEC

DSNDQTXA DSECT

AGO .MAINLIN

.NODESEC ANOP

DSNDQTXA DS 0D

.MAINLIN ANOP

QTXA DS 0D

QTXADEA DS F Deadlock count

QTXASLOC DS F Number of suspends because of

* lock conflicts

QTXATIM DS F Timeout counts