IDB2 batch report to produce daily transaction HWM

book

Article ID: 220531

calendar_today

Updated On:

Products

CA Database Management for DB2 for z/OS - Performance Suite CA Sysview Performance Management Option for DB2 for z/OS

Issue/Introduction

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.

 

 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

  1. Take a look at the SYSSTATS panel verify.
  2. Use SYSSTATS as a template to create the desired IQL.
  3. Add any field missing from SYSSTATS needed to customized the IQL. 
  4. Test it for syntax or further customized.