PH63369: Db2 ADMINISTRATION TOOL QUALITY IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Administration Tool Quality Improvements
  

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 problem     *
  *                      summary.                                *
  ****************************************************************
  This APAR fixes the following issues:
  1. A WSL validation job fails with error message ADB3024E when
  processing CREATE VIEW with a wildcard after ALTER TABLE DROP
  COLUMN.
  
  2. When Object Compare is processing DROP for a function with
  a dependent stored procedure, the job ends with
  an ONCODE=8094 in CM20049.
  
  3. Object Compare incorrectly processes a view dependency on an
  alias and, when then alias is dropped, assumes that the view is
  dropped implicitly and does not generate the needed DROP VIEW
  statement.
  
  4. When running the migrate function a database or a table space
  and the 'CREATE parent DATABASE' or 'CREATE parent TABLESPACE'
  GEN options are enabled on panel ADBP8MG, the subsequent view
  migration will be affected by these options; these options are
  hidden on panel ADBP8MG for a view and cannot be disabled
  without returning to the migrate function on a database or table
  space. This behavior might result in extra CREATE DATABASE or
  CREATE TABLESPACE statements being generated, causing the job
  to fail with SQLCODE=-601.
  
  5. An import change with ALTER TABLE DROP DEFAULT for a nullable
  column is not applied correctly. Consequently, that RUN job
  contains neither DROP and CREATE statements nor ALTER TABLE
  statements, only STOP DB, UNLOAD and START DB statements.
  
  6. When a partition limit key for a float column has a value
  without 'E' on a Db2 subsystem where the decimal point is a
  comma, GEN processes it with ONCODE=350.
  
  7. When Object Compare processes a change on an index that
  places it into advisory REORG-pending status and the following
  change is ADD CONSTRAINT PRIMARY/UNIQUE/FOREIGN KEY or ADD
  CLONE, a missing REORG operation after an index buffer pool
  change causes -20385 for an immediate ALTER TABLE operation.
  
  8. When Object Compare processes the change of a column
  attribute to be NOT NULL WITH DEFAULT and the table has an MQT
  defined on it, the dependent MQT is not dropped, which causes
  ALTER TABLE to fail with SQLCODE=-20180.
  
  Keywords:
  ADB8073E, ONCODE8094, SQLCODE601, ONCODE350, SQLCODE20180
  

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:

  UI98610

Modules/Macros

• ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB2GEN  ADB2REG  ADB2REM  ADB2RGC
  ADB2WVL  ADBCCMM  ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI98610

     UP24/10/03 P F410

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.