PK60697: NOT ALL LINE COMMANDS ON ADB21TN WORK ON ALL CONSTRAINT TYPES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1) Not all line commands on ADB21TN work on all constraint
  types.
  2) ICS line command returns too many rows when same object name
  appears in different databases
  3) When MIG is invoked first, then panel ADB2GEN command, the
  expected Invalid Panel Invocation message (ADB358E) is not
  invoked
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool V7.2  who use        *
  *                 the ICS command, the CON command, or         *
  *                 who issue an invalid Panel ADB2GEN           *
  *                 command after issuing the MIG command.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 3 different problems are fixed by this  *
  *                      internal apar:                          *
  *                      1. Not all line commands on ADB21TN     *
  *                       work on all constraint types.          *
  *                      2. ICS line command returns too many    *
  *                       rows in some circumstances.            *
  *                      3. When the MIG command is invoked      *
  *                       first, then panel ADB2GEN command,     *
  *                       the expected Invalid Panel Invocation  *
  *                       message is not issued.                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. The behavior of the CON line command recently changed to
   display constraints other than just table constraints. This
   resulted in some of the line commands available to table
   constraints not to work for other types. An example is that
   DROP works on unique and primary constraints, but not check or
   foreign key constraints.
  2. The ICS line command from ADB21D, ADB21X, and ADB21XP
   returns the same row multiple times if the same index name
   (with a different qualifier) is in different databases.
  3. When panel ADB2GEN is invoked out of context, i.e., via the
   Panel command, message ADB358E is normally issued. However,
   when the MIG command is issued prior to the panel command,
   the message is not issued.
  

Problem conclusion

• The problems have been fixed in Admin Version 7.2.
  

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

•    ADB2DF   ADB2GEN  ADB2GENX ADB21A   ADB21D
  ADB21FKI ADB21G   ADB21S   ADB21T   ADB21TN  ADB21X   ADB21XP
  ADB21Y
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK36514

     UP08/05/30 P F805

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.