IDB2 batch report to produce daily transaction HWM
Article ID: 220531
Database Management for DB2 for z/OS - Performance Suite
SYSVIEW Performance Management Option for DB2 for z/OS
Need assistance to create IQL to produce a daily HWM transaction IN_Db2_response time by Authid and correlation between 8 am and 6 pm from weekly SMF extract.
Release : 20.0
Component : CA SYSVIEW Performance Management Option for DB2 for z/OS
- Take a look at the SYSSTATS panel verify.
- Use SYSSTATS as a template to create the desired IQL.
- Add any field missing from SYSSTATS needed to customized the IQL.
- Test it for syntax or further customized.