|
Problem IC63646
|
Status: Closed |
LOAD WITH CLIENT OPTION (OR CLI LOAD) THAT IS INTERRUPTED MAY TRAP WITH SQLODIAGNOSEFREEBLOCKFAILURE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When the Load utility is invoked from a remotely connected
client and the CLIENT option is specified (meaning data is being
retrieved from the client), or the CLI Load interface is used,
if the utility is interrupted or fails, it's possible in some
timing situations that the Load Agent process drives a rollback
and free's resources before all of it's child processes have
exited, causing the Load to trap with errors such as this:
2009-04-07-15.32.51.513504-240 I4089969E2013 LEVEL: Severe
PID : 12699 TID : 208729532768 PROC :
db2sysc 0
INSTANCE: xxx NODE : 000 DB :xxx
APPHDL : 0-38628 APPID:P00000.D289.004E97180854
AUTHID : Kxxxx
EDUID : 3479 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:60
MESSAGE : The associated pool has already been freed. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of db2v97 or greater *
****************************************************************
* PROBLEM DESCRIPTION: *
* LOAD from client from remote client is interrupted, and *
* causes crash with diaglog message: *
* sqloDiagnoseFreeBlockFailure, probe:60 *
* *
* MESSAGE : The associated pool has already been freed. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 2 or later. *
**************************************************************** |
| Local Fix: |
|
| 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 |
DB2 Version 9.7 Fix Pack 2 contains fix |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.10.2009
01.03.2010
01.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
