|
Problem IC61581
|
Status: Geschlossen |
LOAD WITH "LOCK FORCE" OPTION, RUN ON A TABLE WITH CONSTRAINTS, DOES NOT FORCE OFF LOCKS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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) |
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in DB2 V9.7 FP 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.06.2009
22.12.2009
22.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
