DSNP016I CREATE FAILED FOR pageset-name. RC=rrrrrrrr CONNECTION-ID=xxxxxxxx, CORRELATION-ID=yyyyyyyyyyyy, LUW-ID=logical-unit-of-work-id =token

Explanation

Creation of a table space or index space failed in the data space manager (DSM) for the reason given in RC. The format of the pageset-name value is dbname.tiname.instance, 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 reason code and preceding messages, and correct it, if possible.

Problem determination

See Problem Determination for message DSNP001I for this information.