PK36484: ADMIN GENERATES MULTIPLE REBINDS STATEMENTS ON SAME PACKAGE AFTER ALTER ALTERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN tools 7.1 and DB2 8.1  when running  GEN command on a
  table it generates duplicate rebind statements when create table
  or create index and REBIND PACKAGE option is selected. Also
  Object Compare also generates multiple REBIND statements when
  Option Bind is specified and compare is Altering tablespace or
  index for PrimQty or SecQty.
  .
  Additional keywords: priqty
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: The problems have been fixed.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR  eliminates duplicate         *
  *                      REBIND statements from GEN output.      *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Changes were made to ADB2REM
  to eliminate duplicates.
  

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

•    ADB2RE   ADB2REE  ADB2REM  ADB2REP  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK22766

     UP07/03/17 P F703

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.