PM90471: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT DISPLAY COLUMN LIST EVEN WHEN OPTION 1 IS SELECTED ON ADB2CONF PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not display COLUMN list
  even when Option 1 is selected on ADB2CONF Panel
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function to alter the column list of a       *
  *                 table by deleting a column or adding a       *
  *                 new column, and then alter a view which      *
  *                 references the table.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT function to alter    *
  *                      a table to change its column list by    *
  *                      deleting a column, adding a column,     *
  *                      or altering a view which is defined     *
  *                      on the table, and  choosing Option 1    *
  *                      'Create a column list from the          *
  *                      result table' on panel ADB2CONF         *
  *                      'Alter Related - View Column List',     *
  *                      the view DDL statement is generated     *
  *                      without a column list.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When altering the column list of a table which has a view, by
  choosing 'Create a column list from the result table' on panel
  ADB2CONF, DB2 Admin Tool should detect the column list of the
  view and add it into the view DDL statement automatically.
  

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:

Modules/Macros

• ADB2GEN  ADB2GEN2 ADB2REE  ADB2REG  ADB27CAA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK97962

     UP13/09/28 P F309

• RA20 PSY UK97937

     UP13/09/28 P F309

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.