Start of change

DSNU1574I csect-name - ERROR DURING process ON object-type object-qualifier.object-name DSNUM n RETURN CODE X'return-code' REASON CODE X'return-code'

Explanation

The RECOVER utility was invoked for redirected recovery. However, an error or warning condition occurred during processing.

csect-name
The name of the control section that issued the message.
process
The process during which the error or warning occurred. Possible values are:
SCHEMA VERIFY
The schema verification process resulted in an error condition. During this process the table space and table definitions are checked. The current definitions of the source and target much match and any inconsistencies are reported.
TRANSLATE
The translate process resulted in an error condition. During this process, object OBIDs in the pages are translated to the target object OBIDs. This process includes the object OBIDs in the system pages.
SEQUENCE ID INVALIDATION
The process to invalidate the sequence IDs in the Db2 cache for an identity column or XML columns in the target table encountered an issue. For more information about the cache, see Enabling the dynamic statement cache to improve dynamic SQL performance.
XML DOCID COLUMN MAXASSIGNEDVAL
The process to update the MAXASSIGNEDVAL column in the SYSIBM.SYSSEQUENCES catalog table for XML DOCID columns in the target table encountered an issue.
IDENTITY COLUMN MAXASSIGNEDVAL
The process to update the MAXASSIGNEDVAL column in the SYSIBM.SYSSEQUENCES catalog for the identity column in the target table encountered an issue.
object-type
The type of object. Possible values are:
TABLESPACE
Table space
INDEXSPACE
Index space
INDEX
Index
object-qualifier.object-name
The name of the target table space, index space, or index, as a qualified name.
n
The data set number of the object.

DSNUM n is omitted from the message text if either of the following conditions are true:

  • DSNUM is not specified on the RECOVER statement.
  • DSNUM ALL is specified on the RECOVER statement.
X'return-code'
The return code in hexadecimal format.
X'reason-code'
The reason code in hexadecimal format.

System action

For error conditions, if OPTIONS EVENT(ITEMERROR,SKIP) is specified, RECOVER skips the object and continues processing. Otherwise, processing terminates.

For warning conditions, RECOVER processing continues.

System programmer response

Check the RECOVER job output and the z/OS console log (SYSLOG) for other messages that indicate that a Db2 catalog or directory object was not available (resource unavailable). In this case, correct the problem and rerun RECOVER on the objects that received the error or warning.

When warning conditions are received for SEQUENCE ID INVALIDATION, XML DOCID COLUMN MAXASSIGNEDVAL or IDENTITY COLUMN MAXASSIGNEDVAL, the data in the target table is accessible for queries or for unloading, but updates by SQL INSERT statements might fail.

If the error conditions persist, contact IBM® Support.

Severity

4 (warning) or 8 (error)

End of change