PM89199: DB2 ADMINISTRATION TOOL FOR Z/OS ALTERS LIMIT KEY ON TS LEVEL INSTEAD OF ON TB LEVEL FOR TABLE-CONTROLLED PARTITIONED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS ALTERs limit key on TS level
  instead of on TB level for table-controlled partitioned table
  resulted in the following error in the MERGE Report:
  ADBCCME - Error(s) found. Please review output
  Unable to locate <LK> record to update when altering table
  <schema.tbname>
  ADBC002E - Severe error. Merge terminates
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'VALUES - View current      *
  *                 LIMITKEY values for each partition'          *
  *                 primary command on panel ADB21SAR'           *
  *                 Redefine Table Space' and change the         *
  *                 limit key value on panel ADB21TAV 'Alter     *
  *                 Partitioned Table'.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS        *
  *                      alters a limit key at the table space   *
  *                      level instead of the table level for    *
  *                      table-controlled partitioned tables     *
  *                      and resulted in the following error     *
  *                      in the MERGE Report:                    *
  *                                                              *
  *                      ADBCCME - Error(s) found.               *
  *                      Please review output                    *
  *                      Unable to locate >limit_key<            *
  *                      record to update when altering          *
  *                      table >schema.tbname<                   *
  *                      ADBC002E - Severe error.                *
  *                      Merge terminates                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An alter of a limit key at the table space level instead of the
  table level for table-controlled partitioned tables failed on
  the MERGE step.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK96764 UK96765

Modules/Macros

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK96764

     UP13/08/20 P F308

• RA20 PSY UK96765

     UP13/08/20 P F308

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.