PM22165: SQLCODE471/RC00E79008 DOESN'T RETURN ROUTINE NAME IN THE ERROR MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNT034I DSNTRVFY - AN ERROR WAS ENCOUNTERED DURING CALL TO
  ROUTINE, SQLCODE = -471
  DSNT408I SQLCODE = -471, ERROR:  INVOCATION OF FUNCTION OR
  PROCEDURE 00E79008 FAILED DUE TO REASON <this token is blank>
  DSNT418I SQLSTATE   = 55023 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNX9CAC SQL PROCEDURE DETECTING ERROR
  DSNT415I SQLERRP    = DSNX9CAC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'
  X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 users of stored procedures and           *
  *                 user defined functions (UDFs).               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The reason code token for sqlcode       *
  *                      -471/RC00E79008 is in the wrong         *
  *                      place. The error message looks like     *
  *                      this:                                   *
  *                      SQLCODE = -471,                         *
  *                      ERROR: INVOCATION OF FUNCTION OR        *
  *                             PROCEDURE 00E79008 FAILED        *
  *                             DUE TO REASON <token is blank>   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The code that issues -471/00E79008 incorrectly put the reason
  code in the wrong place.
  

Problem conclusion

• DB2 code has been fixed to write the correct tokens out
  for SQLCODE -471/RC00E79008.
  

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:

  UK63996 UK63997 UK63998

Modules/Macros

• DSNX9WLS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK63996

     UP11/02/02 P F102

• R810 PSY UK63997

     UP11/02/02 P F102

• R910 PSY UK63998

     UP11/02/02 P F102

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.