PM94057: NEW FUNCTION FOR PREMIGRATION CHECKOUT

Obtain the fix for this APAR.

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 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.