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

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

While starting a new release Data Collector for 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.

Environment

Release : R20

DB2 for Z/OS

Cause

The Global variable DATASET-EXTEND-LIMIT whose definition is contained in hlq.CDBATREQ(THRESHDS) had not been defined.

Resolution

This is achieved via execution of this IQL request prior to the execution of these two dependant IQL requests.
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

Startup Parameters - REQLIB