Db2 manager messages (CSQ5...)

CSQ5001I: csect-name Connected to Db2 db2-name
Explanation: The queue manager has successfully established a connection to the named Db2 subsystem.
System action: Processing continues.
System programmer response: None.

CSQ5002E

csect-name Connection to Db2 using connect-name failed, RC=return-code reason=reason

Explanation

The queue manager's attempt to establish a connection to the named Db2 subsystem failed.

System action

Queue manager startup is terminated.

System programmer response

This is normally an authorization error.

Consult the Db2 for z/OS Messages and Codes manual for an explanation of the codes and attempt to resolve the problem.

CSQ5003A: csect-name Connection to Db2 using connect-name pending, no active Db2
Explanation: The queue manager is waiting for an eligible Db2 subsystem to become active so that a connection can be established. Alternatively, RRS is inactive or was started after the Db2 subsystems.
System action: The queue manager waits for an eligible Db2 subsystem to become active.
System programmer response: Check whether the Db2 subsystem(s) are active. If not then start them. If they are active, ensure RRS is active and check that it was started prior to the Db2 subsystems.

CSQ5004E

csect-name Db2 table entry for queue manager in queue sharing group qsg-name is missing or incorrect

Explanation

During startup the queue manager was unable to find its entry in the Db2 administration tables, or the entry was incorrect.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50013'.

System programmer response

Check that a queue manager record exists in the Db2 tables for the Db2 data-sharing group specified. Check the QSGDATA system parameter specifies the correct Db2 data-sharing group. If so, check that a queue manager entry exists in the CSQ.ADMIN_B_QMGR table.

If we are migrating from a previous release of IBM MQ, check also that we have updated the Db2 tables to the format for the current release. For information about migration and compatibility between releases, see Maintain and migrate.

CSQ5005E

csect-name Queue manager release level is incompatible with queue sharing group

Explanation

The release level of the queue manager that is being started is incompatible with that of other members of the queue sharing group.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50029'.

System programmer response

Verify that the correct load libraries are being used and that the queue sharing group information in the system parameters has been specified correctly. Also use the queue sharing group utility (CSQ5PQSG) to verify that the queue manager has been defined correctly in the Db2 administration tables, using the MIGRATE QSG option. Ensure that we use the same version of IBM MQ for the utility, as was used for running the queue manager.

For information about migration and compatibility between releases, see Queue sharing group migration.

If the MIGRATE QSG option results show queue managers that no longer exist, but are still in the Db2 tables, use the REMOVE QMGR option or, if necessary, the FORCE QMGR option.

CSQ5006E: csect-name Data-sharing groups differ
Explanation: A mismatch has been detected between the Db2 data-sharing group specified on the QSGDATA system parameter and the queue manager entry in the CSQ.ADMIN_B_QMGR table.
System action: The queue manager terminates with completion code X'6C6' and reason code X'00F50006'.
System programmer response: The queue sharing group name specified on the QSGDATA system parameter must match that in which the queue manager is defined in the Db2 CSQ.ADMIN_B_QMGR table.

CSQ5007E

csect-name RRSAF function function failed for plan plan-name, RC=return-code reason=reason syncpoint code=sync-code

Explanation

A non-zero or unexpected return code was returned from an RRSAF request. The Db2 plan involved was plan-name.

System action

If the error occurs during queue manager startup or reconnect processing, the queue manager terminates with completion code X'6C6' and reason code X'00F50016'. Otherwise, an error message is issued and processing continues.

System programmer response

Determine the cause of the error using the RRS return and reason code from the message.

Consult the Db2 for z/OS Messages and Codes manual for an explanation of the codes and attempt to resolve the problem.

CSQ5008E

csect-name Db2 db2-name is not a member of data-sharing group dsg-name

Explanation

The Db2 subsystem to which the queue manager has connected is not a member of the Db2 data-sharing group specified on the QSGDATA system parameter.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50007'.

System programmer response

Ensure that the Db2 subsystem to which the queue manager has connected is a member of the data-sharing group specified on the QSGDATA system parameter.

Issue the Db2 command DIS GROUP to the Db2 subsystem and check the data-sharing group name matches the data-sharing group name on the QSGDATA system parameter.

CSQ5009E

csect-name SQL error for table table-name, code=SQL-code state=SQL-state, data=d1 d2 d3 d4 d5

Explanation

A non-zero or unexpected SQL return code was returned from a Db2 SQL request.

System action

The requested operation fails. Processing continues, but the failed request may result in further errors occurring. In some circumstances, the queue manager terminates with completion code X'6C6' and reason code X'00F50014'.

System programmer response

Determine the reason for the SQL error and correct the problem.

Consult the Db2 for z/OS Messages and Codes manual to determine the reason for the SQL error.

CSQ5010E

csect-name XCF IXCQUERY member error, RC=return-code reason=reason

Explanation

The queue manager received an unexpected return code from an IXCQUERY request.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50017'.

System programmer response

Determine the reason for the unexpected error and correct the problem.

Consult the z/OS MVS™ Programming: Sysplex Services Reference manual for an explanation of the return and reason code from the IXCQUERY request.

This message may occur if one or more of the queue managers in a queue sharing group (QSG) do not have a member entry in the XCF group for the QSG.

Enter the following z/OS command substituting the QSG name for xxxx:

D XCF,GRP,CSQGxxxx,ALL

This will list the members of the XCF group. If any queue managers are defined as a member of the QSG, but do not have an entry in the XCF Group, use the ADD QMGR command of the CSQ5PQSG utility to restore the XCF group entry for that queue manager. The utility should be run for each queue manager which does not have an entry in the XCF group.

CSQ5011E

csect-name XCF IXCJOIN group error, RC=return-code reason=reason

Explanation

The queue manager received an unexpected return code from an IXCJOIN request.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50019'.

System programmer response

Determine the reason for the unexpected error and correct the problem.

Consult the z/OS MVS Programming: Sysplex Services Reference manual for an explanation of the return and reason code from the IXCJOIN request.

CSQ5012E

csect-name XCF IXCQUIES group error, RC=return-code reason=reason

Explanation

The queue manager received an unexpected return code from an IXCQUIES request.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50021'.

System programmer response

Determine the reason for the unexpected error and correct the problem.

Consult the z/OS MVS Programming: Sysplex Services Reference manual for an explanation of the return and reason code from the IXCQUIES request.

CSQ5013E

csect-name XCF IXCSETUS error, RC=return-code reason=reason

Explanation

The queue manager received an unexpected return code from an IXCSETUS request.

System action

The queue manager terminates with completion code X'6C6' and reason code X'00F50018'.

System programmer response

Determine the reason for the unexpected error and correct the problem.

Consult the z/OS MVS Programming: Sysplex Services Reference manual for an explanation of the return and reason code from the IXCSETUS request.

CSQ5014I: csect-name Connection to db2-name lost, Db2 terminated abnormally
Explanation: The queue manager received an abnormal termination notification from the Db2 subsystem to which it is connected.
System action: The queue manager will clean up its connection to the Db2 subsystem and attempt to reconnect. If a Db2 group attach name was specified on the QSGDATA system parameter a connection to a different Db2 may occur.
System programmer response: Determine the reason for the Db2 abnormal termination. Correct the problem and attempt to restart the Db2 subsystem.

CSQ5015I: csect-name Connection to db2-name lost, Db2 shut down forcibly
Explanation: The queue manager received a STOP FORCE termination notification from the Db2 subsystem to which it is connected.
System action: The queue manager will clean up its connection to the Db2 subsystem and attempt to reconnect. If a Db2 group attach name was specified on the QSGDATA system parameter a connection to a different Db2 may occur.
System programmer response: Determine the reason for the Db2 forcible stop. Restart the Db2 subsystem.

CSQ5016I: csect-name Connection to db2-name quiescing, Db2 terminating
Explanation: The queue manager received a STOP QUIESCE termination notification from the Db2 subsystem to which it is connected.
System action: The queue manager will quiesce all Db2 server tasks and disconnect from the Db2 subsystem so that it can shut down. It will then attempt to reconnect. If a Db2 group attach name was specified on the QSGDATA system parameter a connection to a different Db2 may occur.
System programmer response: Restart the Db2 subsystem so that shared queue operations can resume.

CSQ5019I: csect-name Disconnected from Db2 db2-name
Explanation: The queue manager has successfully disconnected from the Db2 subsystem.
System action: If the disconnect is due to a Db2 STOP MODE(QUIESCE) the queue manager will attempt to reconnect to the Db2 subsystem.
System programmer response: None.

CSQ5020E: csect-name SQL error, table table-name not defined in Db2
Explanation: The queue manager attempted to access one of its Db2 tables. Db2 has returned an SQL code indicating the table does not exist.
System action: The request fails and processing continues.
System programmer response: Check that all MQ tasks to set up the Db2 environment completed successfully and that the correct Db2 data-sharing group name was specified on the QSGDATA system parameter.

CSQ5021E: csect-name SQL error, table table-name index not built in Db2
Explanation: The queue manager has attempted to access one of its Db2 tables. Db2 has returned an SQL code indicating that the index for the specified table has not been built.
System action: The request fails and processing continues.
System programmer response: Check that all IBM MQ tasks to set up the Db2 environment completed successfully and that the correct Db2 data-sharing group name was specified on the QSGDATA system parameter.

CSQ5022I: csect-name Pending connection to Db2 using connect-name ended, queue manager terminating
Explanation: The outstanding connection pending request to Db2 has been terminated due to a STOP QMGR request.
System action: The pending connect to Db2 is canceled and queue manager termination continues.
System programmer response: None.

CSQ5023E

csect-name SQL error, failed to access table table-name

Explanation

An attempt by the queue manager to access one of its tables was returned an SQL code indicating that access to the named resource failed.

System action

The request fails and processing continues.

System programmer response

This message will be followed by message CSQ5009E which contains full details of the information returned from Db2 which should be used in conjunction with messages on the Db2 log to diagnose the problem.

The most likely cause of this problem is contention for a Db2 resource, especially on a heavily-used system. If so, the problem is temporary; retry the action that gave the error.

If not, and the problem persists, determine from the message and the Db2 log the resource concerned and perform the recovery actions necessary to unlock the resource. Such a problem could be caused by a Db2 failure while updating one of the Db2 tables, which will be indicated in the Db2 log.

CSQ5024E: csect-name Unable to update queue manager status, RC=return-code
Explanation: During startup and shutdown processing the queue manager attempts to update its status in the CSQ.ADMIN_B_QMGR table. This attempt failed.
System action: None. Startup/shutdown processing continues.
System programmer response: None.

CSQ5025E: csect-name SQL error, function function code=SQL-code
Explanation: A call to the SQL function specified by function returned a non-zero code specified by SQL-code.
System action: Processing continues.
System programmer response: Note the values contained in the message, and contact the IBM support center. Consult the Db2 for z/OS Messages and Codes manual for more information about the error code.

CSQ5026E

csect-name Unable to access Db2, RRS is not available

Explanation

The queue manager tried to access Db2, but RRS is not available.

System action

If this occurs during queue manager initialization, the queue manager waits for RRS to become available.

If this occurs at other times, the queue manager terminates its connection to Db2, and then tries to reconnect. Some queue sharing group functions will not be available until RRS is restarted and the connection to Db2 is reestablished.

System programmer response

Start (or restart) RRS.

CSQ5027E: csect-name SQL error for table table-name, deadlock or timeout occurred (code=SQL-code)
Explanation: An SQL call returned a non-zero code indicating that a deadlock or timeout condition occurred.
System action: The request fails and processing continues.
System programmer response: Retry the command or application involved. If the problem persists, contact the IBM support center. Consult the Db2 for z/OS Messages and Codes manual for more information about the error code.

CSQ5028E

csect-name Unable to access Db2, RRS connection limit exceeded

Explanation

The queue manager tried to access Db2, but RRS has reached the limit of allowed concurrent connections (IDENTIFYs).

System action

If this message occurs during queue manager initialization, the queue manager waits for an RRS connection to become available.

If this message occurs at other times, the queue manager terminates its connection to Db2, and then tries to reconnect. Some queue sharing group functions are not available until RRS is restarted and the connection to Db2 is reestablished.

System programmer response

Adjust the RRS connection limit if required, then start (or restart) RRS.

Ensure that the Db2 system parameter controlling the maximum number of concurrent users and connections is correct. The Db2 parameter is Max Batch connect (CTHREAD) on the thread management panel DSNTIPE.

See the Db2 for z/OS documentation for an explanation of this Db2 parameter to resolve the problem.

CSQ5029E

csect-name Operation on Db2 table table-name failed

Explanation

An operation requested for the named Db2 table failed. For example, the table might be full, or there might be insufficient storage available to perform the request.

This is most likely to occur when writing data to one of the tables that IBM MQ uses to store large shared messages.

System action

Message CSQ5009E is issued giving details of the associated SQL error codes. The requested operation fails and processing continues. The message or other data is not written to the table.

System programmer response

Investigate the cause of the problem as indicated by the SQL codes in message CSQ5009E.

If the table is one of the tables used for storing large shared messages, and the problem is due to insufficient storage, try the operation again later, as the condition might be temporary. If the problem is because the table is full, remove some of the messages; for example, start an application that retrieves and processes the messages. Use the MQ DISPLAY GROUP command to check if there are any obsolete messages in the table space, and delete them. If necessary, increase the size of the table.

CSQ5032I: csect-name Connection to Db2 db2-name in data-sharing group dsg-name is suspended
Explanation: This is issued in response to a SUSPEND QMGR FACILITY( Db2) command if it completed successfully.
System action: All Db2 activity is suspended for the queue manager named, and the connection to Db2 is broken.
System programmer response: Use the RESUME QMGR FACILITY( Db2) command when ready to resume Db2 activity.

CSQ5033I: csect-name Connection to Db2 db2-name in data-sharing group dsg-name is resumed
Explanation: The RESUME QMGR FACILITY( Db2) command completed successfully, reestablishing the connection to Db2.
System action: Db2 activity is resumed for the queue manager named.

CSQ5034I: csect-name Suspend or resume Db2 request pending
Explanation: A SUSPEND or RESUME QMGR FACILITY( Db2) command was issued, but such a request is already pending.
System action: None.
System programmer response: Wait until the pending request completes, then reissue the command if necessary.

CSQ5035I: csect-name Connection to Db2 db2-name in data-sharing group dsg-name already suspended
Explanation: A SUSPEND QMGR FACILITY( Db2) command was issued, but the connection to the named Db2 subsystem is already suspended.
System action: None.

CSQ5036I: csect-name Connection to Db2 db2-name in data-sharing group dsg-name not suspended
Explanation: A RESUME QMGR FACILITY( Db2) command was issued, but the connection to the named Db2 subsystem is not suspended.
System action: None.

CSQ5037I: csect-name New function not available, incompatible queue managers in the queue sharing group
Explanation: An attempt was made to start the queue manager in new function mode, but some queue managers in the queue sharing group are either not at a version that is sufficient to coexist with the new functions provided in this level of code, have not been started in new function mode, or do not have compatible QSGDATA parameters.
System action: Processing continues, but certain functions will be unavailable.
System programmer response: Ensure that all of the queue managers in the queue sharing group, that are at a version earlier than Version 9.1.0, have been started in new function mode at the appropriate version, then restart the queue manager. See the OPMODE documentation for the earlier version, for information on how to achieve this.

CSQ5038I: csect-name Service task service-task has been unresponsive since hh.mm.ss.nnnnnn. Check for problems with Db2
Explanation: The queue manager has detected a service task service-task that is taking too long to process a request that started at hh.mm.ss.nnnnnn.
System action: Processing continues, but certain functions might be unavailable.
System programmer response: Investigate if there are any problems with Db2 or RRS that prevent them responding to IBM MQ requests. For example, the Db2 CTHREAD limit has been exceeded, or Db2 is running slowly because it is short of resources like CPU, I/O capacity, or storage; or Db2 is waiting for log space.

CSQ5039I: csect-name SQL error information
Explanation: An SQL error has occurred. Additional diagnostic information direct from Db2 follows.
System action: See the preceding Db2 manager error message.
System programmer response: Determine the reason for the SQL error and correct the problem.

CSQ5040E

Active log data set xxx.DS01 is encrypted, but active log data set encryption is not supported by all QSG members

Explanation

The named active log data set has been protected by encryption and a queue manager in the same queue sharing group is running at a version of IBM MQ that does not support active log data set encryption.

Active log data set encryption is supported from IBM MQ for z/OS Version 9.1.4.

Each queue managers in a QSG needs to be able to read the log data sets of every other queue manager in the same QSG

System action

Queue manager start up is abnormally terminated.

System programmer response

Ensure all queue managers in the QSG have been started at a version of IBM MQ that supports active log data set encryption prior to configuring active data set encryption for any queue manager in the QSG.

Either start each queue manager in the QSG at the correct level or reconfigure active logs without data set encryption.

CSQ5100I: DISPLAY GROUP report ...
Explanation: This message is the initial response to the DISPLAY GROUP command. It is followed by message CSQ5102I which is a formatted report of the queue managers in the group.
System action: Processing continues normally.

CSQ5102I

Queue managers in group group-name

Explanation

This message is part of the responses to the DISPLAY GROUP command. It provides information about each queue manager in the group, as follows:

  Name Num Prefix  Status    Ver  Db2    Connection  name num cpf     qmgr-stat vrm db2-id conn-stat ⋮  End of queue managers report

where:

name

The name of the queue manager.

num

The internally generated number of the queue manager in the group.

cpf

The command prefix of the queue manager.

qmgr-stat

The current status of the queue manager:

ACTIVE: The queue manager is running.
INACTIVE: The queue manager is not running, having terminated normally.
FAILED: The queue manager is not running, having terminated abnormally.
CREATED: The queue manager has been defined to the group, but has not yet been started.
UNKNOWN: The status cannot be determined.

vrm

The function level of the queue manager. The value is a 3-digit number, where:

v: is the version number
r: is the release number
m: is the modification number.

db2-id

The name of the Db2 subsystem or group attachment to which the queue manager connects.

conn-stat

The current status of the connection to Db2:

ACTIVE: The queue manager is running and connected to Db2.
PENDING: The queue manager is running but not connected because Db2 has terminated normally.
FAILED: The queue manager is running but not connected because Db2 has terminated abnormally.
INACTIVE: The queue manager is not running and not connected to Db2.
UNKNOWN: The status cannot be determined.

Exceptionally, the last line might be either:

  Report terminated, too many lines

if the report was generated in response to a command from a z/OS console and more than 253 response lines were generated. Only 253 response lines are returned.

  Report terminated

if there was an error in obtaining the information. The error is described in the following messages.

System action

Processing continues normally.

CSQ5103I

Obsolete messages in Db2 for group group-name

Explanation

Messages are normally deleted automatically from Db2, but in exceptional circumstances obsolete messages can remain. This identifies such messages, as follows:

  LEID msg-id ⋮  End of messages report

where:

msg-id: is the identifier of the message.

Exceptionally, the last line might be either:

  Report terminated, too many lines

if the report was generated in response to a command from a z/OS console and more than 253 response lines were generated. Only 253 response lines are returned.

  Report terminated

if there was an error in obtaining the information.

System action

Processing continues normally.

System programmer response

Delete the obsolete messages from Db2. For example, use SPUFI to issue the SQL command

  DELETE FROM CSQ.ADMIN_B_MESSAGES     WHERE QSGNAME = 'group-name' AND     LEID = 'msg-id';

CSQ5113I: Queue manager is not in a queue sharing group
Severity: 0
Explanation: A command that requires a queue sharing group was entered, but the queue manager is not in a group.
System action: The command is not actioned.

CSQ5116E: call-name call failed, rc=rc reason=reason
Severity: 8
Explanation: During processing for a DISPLAY GROUP command, a coupling facility services call used to get information failed. rc is the return code and reason is the reason code (both in hexadecimal) from the call.
System action: Processing is terminated. A following message is issued to identify which type of information was being obtained.
System programmer response: See the z/OS MVS Programming Sysplex Services Reference. manual for information about the return and reason codes from the call.

CSQ5117E

Information not available for group group-name - reason

Severity

Explanation

During processing for a DISPLAY GROUP command, information could not be obtained for the group, for the reason indicated:

ERROR: A coupling facility services call failed, as indicated in the preceding CSQ5116E message.
CHANGED: The group size has changed.

System action

Processing is terminated.

System programmer response

Resolve the problem accordingly.

Parent topic: Messages for IBM MQ for z/OS