DB2 FOR LUW / DB2FORLUW / 970 - DB2

CLI packages are not correctly rebound automatically by the 
database upgrade process. 
. 
Due to this issue, catalog contention may occur when executing 
the CLI packages as concurrent implicit rebinds may be running. 
This contention may lead to unexpected lock-waits or deadlocks 
on the DB2 system catalog tables. 
. 
To avoid this contention, this APAR ensures CLI packages will be 
rebound during database upgrade.  However, if the db2rbind 
command is executed after database upgrade, this catalog 
contention will not occur.  Running db2rbind is a documented 
step in the post-upgrade procedure.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All databases upgraded to DB2 Version 9.7 GA or Fix Pack 1   * 
* on Linux, Unix and Windows platforms.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* During database upgrade, CLI packages are not get rebound    * 
* correctly. So these packages are still invalid after         * 
* database upgrade. This will cause potential system catalog   * 
* concurrency issues such as deadlocks or unexpected           * 
* lock-waits while implicitly rebinding packages.              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See local fix.                                               * 
****************************************************************

Run the db2rbind command to rebind all packages after database 
upgrade.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 Version 9.7 Fix Pack 2 and all 
subsequent Fix Packs.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.10.2009
14.05.2010
14.05.2010

9.7.FP2