DSNB200I UPDATE VVDS FAILED. DSNAME = dsn, MMRC=cccccccc CONNECTION-ID=xxxxxxxx, CORRELATION-ID=yyyyyyyyyyyy, LUW-ID=logical-unit-of-work-id =token
Explanation
Db2 was unable to update the data set high-used RBA in the VSAM volume data set (VVDS) when it was ready to close a data set that was used by a RECOVER, LOAD, or REORG utility job. The error was detected by the media manager catalog update function that issues system message IEC161I. The dsn indicates the DSNAME of the data set. MMRC is the return code that Db2 received from the media manager catalog update service. Refer to z/OS DFSMSdfp Diagnosis for a description of these codes.
The connection ID, correlation ID, and logical-unit-of-work ID (LUW-ID) identify the user or application that encountered the problem.
An LUW-ID of '*' indicates that the thread does not have an LUW-ID. If the LUW-ID is not an '*', the value is a logical-unit-of-work-id that is assigned to the thread followed by an '=' sign and a token value which can be used in place of logical-unit-of-work-id in any Db2 command that accepts logical-unit-of-work-id as input.
System action
Db2 continues closing this data set. However, the utility job is informed with a 00C2010C 'resource unavailable' reason code. The utility job is left in a failed state.
Operator response
Notify the system programmer.
System programmer response
To determine the cause of the error, refer to system message IEC161I in the appropriate MVS publication. Correct the error, and then notify the user to reinvoke the application.
Problem determination
- Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
- IDCAMS LISTCAT output for the ICF (VSAM) catalog that contains the Db2 subsystem catalog that defined the failing index or table.
- IDCAMS LISTCAT output that shows the attributes of all active log data sets for the Db2 member that failed.