PH31561: FEBRUARY 2021 MAINTENANCE UPDATES

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• FEBRUARY 2021 MAINTENANCE UPDATES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes for the        *
  *                      following issues:                       *
  *                                                              *
  *                      1. An error SQLCODE = -20315 might      *
  *                      occur during a change run when an       *
  *                      advanced trigger is changed,            *
  *                      causing DROP VERSION (instead of        *
  *                      REPLACE VERSION).                       *
  *                      2. Foreground processing of the         *
  *                      advanced trigger ALT might not work.    *
  *                      3. TTYPE column value of                *
  *                      SYSIBM.SYSCOPY catalog table is not     *
  *                      interpreted correctly on panel          *
  *                      ADB21II1.                               *
  *                      4. Compare report incorrectly           *
  *                      displays the changes of default         *
  *                      value of column when its value is       *
  *                      NULL. Generated apply job might not     *
  *                      include correct change statements.      *
  *                      5. An error ONCODE = 8094 might occur   *
  *                      during Compare operation when           *
  *                      compared tables contain XML or LOB      *
  *                      columns.                                *
  *                      6. 'Db2 cmd error' might occur on       *
  *                      panel ADBPZATA 'Add Accelerated         *
  *                      Tables' while adding an accelerated     *
  *                      table.                                  *
  *                      7. CM analyze might fail with RC=12     *
  *                      and error SQLCODE = 100 during          *
  *                      processing of an advanced trigger       *
  *                      package.                                *
  *                      8. When doing a DROP of a history or    *
  *                      archive table from panel ADB21T using   *
  *                      Change management, Compare might        *
  *                      generate duplicate ALTER/DROP           *
  *                      statements in changes file, causing     *
  *                      RUN of the change to fail.              *
  *                      9. Panel ADB26DT 'Drop Table' did       *
  *                      not restrict drop of the history,       *
  *                      archive, auxiliary and clone tables.    *
  *                      10. IBM0441W message (ONCODE = 150 The  *
  *                      STRINGSIZE condition) is raised from    *
  *                      COMPARE_TABLES procedure.               *
  *                      11. DDL of an external procedure is     *
  *                      not formatted correctly during GEN      *
  *                      operation.                              *
  *                      12. An error ADB7115E might occur in    *
  *                      Compare if a table has an implicit      *
  *                      index to enforce a parent key.          *
  *                      13. Compare might generate an           *
  *                      incorrect apply job when tablespace     *
  *                      is converted to UTS. This can cause     *
  *                      an error SQLCODE = -650.                *
  *                      14. Online compare does not work        *
  *                      correctly if source or target is        *
  *                      DDL.                                    *
  *                      15. CM analyze might fail when the      *
  *                      history and temporal tablespaces        *
  *                      are dropped.                            *
  *                      16. CREATE statement for MQT is not     *
  *                      formatted correctly.                    *
  *                      17. An error SQLCODE = -104 might       *
  *                      occur when 'S' line command is          *
  *                      issued on trigger on panel ADB21DS      *
  *                      'Database Structures'.                  *
  *                      18. An error SQLCODE = -104 might       *
  *                      occur during ALT of a trigger when      *
  *                      a RUN SQLID option is used.             *
  *                      19. CM analyze might fail with an       *
  *                      error ADB8022E when a primary key is    *
  *                      added to a table with column mask.      *
  *                      20. Compare might fail with an error    *
  *                      ONCODE = 520 when new auxiliary table   *
  *                      is added.                               *
  *                      21. WSL Validate might falsely issue    *
  *                      an error ADB3014E for view on view      *
  *                      that will cause ANALYZE to fail with    *
  *                      RC=12.                                  *
  *                      22. Multiple GRANT statements for       *
  *                      NSP cause ADB7182E message in the       *
  *                      compare report.                         *
  *                      23. Db2 function level and              *
  *                      application compatibility level         *
  *                      values are displayed inconsistently     *
  *                      on panel ADB2 'Administration Menu'.    *
  ****************************************************************
  This APAR provides fixes to resolve the above errors.
  

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:

  UI73967

Modules/Macros

• ADB2     ADB21DS  ADB21II1 ADB26DT  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2FMT  ADB2PA
  ADB2REH  ADB2REM  ADB2REP  ADB2WVL  ADB32    ADBCCMM  ADBCDTS
  ADBJCLIP ADBMAIN  ADBP7REL ADBPZATA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73967

     UP21/02/18 P F102

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.