Sysview for Db2 IQL Request Dataset is in use by Data Collector
search cancel

Sysview for Db2 IQL Request Dataset is in use by Data Collector

book

Article ID: 20019

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

A Sysview for Db2 for z/OS (IDB2) request was started. Within the IQL request, an output dataset is allocated via the REVIEW statement.
When the request is stopped attempts to browse the output dataset fails due to the IDB2 Data Collector having an exclusive hold on it.

Resolution

It is the IQL REVIEW statement with a disposition of MOD that is placing the dataset under the exclusive control of the Data Collector
(allowing for the 'review' of the output within the IDB2 TSO session).  To utilize the REVIEW statement with the ability to view the dataset
outside of IDB2 a disposition of SHR should be used instead of MOD. Or, in lieu of REVIEW use either OUTFILE or PRINT DSN.