IQL FOR QWSB data Generate Batch Report
search cancel

IQL FOR QWSB data Generate Batch Report

book

Article ID: 116857

calendar_today

Updated On:

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.