PM81189: MSGDSNT217I ON REBIND PACKAGE SWITCH AND NO ROW IN SYSIBM.SYSPACKCOPY IN V10 NFM FOR PACKAGE THAT USES CGTT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MSGDSNT217I indicated REBIND PACKAGE SWITCH failed in V10 NFM,
  And no row was found in SYSIBM.SYSPACKCOPY for a package that
  used Created Global Temp Tables (CGTT).
  .
  KEYWORD Added: DB2MIGV10/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 users of created global temporary tables     *
  *                 (CGTTs).                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Packages that use CGTTs are incorrectly *
  *                      invalidated during the DB2 10 ENFM      *
  *                      process. This will result in autobind   *
  *                      at next execution or require explicit   *
  *                      rebind. An invalidated package is not   *
  *                      saved as a plan management original or  *
  *                      previous and therefore cannot be used   *
  *                      with REBIND SWITCH.                     *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available and      *
  *                 follow the ++HOLD action.                    *
  ****************************************************************
  Dependencies are recorded in the SYSPKAGE catalog table space
  for all CGTTs (even though CGTTs are not truly dependent on
  anything in the SYSPKAGE table space). The SYSPKAGE catalog
  table space is dropped during DB2 10 for z/OS ENFM processing
  and all dependent packages are invalidated. Because we have
  these unnecessary package dependencies listed in the catalog
  for CGTTs we are invalidating more packages than we need to
  during the DB2 10 for z/OS ENFM process.
  
  Additional keywords: DB2MIGV10/K
  
  ++HOLD COMMENT FOR RELEASE 910, TYPE ACT:
  ***Action for PM81189 (V9)
  
  This PTF modifies V10 premigration checkout job DSNTIJPA.  If
  you maintain a customized copy of this job then after applying
  this PTF, you need to refresh it as follows:
  - Edit your customized copy of DSNTIJPA
  - Delete all lines and copy in the DSNTIJPA member from the
    prefix.SDSNSAMP library
  - Follow the directions in the job prolog to customize it for
    your DB2
  - If you are preparing to migrate to DB2 V10, run the updated
    customized job to check for conditions that may affect your
    migration.
  
  
  ++HOLD COMMENT FOR RELEASE A10, TYPE ACT:
  ***Action for PM81189 (V10)
  
  This PTF modifies V10 premigration checkout job DSNTIJPM.
  If you maintain a customized copy of this job then after
  applying this PTF, you need to refresh it as follows:
  - Edit your customized copy of DSNTIJPM
  - Delete all lines and copy in the DSNTIJPM member from the
    prefix.SDSNSAMP library
  - Follow the directions in the job prolog to customize it
    your DB2
  - If you are preparing to migrate to DB2 V10, run the updated
    customized job to check for conditions that may affect your
    migration.
  

Problem conclusion

• DB2 code has been changed so that CGTT packages will no longer
  show up as having dependencies on the SYSPKAGE catalog table
  space. This will eliminate unnecessary package invalidations
  during the DB2 10 for z/OS ENFM process.
  

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:

  UK93990 UK93991

Modules/Macros

•    DSNTIJPA DSNTIJPM DSNXOTL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK93990

     UP13/05/17 I 1000

• R910 PSY UK93991

     UP13/05/17 I 1000

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.