PM76402: SQLCODE805 ON NATIVE STORED PROCEDURE IN V9/V10 COEXIST 13/01/03 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In a data sharing environment consisting of V10 CM9 and
  V9 members, native SQL stored procedures created on a V10 CM9
  mbr result in a SQLCODE -805 when executed on a V9 member. The
  CONTOKEN in SYSIBM.SYSPACKAGE is also set to nulls following
  the error. However an native SQL stored procedure that is
  created on a V9 member executes successfully on a V10 member.
  .
  KEYWORD Added:  DB2MIGV9/K DB2COEXIST/K
  

Local fix

• The customer must create all native SQL stored procedures on
  the V9 member.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 for z/OS users who run applications    *
  *                 that call native stored procedures created   *
  *                 on a later release of DB2 for z/OS.          *
  *                 Fallback toleration code in APAR PK56922     *
  *                 (PTF UK61200) is missing some support for    *
  *                 native stored procedures.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -805 is returned when running   *
  *                      an application program that satisfies   *
  *                      all of the following conditions:        *
  *                                                              *
  *                      1. The application program runs on V9   *
  *                         NFM.                                 *
  *                      2. The application program calls a      *
  *                         native stored procedure created on a *
  *                         later release of DB2 for z/OS.       *
  *                                                              *
  *                      This could happen on a data sharing     *
  *                      system with V9 and V10 coexistence.  It *
  *                      could also happen when the procedure    *
  *                      is created on DB2 V10 CM9 but is called *
  *                      after DB2 falls back to V9 NFM.         *
  *                      This error also results in the CONTOKEN *
  *                      column for the stored procedure in      *
  *                      SYSIBM.SYSPACKAGE being set to null.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE -805 is returned when running an application program
  that satisfies all of the following conditions:
  
  1. The application program runs on V9 NFM.
  2. The application program calls a native stored procedure
     created on a later release of DB2 for z/OS.
  
  This could happen on a data sharing system with V9 and V10
  coexistence. It could also happen when the procedure is created
  on DB2 V10 CM9 but is called after DB2 falls back to V9 NFM.
  This error also results in the CONTOKEN column for the stored
  procedure in SYSIBM.SYSPACKAGE being set to null. The following
  query can be used to find the native stored procedures created
  on a later release in a V9 catalog.
  
  SELECT COLLID, NAME
  FROM SYSIBM.SYSPACKAGE
  WHERE TYPE = 'N' AND
  RELBOUND > 'N';
  
  When executing a native stored procedure which is created in a
  later DB2 release, DB2 implicitly regenerates the procedure
  and the consistency token is incorrectly set to null.
  

Problem conclusion

• Code has been modified to preserve the consistency token
  of the existing stored procedure. The problem reported in this
  APAR is fixed.
  
  Additional keywords: DB2COEXIST/K DB2DSHR SYSPLEXDS SQLCODE805
                       SQLPROCEDURE DATASHARING SQLNATIVESQLPL
                       SQLSPSQLSTOREDPROC DB2MIGV10/K
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK90906

Modules/Macros

• DSNTBSPL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK90906

     UP13/01/26 P F301 ®

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.