DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 9.7 Fix Pack 9 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 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 LUW Version 9.7 Fix Pack 9.

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.

forerunner  : APAR is sysrouted TO one or more of the following: IC90269 IC91791 IC95428 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.02.2013
08.10.2013
08.10.2013

9.7.FP9