PH57692: (ADB) PH57692 INTERNAL APAR TO MANAGE APPLCOMPAT ON INDEXES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• (ADB) PH57692 Internal APAR to Manage APPLCOMPAT on Indexes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds an enhancement for       *
  *                      managing application compatibility for  *
  *                      expression-based indexes and support    *
  *                      for the ALTER INDEX REGENERATE USING    *
  *                      APPLICATION COMPATIBILITY statement.    *
  ****************************************************************
  The APPLCOMPAT and environment-related information
  for expression-based indexes is now displayed
  on panels ADB21X, ADB21XI1 and ADB21ENV.
  
  Panel ADB21ENV is now horizontally scrollable and contains
  SYSENV information.
  
  For expression-based indexes, the ENV line command displays
  environment information on the ADB21ENV panel, the AL line
  command allows you to regenerate the index and alter the
  APPLCOMPAT value, and the ALT line command allows you to
  alter the APPLCOMPAT value for the index.
  Object Compare now supports ignores of SYSENVIRONMENT.APPLCOMPAT
  on the ignore panels. For expression-based indexes, Object
  Compare checks for an APPLCOMPAT ignore before generating
  changes ALTER INDEX REGENERATE USING APPLICATION COMPATABILITY
  For views Object Compare checks for an APPLCOMPAT ignore before
  generating changes ALTER VIEW REGENERATE USING APPLICATION
  COMPATABILITY.
  
  For expression-based indexes, Object Compare now supports
  generating ALTER INDEX index_name REGENERATE USING APPLICATION
  COMPATIBILITY source_applcompat, when the source and target
  index are same, but the target APPLCOMPAT value is different
  than source APPLCOMPAT value.
  

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:

  UI94481

Modules/Macros

• ADB1000  ADB21    ADB21A   ADB21C   ADB21D   ADB21DC  ADB21DI2
  ADB21DS  ADB21ENV ADB21G   ADB21H   ADB21K   ADB21KD  ADB21P
  ADB21S   ADB21T   ADB21TC  ADB21TN  ADB21TNC ADB21TPS ADB21TXC
  ADB21VV0 ADB21X   ADB21XA  ADB21XA0 ADB21XAR ADB21XAS ADB21XC
  ADB21XI1 ADB21XPS ADB21Z   ADB21ZDS ADB21ZPS ADB25    ADB2CM2
  ADB2CM3  ADB2CME  ADB2CMP  ADB2CMR  ADB2CMT  ADB2IGN  ADB2PA
  ADB2REG  ADBCCMM  ADBCDTS  ADBH1ENV ADBH1XAR ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI94481

     UP23/11/18 P F311  

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.