Insight IQL Request's Dataset is in use by Data Collector
search cancel

Insight IQL Request's Dataset is in use by Data Collector

book

Article ID: 20019

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS 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 Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

An Insight 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 Insight Data Collector having an exclusive hold on it.

Solution:

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.

Environment

Release: BINDAN00200-15-Bind Analyzer-for DB2 for z/OS
Component: