PI09158: GEN/DDL ADB2GEN SQLCODEN423 WHEN PROCESSING A NATIVE STORED PROC EDURE / NSP. 14/01/08 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function issues a
  message:
  ADB1649E ADB2REY:  Unexpected sqlcode in : Free LOB_locator
  DSNT408I SQLCODE = -423, ERROR:  INVALID VALUE FOR LOCATOR IN
  POSITION
  DSNT418I SQLSTATE   = 0F001 SQLSTATE RETURN
  DSNT415I SQLERRP    = DSNXELOB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -240  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF10'  X'00000000'  X'00000000'
   X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  when processing a native stored procedure / NSP.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Generate (GEN) on a Native      *
  *                 Stored Procedure (NSP) or function on DB2    *
  *                 9 New Function Mode (NFM).                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN function issues a SQLCODE=-423 /    *
  *                      SQLCODEN423 message:                    *
  *                                                              *
  *                      ADB1649E ADB2REY:  Unexpected           *
  *                      sqlcode in : Free LOB_locator           *
  *                      DSNT408I SQLCODE = -423, ERROR:         *
  *                      INVALID VALUE FOR LOCATOR IN            *
  *                      POSITION                                *
  *                      DSNT418I SQLSTATE   = 0F001             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      when processing a Native Stored         *
  *                      Procedure (NSP).                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When performing a GEN on a native stored procedure an
  SQLOCDE=-423 / SQLCODEN423 error is observed.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI15245 UI15246 UI15247

Modules/Macros

• ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI15245

     UP14/02/20 P F402 {

• RA20 PSY UI15246

     UP14/02/20 P F402 {

• RB10 PSY UI15247

     UP14/02/20 P F402 {

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.