PK28933: INCONSISTANT COMMAND LIST FOR PANEL ADB21T ( MIG COMMAND SHOWN I N ERROR FOR VIEWS AND MISSING FOR TABLES )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB21T 'Tables, views, and
  Aliases' displays an invalid commands list when option V is
  selected on panel ADB21 'System Catalog' then a 'T' line command
  is used to find the related tables. The newly displayed ADB21T
  does not list MIG as a command ( an omission ), F3 back to the
  list of views and the MIG command is now listed ( an error ).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who have   *
  *                 the following operation, may be affected:    *
  *                  "invoke Tables, Views, and Aliases (ADB21T) *
  *                   recursively, and use the MIG command from  *
  *                   ADB21T"                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADB21T Tables, Views, and Aliases *
  *                      displayed an invalid commands list when *
  *                      option V was selected on panel ADB21    *
  *                      'System Catalog' and a 'T' line command *
  *                      was used to find the related tables.    *
  *                      .*                                      *
  *                      The newly displayed ADB21T did not list *
  *                      MIG as a command (an omission), F3 back *
  *                      to the list of views and the MIG        *
  *                      command was listed (an error).          *
  *                      .*                                      *
  *                      MIG primary command inconsistent action *
  *                      and display on Tables, Views, and       *
  *                      Aliases (ADB21T) were reported.         *
  *                      .*                                      *
  *                      Invoking and exiting Tables, Views, and *
  *                      Aliases (ADB21T) recursively  may cause *
  *                      MIG  primary command to appear for view *
  *                      only  display (type=V),  when it should *
  *                      be invalid.  Also  it  may  cause it to *
  *                      disappear  for  a  display   containing *
  *                      tables (type=T).  This  may  occur, for *
  *                      example,  when   issuing  the  T   line *
  *                      command against a view on ADB21T.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADBCTF   ADB21T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK18619

     UP06/10/12 P F610

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.