CA SYSVIEW Performance Monitor for DB2 for z/OS: The supplied request DSEXTNDS returns a syntax error causing failure during Insight DC startup.

book

Article ID: 6291

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS

Issue/Introduction

While starting a new release Data Collector for CA SYSVIEW Performance Monitor for DB2 for z/OS(IDB2) , 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

Release : R19, R20

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


See

R20 Tuning IQL Exception Thresholds

R19 Tuning IQL Exception Thresholds

Startup Parameters - REQLIB