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

Document ID : KB000006291
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Environment:
DB2 for Z/OS
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.

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: