|
Problem IC96718
|
Status: Geschlossen |
A LOAD COMMAND WITH LOW WARNINGCOUNT MIGHT HANG |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The Load hang might occur under the following conditions:
1) Low WARNINGCOUNT is specified (e.g. 1).
2) High CPU_PARALLELISM and/or DISK_PARALLELISM are specified
explicitly or implicitly.
3) Data file contains lots of consecutive invalid rows that can
cause Load Formatters to hit the WARNINGCOUNT very quickly.
When the Load is hanging, you can see the following stack for
db2agent (i.e. Load agent), but other Load EDUs have exited
already:
msgsnd
uninterruptableMsgSnd
sqlowqueInternal
sqlowqueWrapper
sqlowque
sqluWriteQueue
sqlulSndTermMsg
sqlulTerminate
sqlulPrcErr
sqlulFRMResponse
sqlulPollMsg
sqluvload
call_sqluvload
sqluLoadPartition
sqlu_register_table_load
sqluvtld_route_in
sqlesrvr
sqleMappingFnServer
sqlerKnownProcedure
Please note that you might not be able to interrupt the hanging
Load. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version V9.7 Fix Pack 9 *
**************************************************************** |
| Local-Fix: |
Workaround:
1)Use Load without the warningcount
2)Reduce CPU_PARALLELISM and/or DISK_PARALLELISM
3)Correct the input data to avoid too many warnings generated. |
| verfügbare FixPacks: |
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
|
| Lösung |
First Fixed in DB2 Version V9.7 Fix Pack 9 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC96847 IC96848 IC97046 IC97065
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.10.2013
04.02.2014
04.02.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
