DSNP011I csect-name - MEDIA MANAGER SERVICES ERROR FOR data-set-name. MMRC=cccccccc DSMRC=ffffffff CONNECTION-ID=connection-id, CORRELATION-ID=correlation-id, LUW-ID=logical-unit-of-work-id =token
Explanation
The MMRC is the return code that Db2 received from media manager services. Refer to the appropriate MVS publication for a description of these codes. DSMRC is a DSM reason code that indicates which of the media manager services functions, update or extend, failed. The message is from CSECT 'DSNPmmmm' of the data space manager (DSM). The connection ID, correlation ID, and logical-unit-of-work ID (LUW-ID) identify the user or application that encountered the problem. Correlation IDs beginning with '0nn', where nn is a number, identify system agents.
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.
System action
The 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
DSM messages are directed to either the database administrator (DBA) or the system administrator. However, they can request that the operator issue an MVS WRITELOG operator command (for example, 'W A') to obtain MVS SYSLOG output. The SYSLOG sometimes contains media manager messages that might be helpful to the DBA or system administrator in determining why space could not be allocated.
System programmer response
This message might be preceded by one or more IEC or ICY messages on the console or in SYSLOG. These messages help to determine what happened and what action to take.
Problem determination
See Problem Determination for message DSNP001I for this information.