IQL for QWSB data generate batch report in Sysview for Db2
search cancel

IQL for QWSB data generate batch report in Sysview for Db2

book

Article ID: 116857

calendar_today

Updated On: 10-10-2023

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Since the QWSB data is currently not available in the archive tables, what Sysview Performance Management Option for Db2 for z/OS (IDB2)
IQL request(s) can be executed against SMF data files to produce a batch job output of the QWSB data? 

 

Resolution

The following IDB2 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).