DSNP005I csect - COULD NOT REMOVE EXCESS VOLUMES FROM CANDIDATE LIST OF data-set-name CONNECTION-ID=xxxxxxxx, CORRELATION-ID=yyyyyyyyyyyy, LUW-ID=logical-unit-of-work-id=token
Explanation
Volumes from a storage group were entered in the data set's candidate list and could not be removed by CSECT 'DSNPmmmm' after some data space manager (DSM) operation. 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.
This is not a major problem. However, the data set will not properly reflect subsequent deletions from the volume list in its storage group (via ALTER STOGROUP command in SQL), because the data set's integrated catalog facility (ICF) catalog entry still contains the volume serial numbers.
If needed, the storage group in question can be identified by issuing an SQL SELECT to get information about the table space or index that is identified by the third and fourth qualifiers (database name, table space name) in the data set name.
System action
Operation continues.
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
Look for associated DSM and access method services messages preceding this one to get additional information. Attempt an ALTER REMOVEVOLUMES access method services command, if appropriate, after issuing a LISTCAT to see which volumes are recorded as 'candidate' in the integrated catalog facility (ICF) catalog.
Problem determination
See Problem Determination for message DSNP001I for this information. (However, there should not be a need for VTOC or SYSLOG information for this case.)