PK78379: DSP LINE COMMAND OUTPUT / DROP IMPACT REPORT OUTPUT FOR PLANS AN D PACKAGES INVALIDATED BY RENAME TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool DSP line command output and DROP
  IMPACT output can be confusing for plans and packages effected
  by a RENAME table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of DB2  Administration Tool  who use  *
  *                 the DSP command for an object that contains  *
  *                 renamed table(s).                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The  DB2 Administration Tool DSP line   *
  *                      command output and DROP IMPACT output   *
  *                      not  clear  for  plans  and  packages   *
  *                      affected. OK by a RENAME table.         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Display of invalidated plan(s) and packages(s) are not clear.
  

Problem conclusion

• A note on the panel display has been added for invalidated
  plan(s)  and package(s) to clear up the  information being
  displayed.
  

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

•    ADB21DS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK49451

     UP09/08/27 P F908

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.