MSGx keyword

Use this keyword if an error is associated with a Db2 or an IRLM message. If you receive more than one message for one error, search the database using the first message issued. If unsuccessful, search the database using the next message, then the next, and so on.

To see if other messages related to the problem have been issued, check the console sheets that contain Db2 messages, as well as messages issued by other products. If any messages are prefixed with IEC, indicating it was issued by media manager services, check the SYSLOG for messages that identify associated VSAM problems. SYSLOG can also help to diagnose user errors.

Compare the message prefix with those shown in the table below to determine the appropriate procedure to follow.

Table 1. Message prefixes
Prefix Component Procedure
DSN Db2 Follow Procedure for Db2 messages on this page
DXR IRLM Follow Procedure for IRLM messages
DFH CICS® Consult CICS messages
DFS IMS Consult IMS messages and codes
IDC Access method services Consult z/OS MVS IDC messages
IKJ TSO/E Consult z/OS MVS IKJ messages
IST VTAM® Consult z/OS Communications Server: SNA Messages

Procedure for Db2 messages

  1. Check if the name of the CSECT issuing the message appears. This name follows the message number, as shown in the following example.
    DSNW413I s csect_name - ACCOUNTING FACILITY HAS LOST
        DATA RC=y
    DSNJ202I csect_name INSUFFICIENT VIRTUAL STORAGE
        AVAILABLE TO CONTINUE WITH UTILITY.

    No CSECT name appears if only one CSECT can issue this message.

  2. Determine if the message contains any variables, such as return or reason codes.
  3. If no CSECT name appears, build a keyword similar to MSGxxxxxxxx, replacing xxxxxxxx with the message number. Add this to the keyword string. If the message contains any variables, turn to Message modifier keyword. Otherwise, turn to Searching the IBM Support site for known problems and solutions.
      (free format):
      5740XYR00 R111 MSGDSNE004E
      (structured format):
      PIDS/5740XYR00 LVLS/111 MS/DSNE004E
  4. If a CSECT name does appear, build a keyword similar to MSGxxxxxxxxyyyyyyyy. Replace xxxxxxxx with the message number, and replace yyyyyyyy with the CSECT name. Add this to the keyword string. If the message contains any variables, turn to Message modifier keyword. Otherwise, turn to Searching the IBM Support site for known problems and solutions.
      (free format):
      5740XYR00 R111 MSGDSNJ202I DSNJU0001
      (structured format):
      PIDS/5740XYR00 LVLS/111 MS/DSNJ2021
       RIDS/DSNJU0001

Procedure for IRLM messages

  1. Determine if the message contains any variables, such as return or reason codes.
  2. Build a keyword similar to MSGxxxxxxxx, replacing xxxxxxxx with the message number. Add this to the keyword string. If the message contains variables, turn to Message modifier keyword. Otherwise, turn to Searching the IBM Support site for known problems and solutions.
      (free format):
      569516401 AR220 MSGDXR124E
      (structured format):
      PIDS/569516401 LVLS/220 MS/DXR124E