home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT09268 Status: Closed

CATALOG LOCKS ACQUIRED DURING COMPILATION MAY NOT GET RELEASED UPON
COMPILATION COMPLETES DUE TO NESTED COMPILATION

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Locks acquired for the system catalog during compilation may not 
get released after compilation completes due to nested 
compilation. For example, driving re-validation upon an invalid 
object may trigger this symptom. In most cases, this would not 
cause any concern as the locks would get released at the end of 
the transaction. However, some side effects include longer lock 
waits and anonymous block deadlock. 
 
EDUID   : 3343                 EDUNAME: db2dlock (DBNAME) 
FUNCTION: DB2 UDB, base sys utilities, 
sqleCheckForceSuspendedConn, probe:280 
DATA #1 : String, 170 bytes 
Anonymous Block deadlock detected! 
Waiting application with appHandle 0-XXX will be rolled back. 
Suspended application with appHandle 0-XXX has deadlock state 
0x00000010.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V10.5 Fix Pack 7                                  * 
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.06.2015
28.01.2016
28.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList