|
Problem IC76716
|
Status: Closed |
LOAD SESSION HOLD Z LOCK AND TRANSACTION LOG RECORD, CAN NOT BE FORCED OFF. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
With a DPF load, the load init subagents (db2linit) may
encounter delay in starting up in rare situations (e.g. due to
network performance issues), and if the load is being
interrupted (e.g. due to remote client termination detected)
within a certain small timing window, in extreme cases the load
may finish rollback and terminates, before a db2linit finally
starts up at a remote node. The now-"orphaned" db2linit may
hold a Z-lock on the load target table (and possibly other
resources) and fail to release it properly, and it cannot be
forced off -- the only way to recover is to restart the DB2
instance. |
| Problem Summary: |
Users Effected:
All users using load in DPF env.
Problem Description:
LOAD SESSION HOLD Z LOCK AND TRANSACTION LOG RECORD, CAN NOT BE
FORCED OFF.
Problem Summary:
With a DPF load, the load init subagents (db2linit) may
encounter delay in starting up in rare situations (e.g. due to
network performance issues), and if the load is being
interrupted (e.g. due to remote client termination detected)
within a certain small timing window, in extreme cases the load
may finish rollback and terminates, before a db2linit finally
starts up at a remote node. The now-"orphaned" db2linit may
hold a Z-lock on the load target table (and possibly other
resources) and fail to release it properly, and it cannot be
forced off -- the only way to recover is to restart the DB2
instance. |
| Local Fix: |
|
| available fix packs: |
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 8 for Linux, UNIX, and Windows
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
|
| Solution |
defect wsdbu00839992
CSD First fixed in DB2 UDB Version 9.7, FixPak 5
module engn_squs |
| Workaround |
Upgrade to DB2 Version Version 9.7, FixPak 5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.05.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
