PK64854: PANEL ADB21TXC "INDEXES AND COLUMNS OF AAA.AAA" AND HELP PANEL ADBH1TXC "DB2 INDEXES AND COLUMNS" COLUMN "F" NO EXPLAINATION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB21TXC"Indexes and Columns
  of <table name>" shows a column titled "F" with no explaination
  as to why the column shows a value of "S".
  The help panel ADBH1TXC says
  F           Whether the column has a field procedure: Y - Yes  N
  - No
  The "S" is the value from FOREIGNKEY.SYSIBM.SYSCOLUMNS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool who display help     *
  *                 panel ADBH1TXC from panel ADB21TXC.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADBH1TXC displays incorrect description *
  *                      of the "F" column of the ndexes and the *
  *                      Columns panel ADB21TXC.                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The information for the "F" column on help panel ADBH1TXC
  describes the Fieldproc column, instead of the Foreignkey
  column, which is the column that is displayed.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADBH1TXC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK37994

     UP08/07/17 P F807

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.