PH47060: ADMIN TOOL: GEN SHOWS INCORR DDL WHEN PARM "INCLUDING DB2 PENDING CHANGES" IS Y AND THE PENDING CHG IS A DROP COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool:  GEN shows full table with all columns
  and ALTER TABLE  DROP COLUMN statements for pending changes
  when parameter "Including Db2 pending changes" is set to Y
  
  
  
  Currently, when the GEN parameter 'including Db2 pending
  changes' is set to Y, GEN shows the full table with all columns
  and ALTER TABLE DROP COLUMN statements for DROP COLUMN pending
  changes at the end.
  
  
  With this APAR, when the GEN parameter 'including Db2 pending
  changes' is set to Y, GEN will show the fully realized table
  without the columns in DROP COLUMN pending changes.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running the GEN function for a     *
  *                      table with pending DROP COLUMN changes  *
  *                      and the GEN parameter "Include Db2      *
  *                      pending chgs" set to Y, separate        *
  *                      statements are generated to first       *
  *                      create the full table and then apply    *
  *                      the DROP COLUMN changes. However, the   *
  *                      Y setting is to generate the final      *
  *                      table without deleted columns and       *
  *                      ALTER statements.                       *
  ****************************************************************
  Currently, when the GEN parameter 'Include DB2 pending chgs' is
  set to Y, the resulting SQL includes statements to create the
  full table with all columns and then ALTER TABLE DROP COLUMN
  statements for any DROP COLUMN pending changes. With this APAR,
  when 'Include DB2 pending chgs' is set to Y, the resulting DDL
  creates the final table without the columns
  in the DROP COLUMN pending changes. Separate ALTER statements
  to drop the columns are not needed.
  

Problem conclusion

• This enhancement is delivered.
  

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:

  UI82008 UI82018

Modules/Macros

• ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82008

     UP22/08/20 P F208

• RD10 PSY UI82018

     UP22/08/20 P F208

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.