Previous Topic: DASM - DISASSEM Command, DATE -  DATE Command MessagesNext Topic: DCOM - DATACOM commands


DB20 - DB2 Command Messages

DB20001E <ssid> <service-name> failed, <reason>

An internal DB2 collection service failed.

DB20002I <dir> connected to agent <agt> on port CA Portal with socket <socket>

A successful connection was made to XNet agent <agt> using director ID <dir> on port CA Portal with socket number <socket>

DB20003I <dir> disconnected from agent <agt> - socket <socket>

The director <dir> connection to XNet agent <agt> was disconnected from socket number <socket>

DB20004E Agent <agt> request <req> failed - rc <rc> rsn <rsn> - <agtmsg>

A request <req> was sent to agent <agt> and the request failed with an agent return code of <rc> and reason code of <rsn>. The <agtmsg> is message data returned from the agent.

DB20005E Agent <agt> request <req> failed - socket closed by peer

A request <req> was sent to agent <agt> and the request failed. No data was returned indicating that the socket was closed by the XNet server.

DB20006E Agent <agt> request <req> failed - XNet reason <code> <desc>

A request <req> was sent to agent <agt> and the request failed with XNet reason <code>. If the reason code is known <desc> will describe the reason code, otherwise, it is blank.

XNet reason 00000121 - User ID verify error

If this particular reason code has been given, this indicates that the a valid PassTicket has been generated, but it has not been accepted during User ID/Password validation processing.

Two possible reasons for this are:

  1. A valid XNET-PassTicketApplId was specified but it is for a different Xnet subsystem than what is specified on XNET-Port. Both of these parameters are specified in DB2 PARMLIB.
  2. A valid XNET-PassTicketApplId was specified but it did not match the Xnet PASSNAME parameter (as specified in the Xnet configuration).
DB20007I <xmsg>

XNet request failed. <xmsg> is a message that was returned as part of the reply status.

DB20008E Agent <agt> request <req> Invalid target length <len> for column <col>

A request <req> was sent to agent <agt> and the request response contained a column <col> that could not be processed because the target control block field length <len> was not correct.

DB20009E Agent <agt> request <req> Unknown column type <type> for column <col>

A request <req> was sent to agent <agt> and the request response contained a column <col> that had an unknown column type code of <type>. The request could not be processed.

DB20010E Agent <agt> request <req> Column type <type> not implemented - column <col>

A request <req> was sent to agent <Id> and the request response contained a column <col> that had column type of <type> that has not been implemented.

DB20011I Director <dir> agent <agt> request started

A request was started for director <dir> to agent <agt>

DB20012I Director <dir> agent <agt> request complete

The request for director <dir> to agent <agt> has completed.

DB20013I Elp Tot <1> Ext <2> Int <3>

This is the total external and internal elapsed CPU time used by the request. External time measures time attributable to the XNet agent.

DB20014I Cpu Tot <1> Ext <2> Int <3>

This is the total external and internal CPU time used by the request. External time measures time attributable to the XNet agent.

DB20015E Agent <Id> request <req> response header too <size> <len>

A request <req> was sent to agent <Id> and the request response header was invalid because the length <len> was too small or large.

DB20016E Agent <Id> request <req> unknown response ID <resp_id>

A request <req> was sent to agent <Id> and the request response header contained an unknown response ID <resp_id>

DB20017E Agent <Id> request <req> unexpected response ID <resp_id>

A request <req> was sent to agent <Id> and the request response header contained an unexpected response ID <resp_id>

DB20018E Agent <Id> request <req> sequence sent <seqsend> sequence returned <seqret>

A request <req> was sent to agent <Id> and the request response sequence number <seqret> does not match the sequence number sent <seqsend>.

DB20019E Agent <Id> request <req> response field too small to contain a valid response <len>

A request <req> was sent to agent <Id> and the request response is too small to contain a valid response structure. The length is <len>

DB20020E Agent <Id> request <req> response field revision <rev> not supported

A request <req> was sent to agent <Id> and the request response field revision number <rev> is not supported.

DB20021E Agent <Id> request <req> response field type <type> unexpected

A request <req> was sent to agent <Id> and the request response field type code <type> was unexpected.

DB20022E Agent <Id> request <req> response field too small for response packet header <len>

A request <req> was sent to agent <Id> and the request response field length <len> is too small to contain a response packet header.

DB20023E Agent <Id> request <req> response packet header contains no segments

A request <req> was sent to agent <Id> and the request response packet header indicates there are zero segments in the packet.

DB20024E Agent <Id> request <req> unknown response packet type <type>

A request <req> was sent to agent <Id> and the request response packet type of <type> is unknown.

DB20025E Agent <Id> request <req> query ID sent <idsend> query ID returned <idret>

A request <req> was sent to agent <Id> and the request response packet query ID <idret> does not match the sent query ID <idsend>.

DB20030I Switched to DB2 <ssid> cpf <cpf> in ASID <asid> job <jobname>

This message indicates that the selected DB2 subsystem is now the current target subsystem. DB2 commands are always directed to the CA Insight agent managing the current target DB2 subsystem.

DB20031E No DB2 subsystems found

No DB2 subsystems were found.

DB20032E No active and monitored DB2 subsystem found

While attempting to select a DB2 subsystem, no active DB2 subsystem was found that was being monitored by a CA Insight agent.

DB20033E DB2 subsystem <ssid> not <active|monitored|found>

While attempting to select a DB2 subsystem, the DB2 subsystem was not found, not active, or not being monitored by a CA Insight agent.

DB20034W DB2 not active in ASID <asid> job <jobname>

An attempt to verify the target DB2's asid failed. This can occur if the target DB2 was stopped or restarted before a data collection request was completed.

DB20035W DB2 subsystem <ssid> is not being monitored by a CA Insight agent

This message indicates that the target DB2 subsystem is not being monitored by a CA Insight agent. It is possible that XNET is not currently running.

DB20036W Agent <agt> request <req> column type <type> for column <col> does not match expected type <etype>

A request <req> was sent to agent <agt> and the request response contained a column <col> of type code <type> that did not match the expected type of <etype>. The column could not be converted, but conversion continues with the next column.

DB20037W XNET port was not defined. CA Insight information is unavailable

The XNET port was not defined using the DB2-XNET-Port parameter in the OPTIONS parmlib member. CA Insight for DB2 agent status and information cannot be determined.

DB20038E Agent <agt> request <req> unable to obtain storage length <len> for XNET reply

A request <req> was sent to agent <agt> and the request response buffer length of <len> could not be obtained to receive the response.

DB20039I <dir> connection to agent <agt> on socket <socket> is in error

The director <dir> connection to XNet agent <agt> on socket number <socket> was tested and is in error. The connection will be disconnected and a reconnect will be attempted.

DB20040W <dir> connection to agent <agt> received an agent notify error

An agent notify error message was received from the agent <agt> for director ID <dir>. Check for additional messages that follow for specific reason codes.

DB20041I <action> column type <type> length <len> name <name> data <data>

This is a debug informational message, showing the columns that were found and the <action> taken.

DB20042I Not all rows were received. More data available.

This is a debug informational message,

DB20043E Generation of the Passticket for access to Xnet failed.

Either the Passticket facility is not available or there is a definition problem. Review Passticket setup.

The XNET-PassTicketApplId parameter in the DB2 PARMLIB member is the application name to be used to generate user passtickets to connect to the CA Database Management Solutions for DB2 for z/OS Xnet address space.

This XNET-PassTicketApplId name must match the Xnet PASSNAME parameter in the INITPARM data set for the Xnet address space.