|
Problem IC61581
|
Status: Closed |
LOAD WITH "LOCK FORCE" OPTION, RUN ON A TABLE WITH CONSTRAINTS, DOES NOT FORCE OFF LOCKS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Load with "lock force" option, run on a table with constraints,
does not force off locks and errors out with SQL0911 RC 68 (if
locktimeout is set to a specific value). If locktimeout is set
to -1, then the load waits for the locks indefenitely.
Test case:
(i) Create a table with a constraint definded on it.
(ii) Run a db2 +c select with RR on the same table from one
window
(iii) Run a load with lock force option into this table from a
second window. This is supposed to force off any
existing locks on the table, but instead just times out after
whatever value the locktimeout is set to. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* None *
****************************************************************
* PROBLEM DESCRIPTION: *
* Load with "lock force" option, run on a table with *
* constraints, *
* does not force off locks and errors out with SQL0911 RC 68 *
* (if *
* locktimeout is set to a specific value). If locktimeout is *
* set *
* to -1, then the load waits for the locks indefenitely. *
* *
* *
* *
* Test case: *
* *
* *
* *
* (i) Create a table with a constraint definded on it. *
* *
* (ii) Run a db2 +c select with RR on the same table from one *
* *
* window *
* *
* (iii) Run a load with lock force option into this table from *
* a *
* second window. This is supposed to force off any *
* *
* existing locks on the table, but instead just times out *
* after *
* whatever value the locktimeout is set to. *
****************************************************************
* RECOMMENDATION: *
* None *
**************************************************************** |
| Local Fix: |
The load works fine when...
(i) Constraint checking is turned OFF
(ii) The db2 +c select is done with CS instead of RR
(iii) The load command is issued with the "with read access" and
"with lock force" options. (Note :- with read access is not
compatible with a load replace) |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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
|
| Solution |
First fixed in DB2 V9.7 FP 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.06.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
