DB2 FOR LUW / DB2FORLUW / A50 - DB2

When 'LOAD QUERY' command encounters SQL6024C, it will keep 
holding locks on catalog tables such as 
"SYSIBM.SYSPARTITIONMAPS" and "SYSIBM.SYSTABLES", until the next 
COMMI/ROLLBACK statement is performed. 
 
Here is an example of the problem reproduced by DB2 CLP: 
=========================================== 
db2 "load query table tmp_1_2_3" 
SQL6024C  Table or index "TMP_1_2_3" is not defined on node "0". 
 
db2pd -db sample -locks showlocks -alldbpartitionnums 
Locks: 
Address            TranHdl    Lockname                   Type 
Mode Sts Owner      Dur HoldCount  Att        ReleaseFlg rrIID 
0x07000000305F0780 2          0000002A000000000000000054 Table 
.IS  G   2          1   0          0x00003010 0x40000000 0 
TbspaceID 0     TableID 42 
0x07000000305F0680 2          00000005000000000000000054 Table 
.IS  G   2          1   0          0x00003000 0x40000000 0 
TbspaceID 0     TableID 5 
=========================================== 
 
This might result in SQL0911N in case other applications need to 
access the catalog tables at the same time.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 10.5 on Linux, Unix and Windows         * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 10.5 Fix Pack 3 or higher levels.  * 
****************************************************************

1. Release locks by issuing a ROLLBACK statement in the 
application that is holding the locks. 
2. Force off the application that is holding the locks.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 LUW Version 10.5 Fix Pack 3.

1. Release locks by issuing a ROLLBACK statement in the 
application that is holding the locks. 
2. Force off the application that is holding the locks.

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

27.08.2013
27.02.2014
27.02.2014