PL25595: SERVAPAR MSGDSNX200I ISSUED FROM DSNXEPR SHOULD OUTPUT SQLERRP AND SQLERRD1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SERVAPAR
  MSGDSNX200I SHOULD IDENTIFY NAME OF CSECT THAT PUT OUT THE SQL
  RETURN CODE (SQLERRP) AND THE UNIQUE IDENTIFIER WITHIN THAT
  CSECT (SQLERRD1). MSGDSNX200I TEXT (DSNXTIAD) SHOULD IDENTIFY
  RETURN CODE (SQLCODE) AS "RETURN CODE" AND NOT "REASON CODE".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: FOR MOST ERRORS THE OUTPUT              *
  *                      MESSAGE MSGDSNX200I WAS UNCLEAR         *
  *                      AND OF LITTLE HELP IN DETERMINING       *
  *                      WHAT THE ERROR WAS AND WHERE            *
  *                      IT WAS DETECTED.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  MSGDSNX200I DOES NOT IDENTIFY THE CSECT THAT ISSUES THE SQL
  RETURN CODE AND IN MANY CASES THE 'CODE' AND 'TOKEN LIST' ARE
  UNCLEAR AS TO WHAT THE ACTUAL ERROR OR PROBLEM IS.
  

Problem conclusion

• CODE AS BEEN ADDED TO MODULES DSNXEPR, DSNFXDIR, AND DSNFMDIR
  AND MACRO DSNFXDTA. THESE ADDITIONS WILL ADD SQLERRP AND
  SQLERRD1 AS ADDITIONAL INFORMATION FOR THE DSNX200I MESSAGE.
  
  CHANGE TO DB2 MESSAGES AND CODE MANUAL SC26411303 ARE AS
  FOLLOWES:
  
   DSNX200I 'BIND-TYPE' SQL ERROR
            USING 'AUTHORIZATION-ID' AUTHORITY
            PLAN='PLAN-ID' DBRM='DBRM NAME'
            STATEMENT='STATMENT NUMBER'
            SQL CODE = 'SQL CODE'
            TOKENS='TOKEN LIST'
            CSECT='CSECT NAME'
            RDS CODE='RDS UNIQUE CODE'
   REPLACE THE SUBPARAMETER 'CODE' WITH
   'SQL CODE'
   ADD
    CSECT NAME  NAME OF THE CSECT WHICH
                DETECTED THE ERROR.
    RDS CODE    UNIQUE CODE OF THE RDS
                COMPONENT.
  
    DSNX105I
     CHANGE REASON CODE = CODE TO READ
     SQL CODE = SQL CODE.
  
     CHANGE SUBPARAMETER 'CODE' TO READ
     'SQL CODE'.
  

Temporary fix

Comments

APAR Information

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

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

  UL30184

Modules/Macros

•    DSNFMDIR DSNFXDIR DSNFXDTA DSNXEPR
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R302 PSY UL30184

     UP88/05/24 P F805

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.