DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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.

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
 

defect  wsdbu00839992 
CSD     First fixed in DB2 UDB Version 9.7, FixPak 5 
module  engn_squs

Upgrade to DB2 Version Version 9.7, FixPak 5.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

31.05.2011
07.12.2011
07.12.2011

9.7.