PH19997: ADB - INSUFFICIENT SCOPE WARNING ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Insufficient Scope Warning Enhancement
  Static Plan Stability Enhancement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration and Object   *
  *                 Comparison Tool for z/OS.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements         *
  *                      as follows:                             *
  *                      - Static plan stability                 *
  *                      - Warn on insufficient scope when       *
  *                        using automatic target selection      *
  *                        (Phase 1)                             *
  *                      - Accept TGTFL in RUNPARMS DD for       *
  *                        ADBCVOB.                              *
  ****************************************************************
  This APAR provides enhancements.
  
  1) When the target of an object comparison is automatically
     selected, you can specify that a warning message be issued
     if the scope is insufficient. This message warns you that
     objects that exist only in the target might be dropped.
  
     - Panel GOC5 'Generate Compare Jobs' is updated with a new
       'Scope Warning Messages' field. You can specify Yes or No.
       No is the default.
     - A new warning message is added:
       ADB7353W: Table space dbname.tsname is not specified in
                 the source for the comparison. Consider including
                 this table space dbname.tsname in the source.
     - A new CM batch parameter is added:
       scope_warning:
         Specifies whether to issue a warning message if the
         target of an object comparison operation is
         automatically selected, and the source is not a table
         space. This message warns that objects that exist only
         in the target might be dropped.
       values:
         Y: Message ADB7353W is issued for this situation. This
            message is issued regardless of the value of the
            Suppress DROP of objects field on the Generate Compare
            Jobs (GOC5) panel.
         N: No message is issued.
       default: N
  
  2) Support is added for several new Db2 12 bind options that
     can help improve query performance by providing static plan
     stability and the ability to view package copy information:
  
     - INVALIDONLY(YES|NO) and PLANMGMTSCOPE(PREVIOUS | ORIGINAL)
       options can be specified for the DSN subcommand FREE
       PACKAGE.
     - APREUSESOURCE(CURRENT|PREVIOUS|ORIGINAL) can be specified
       with the REBIND PACKAGE and REBIND TRIGGER PACKAGE
       commands.
     - CONCENTRATESTMT(NO|YES) can be specified for the BIND
       PACKAGE and REBIND PACKAGE commands.
     - The new KC line command can be specified in ADB2K
       "Packages" panel to view a list of copies for a particular
       package.
       The COPYID column describes the saved access path for the
       package. COPYID=0 represents the current saved access path
       for the package. COPYID=1 represents the previous saved
       access path. COPYID=2 represents the original saved access
       path.
  
  3) Accept TGTFL in RUNPARMS DD for ADBCVOB
     The ADBCVOB load module accepts TGTFL and DB2AFL as the
     user-requested Db2 function level. If both are specified,
     the DB2AFL value is used.
  

Problem conclusion

Temporary fix

Comments

• Enhancements are delivered.
  

APAR Information

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

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

  UI67159

Modules/Macros

• ADB2000  ADB21K   ADB21KB  ADB21KF  ADB21KI1 ADB21KR  ADB21KRN
  ADB21KRT ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB7000  ADBCCM
  ADBCMBIV ADBCVOC  ADBHSQL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67159

     UP19/12/25 P F912

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.