DB2 FOR LUW / DB2FORLUW / A10 - DB2

Upon implicit or explicit rebind, DB2 acquires the rebind 
sequence lock. However, this lock may not get released after the 
statement is completed under certain circumstances and may lead 
to deadlock and concurrency issues with other statements 
attempting to rebind the same package. This lock would require 
the transaction to commit or rollback to get released. 
 
To confirm you're hitting this APAR, check the lock dumps for 
contention on the rebind sequence lock. 
 
For example, an application snapshot that shows the symptom: 
 
Application handle                         = 15486 
Application status                         = Lock-wait 
Package name                               = P1593222409 
Package name                               = SYSSH200 
<corresponding statement from the applications that will on lock 
wait > 
 
  ID of agent holding lock                 = 1124 
  Lock name                                = 
0x97B2EF1B0000000001000062D3 
  Lock object type                         = Internal Sequence 
Lock 
  Lock mode                                = Exclusive Lock (X) 
  Lock mode requested                      = Exclusive Lock (X) 
 
This behavior can be seen starting from DB2 V10.1 FP2.

**************************************************************** 
* USERS AFFECTED:                                              * 
* A10                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Commit or rollback after each statement that may cause a     * 
* package                                                      * 
* to get rebound.                                              * 
****************************************************************

Commit or rollback after each statement that may cause a package 
to get rebound.

keiner bekannt / siehe Local-Fix

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

03.03.2015
15.07.2015
15.07.2015