DSNP008I csect-name- REQUIRED USER-DEFINED DATA SET NOT AVAILABLE-data-set-name RC=reason-code CONNECTION-ID=connection-id, CORRELATION-ID=correlation-id, LUW-ID=logical-unit-of-work-id=token

Explanation

One of the following actions applied against user-defined data sets failed in CSECT 'DSNPmmmm' of the data space manager (DSM):
  • Create table space or index
  • Extend table space or index
  • Process the SQL ALTER DATABASE statement
  • Process the REORG TABLESPACE utility with SHRLEVEL REFERENCE or CHANGE
Correlation IDs beginning with '0nn', where 'nn' is a number, identify system agents.

One or more of the data sets could not be accessed for the reason indicated by RC. The connection ID, correlation ID, and logical-unit-of-work ID (LUWID) identify the user or application that encountered the problem.

The value of the LUWID is alogical-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 having the same connection ID, correlation ID, and LUWID relate to the same user. This makes it possible to scan a number of DSNP-prefixed messages and group activities involving a given user.

If the name of the data set in the message is different from the name of the original data set (for example, '....A002' instead of '...A001'), a new data set might need to be created. A different name indicates that the original data set exceeded its limit.

System action

Db2 terminates its actions associated with the current SQL request or utility. Db2 might terminate the current SQL request or utility 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

The return code description might indicate that one of the following actions needs to be performed or it indicates the necessary steps:
  • If the data set does not exist, create it before attempting the create table space/index or extend data set again.
  • If the data set shareoptions are incorrect, modify the shareoptions with access method services (AMS).
  • The appropriate AMS command is ALTER SHAREOPTIONS.

Problem determination

See Problem Determination for message DSNP001I for this information.

Severity

8 (error)