PI74912: IMPROVE DIAGNOSTICS FOR MQ PROBLEMS INVOLVING DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Improve diagnostics for MQ problems involving DB2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM MQ for z/OS Version 9       *
  *                 Release 0 Modification 0.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Serviceability improvements for DB2     *
  *                      errors in a queue sharing environment.  *
  ****************************************************************
  Currently when MQ encounters errors with DB2 in a queue
  sharing environment, the diagnostic information produced may
  not be adequate to easily determine the appropriate action to
  take.
  

Problem conclusion

• Code has been added to enhance the diagnostic messages
  produced.
  
  The following new messages are added to the IBM MQ V800 and
  V90x Knowledge Center:
      - IBM MQ
      - IBM MQ 8.0.0  and IBM MQ 9.0.X
      - IBM MQ
      - Reference
      - Diagnostic messages
      - Messages and reason codes for z/OS
      - Messages
  
  https://www.ibm.com/support/knowledgecenter/SSFKSJ_9.0.0/com.i
  bm.mq.ref.doc/csq_5.htm
  
  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.
  
  https://www.ibm.com/support/knowledgecenter/SSFKSJ_9.0.0/com.i
  bm.mq.ref.doc/csq_u.htm
  
  CSQU510I
  
     SQL error information
  
  Explanation
  
      An SQL error has occurred. Diagnostic information follows
      in message CSQU511I.
  
  System action
  
      See the preceding Utility error message.
  
  System programmer response
  
      Look at the information in message CSQU511I to determine
      the reason for the SQL error.
  
  CSQU511I
  
     DSNT408I SQLCODE = -sql-code, explanation
  
  Explanation
  
     This message provides additional diagnostic information
     direct    from DB2. It is followed by further CSQU511I
     messages similar to the following example block:
  
     CSQU511I   DSNT408I SQLCODE = -805, ERROR:  DBRM OR PACKAGE
                         NAME DSNV11P1..CSQ5B9-
     CSQU511I            00.1A47B13F08B31B99 NOT FOUND IN PLAN
                         CSQ5B900. REASON 03
     CSQU511I   DSNT418I SQLSTATE   = 51002 SQLSTATE RETURN CODE
     CSQU511I   DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE
                         DETECTING ERROR
     CSQU511I   DSNT416I SQLERRD    = -251  0  0  -1  0  0 SQL
                         DIAGNOSTIC INFORMATION
     CSQU511I   DSNT416I SQLERRD    = X'FFFFFF05'  X'00000000'
                         X'00000000'
     CSQU511I            X'FFFFFFFF'  X'00000000'  X'00000000'
                         SQL DIAGNOSTIC
     CSQU511I            INFORMATION
  
  System action
  
     The utility program is terminated.
  
  System programmer response
  
     Use the diagnostic information to determine the reason
     for the SQL error and correct the problem.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI66130

• APAR is sysrouted TO one or more of the following:

  UI46178 UI46179 UI46180 UI46181 UI46182 UI46183

Modules/Macros

• CSQ52900 CSQ5A900 CSQ5AAUT CSQ5ACHL CSQ5ADOB CSQ5ALOB CSQ5AMSG
  CSQ5ARO2 CSQ5AROB CSQ5ASCS CSQ5ASSK CSQ5ASTR CSQ5ATOP CSQ5AUOB
  CSQ5AUTL CSQ5AWOB CSQ5AZAP CSQ5B900 CSQ5C900 CSQ5CONN CSQ5D900
  CSQ5DELE CSQ5DISC CSQ5K900 CSQ5L900 CSQ5LIST CSQ5LMSG CSQ5M900
  CSQ5P900 CSQ5PQSG CSQ5PVER CSQ5R900 CSQ5READ CSQ5S900 CSQ5SCST
  CSQ5SSKT CSQ5STRS CSQ5STRT CSQ5T900 CSQ5U900 CSQ5UPDT CSQ5W900
  CSQ5WRIT CSQ5Z900 CSQ7CB5  CSQF5DIC CSQF5DIE CSQF5DIF CSQF5DIK
  CSQF5DIU CSQFMTXC CSQFMTXE CSQFMTXF CSQFMTXK CSQFMTXU CSQFSTXC
  CSQFSTXE CSQFSTXF CSQFSTXK CSQFSTXU CSQJUCNV CSQU5ZAP CSQUDB2A
  CSQUTIL  CSQWDST1
  

Fix information

• Fixed component name

  MQ Z/OS V9

• Fixed component ID

  5655MQ900

Applicable component levels

• R000 PSY UI46178

     UP17/05/19 P F705

• R001 PSY UI46179

     UP17/05/19 P F705

• R002 PSY UI46180

     UP17/05/19 P F705

• R003 PSY UI46181

     UP17/05/19 P F705

• R004 PSY UI46182

     UP17/05/19 P F705

• R005 PSY UI46183

     UP17/05/19 P F705

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.