IBM Support

PM94057: NEW FUNCTION FOR PREMIGRATION CHECKOUT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • New function for DB2 11 premigration checkout
    .
    KEYWORD:  DB2MIGV11/K
    .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS System Administrators are    *
    *                 affected by this change.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: Provide a DB2 11 for z/OS premigration  *
    *                      checkout job in DB2 10 for z/OS.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Beginning with DB2 V6, each release of DB2 provides a job called
    DSNTIJPM that can be run on the prior release to help identify
    conditions that can impede migration to the new release.
    
    To allow customers maximum time to prepare for migration to a
    new release, the DSNTIJPM job is shipped under a different name
    in the previous release.  For example:
    - the V8 DSNTIJPM is shipped as DSNTIJP8 in V7
    - the V9 DSNTIJPM is shipped as DSNTIJP9 in V8
    - the V10 DSNTIJPM is shipped as DSNTIJPA in V8 and V9
    This arrangement permits customers to begin preparing for
    migration in advance of buying and SMP/E-installing the new
    version.
    
    This APAR adds the V11 DSNTIJPM job to DB2 10 for z/OS under the
    name DSNTIJPB.  DSNTIJPB generates the following reports:
     (1) Reports existence of the previous-release sample database
     (2) Reports user-defined indexes on the DB2 catalog that reside
         on user-managed storage
     (3) Reports user-defined indexes on the DB2 catalog that reside
         on DB2-managed storage
     (4) Reports plans that are autobind candidates in V11
     (5) Reports packages that are autobind candidates in V11
     (6) Reports explain tables that are not in current-release fmt
     (7) This report is obsolete
     (8) Report MQTs on the DB2 catalog that are affected by CATENFM
     (9) Report existence of obsolete (AMT-based) MQSeries functions
    (10) Report existence of obsolete DB2 XML MQSeries routines
    (11) Report simple table spaces
    (12) Report trigger packages that have an invalid SECTNOI
    (13) Report views that have period specifications
    (14) Report MQTs that have period specifications
    (15) Report SQL functions that have period specifications
    (16) Report problem with catalog table space version numbers
    (17) Report package dependencies on TSs processed by ENFM
    (18) Report orphaned rows in SYSCOPY and SYSOBDS
    (19) Report orphaned rows in SYSTABSTATS
    (20) Report orphaned rows in SYSCOLAUTH
    (21) Report inconsistent version numbers in the DB2 catalog
    (22) Report plan dependencies on TSs processed by ENFM
    (23) Report package dependencies on TSs processed by DSNTIJTC
    (24) Report plan dependencies on TSs processed by DSNTIJTC
    
    Run DSNTIJPB as soon as possible on your DB2 10 for z/OS system
    in order to evaluate it for readiness for migration to DB2 11
    for z/OS.
    
    DSNTIJPB uses DB2 REXX Language Support, which is bound by
    running installation job DSNTIJTM, job step DSNTIRX.  If you did
    not bind the packages and plan for DB2 REXX when you migrated to
    DB2 10 for z/OS, use job DSNTIJTM, job step DSNTIRX, to do so
    before running DSNTIJPB.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM94057

  • 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-07-29

  • Closed date

    2013-10-03

  • Last modified date

    2013-11-04

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

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

    UK98219

Modules/Macros

  • DSNTIJPB DSNTINS1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK98219

       UP13/10/20 P F310

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.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PM94057

Modified date: 04 November 2013


Translate this page: