The supplied request DSEXTNDS returns a syntax error causing failure during Insight DC startup.

book

Article ID: 6291

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

While starting a new release Data Collector for CA SYSVIEW Performance Monitor for DB2 for z/OS , the IQL requests DSEXTNDS and EXCP0258 both return syntax errors due to referencing a field "DATASET-EXTEND-LIMIT" which is not found.

Cause

The Global variable DATASET-EXTEND-LIMIT whose definition is contained in hlq.CDBATREQ(THRESHDS) had not been defined.
This is achieved via execution of this IQL request prior to the execution of these two dependant IQL requests.

Environment

DB2 for Z/OS

Resolution

The hlq.CDBATREQ(EXCP0258) contains this documentation line:
* DECLARE GLOBAL DATASET-EXTEND-LIMIT in THRESHDS

Looking in hlq.CDBATREQ(THRESHDS) there is a block to declare this variable:


***** Thresholds used in only EXCP0258 *********************************
* Dataset extended, nn % of max size/extends/vols EXCEPTION NAME
* DSN <data-set-name> EXCP0258
DECLARE GLOBAL DATASET-EXTEND-LIMIT (N3.2) = 75.00

In order to have this variable available to those other IQL requests Stop and Start the THRESHDS requests and then retry EXCP0258 and DSEXTND.

Also review the REQLIB= data collector sysparm and ensure that there are no old copies of THRESHDS in the concatenation.
Verify that no old release libraries are being referenced in the concatenation.

Additional Information


R19 Release CA SYSVIEW Performance Monitor for DB2 for z/OS:  Section: Tuning IQL Exception Thresholds