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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM81189

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-22

  • Closed date

    2013-05-01

  • Last modified date

    2013-06-04

  • 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 P F305

  • R910 PSY UK93991

       UP13/05/17 P F305

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM81189

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation