|
Problem IC61592
|
Status: Closed |
Load utility in DPF environment may not terminate gracefully when error occurs, may hang or behave incorrectly. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In rare situations, the Load utility in a DPF environment may
hang or exhibit unknown behaviour when the utility encounters an
error.
More specifically, the Load coordinating agent process
'db2agent' will successfully interrupt subagents on all
partitions, but the coordinating agent may hang indefinitely or
exhibit unknown behaviour.
Symptoms of such a situation include db2diag.log entries showing
Load subagents and EDUs on all nodes being interrupted and
failing ungracefully, however after this the Load may not return
back to the client. A db2pd -stack may show the Load
coordinating agent process 'db2agent' have a callstack that
contains 'iWorkDuringFinalSyncUp'. Forcing the application may
not effectively interrupt this agent and an instance recycle may
be required. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* In rare situations, the Load utility in a DPF environment *
* may *
* hang or exhibit unknown behaviour when the utility *
* encounters an *
* error. *
* *
* More specifically, the Load coordinating agent process *
* *
* 'db2agent' will successfully interrupt subagents on all *
* *
* partitions, but the coordinating agent may hang indefinitely *
* or *
* exhibit unknown behaviour. *
* *
* Symptoms of such a situation include db2diag.log entries *
* showing *
* Load subagents and EDUs on all nodes being interrupted and *
* *
* failing ungracefully, however after this the Load may not *
* return *
* back to the client. A db2pd -stack may show the Load *
* *
* coordinating agent process 'db2agent' have a callstack that *
* *
* contains 'iWorkDuringFinalSyncUp'. Forcing the application *
* may *
* not effectively interrupt this agent and an instance recycle *
* may *
* be required. *
****************************************************************
* RECOMMENDATION: *
* upgrade to latest fixpak *
**************************************************************** |
| Local Fix: |
n/a |
| 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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.06.2009
16.02.2010
16.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
