Fixes are available
APAR status
Closed as program error.
Error 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.
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)
Problem summary
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 conclusion
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) APAR has been fixed in DB2 V9.1 FP 8
Temporary 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)
Comments
APAR Information
APAR number
LI73480
Reported component name
DB2 EDE LINUX
Reported component ID
5724N7604
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-06-05
Closed date
2009-10-08
Last modified date
2009-10-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 EDE LINUX
Fixed component ID
5724N7604
Applicable component levels
R910 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021