How to report on dynamic and static SQL history in Sysview for DB2

Article Id: 132160

Status: Published

Updated On: 14-05-2019 08:22

Products:

CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Database Detector for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction:

In Sysview for DB2, dynamic and static SQL data collection is active ( IFCID 1041, 1043 and IQL-IFCID400 = YES). How can we report on this?

Environment:

Release:
Component: IDB2

Resolution:

With the collection of fcids 316, 317 and 401 enabled, and HIST-STAT-RECS having 316 and 401 specified, the unload process of the history files (UNLDTYP=ALL), will contain the SQL data for subsequent processing. The Batch Report Writer process can be used to report on this unloaded data (look at batch reports starting with BTDSQ* and BTSSQ*).