How to report on dynamic and static SQL history in Sysview for DB2
Article ID: 132160
Updated On: 10-06-2023
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
In Sysview Performance Management Option for Db2 for z/OS (IDB2), dynamic and static SQL data collection is active
(IFCID 1041, 1043 and IQL-IFCID400 = YES). How to report on this captured detail?
Resolution
With the collection of IFCIDS 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*).
Feedback
Was this article helpful?
Yes
No
Powered by
