PH54714: INTERNAL APAR BUGSMASH 2022

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR Bugsmash 2022
  

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 provides fixes to resolve the *
  *                      issues described in the summary below.  *
  ****************************************************************
  This APAR provides fixes to resolve the following errors:
  
  1. The limit key value is invalid when using ALT to insert a
  partition.
  
  2. The following dialog error occurs when using the COPY command
  on panel ADBP6CCM:
  Function : DISPLAY PANEL(&CPANEL)
  Retcode : 20
  Zerrmsg : ISPP261
  Zerrsm : Panel 'ADBP6CC0' error
  Zerrlm : Invalid alternate command field name given (must be a
  panel field name).
  
  3. The following dialog error occurs when exiting
  panel ADB2C11A:
  Function : DISPLAY PANEL(&CPANEL)
  Retcode : 20
  Zerrmsg : ISPS107
  Zerrsm : Required parm missing
  Zerrlm : Not all required parameters were found for the VPUT
  service.
  
  4. Object Compare might generate a DROP TABLESPACE statement for
  a materialized query table (MQT) table space that fails with
  SQLCODE -204, because it was implicitly dropped by another DROP
  statement.
  
  5. A change management (CM) operation fails with SQLERROR -551
  during the CREATE TABLE process due to an incorrect schema set
  for the target object when the schema is different from the
  SQL ID.
  
  6. Object Compare generates bad trace entries by reading
  uninitialized memory when IBM support asks a user to turn on a
  debug trace.
  
  7. An invalid warning message, ADB7226W, is returned for CREATE
  TRIGGER import if the REFERENCING OLD_TABLE or REFERENCING
  NEW_TABLE clause is used.
  
  8. An invalid error message, ADB3006E, is returned when
  validating a work statement list (WSL) on a table with lowercase
  letters in the table name:
  ADB3006E ADB2WVL An error occurred while processing the Table
  TBSCHEMA.tbNAME object in the statement type of ALTER.
  The column COL2 does not exist in the table.
  
  9. Running the ALT function on a table space generates ALTER
  COMPRESS for all partitions even when only one partition is
  changed.
  
  10. When running the MAKEPBR2 command on a table space, all
  its partition-level COMPRESS values are changed to NO.
  
  11. The GEN function generates COMPRESS YES FIXEDLENGTH when
  APPLCOMPAT is set to function level 503.
  

Problem conclusion

• The problems have 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:

  UI92600 UI92601

Modules/Macros

• ADB2000  ADB21RSB ADB21SAR ADB21TAV ADB25TU3 ADB2C11A ADB2CDC
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP  ADB2PRP  ADB2RE
  ADB2REC  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER
  ADB2RES  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RS   ADB2RSD
  ADB2WVL  ADBCCM   ADBCCMM  ADBGDDL  ADBP6CC0 ADBP6CCM ADBPZRP
  ADBSRL   ADBTEPU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI92600

     UP23/07/10 P F307

• RD10 PSY UI92601

     UP23/07/10 P F307

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.