DSNP017I RESET FAILED FOR pageset-name. RC=reason-code CONNECTION-ID=connection-id, CORRELATION-ID=correlation-id, LUW-ID=logical-unit-of-work-id =token

Explanation

Reset failed in the data space manager (DSM) subcomponent of Db2 for a table space or index space for the reason that is indicated by the RC=reason-code value.) The format of the pageset-name value is dbname.tiname, where dbname is the database name and tiname is the table space or index space name.

This message identifies the function that was in progress at the time of a failure. The specific failure is usually identified by a preceding message. The connection ID, correlation ID, and logical-unit-of-work ID (LUW-ID) identify the user or application that encountered the problem.

A LUW-ID of '*' indicates that the thread does not have a 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.

Messages that have the same connection ID, correlation ID, and LUW-ID relate to the same user. This makes it possible to scan a number of DSNP-prefixed messages and group activities involving a given user. Correlation IDs beginning with '0nn', where 'nn' is a number, identify system agents.

System action

DSM terminates its actions associated with the current SQL request. Higher level functions might terminate the current SQL request or the unit of recovery that issued the request.

Operator response

This message is directed to the database administrator or the system administrator. Bring it to that person's attention if it appears on the MVS operator's console. The installation should consider directing Db2 messages to a console other than the operator's console.

System programmer response

Investigate the problem indicated by the reason code and preceding messages, and correct it, if possible.

Problem determination

See Problem Determination for message DSNP001I for this information.