IQL FOR QWSB data Generate Batch Report

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Since the QWSB data is currently not available in the archive tables, what IQL request(s) can be executed against the  SMF data files to produce a batch job output of the QWSB data? 

 

Environment

Release:
Component: CIDB

Resolution

The following reports contain QWSB data: 
ARCISTD 
ARCISTS 

BTSTASM1 
BTSTATR1 
The Archive tables (first two reports) contain the QWSB fields and the other two are classic batch reports - summary and trace.