|
Problem IC77930
|
Status: Geschlossen |
LOAD OPERATIONS WITH COPY YES OPTION MAY FAIL WITH SQLO_SEM_TIMEOUT. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
LOAD operations with COPY YES option may timeout and fail, when
there is no data to write to the LOAD COPY image for a
120-second period. This could happen if (for example):
-- all the rows processed within 120 seconds are being rejected,
or
-- load's build phase (which does not write to LOAD COPY image)
lasts longer than 120 seconds
db2diag.log will have below entry for the LOAD
-----
2010-07-11-11.11.111.123456+123 E60128A423 LEVEL: Severe
PID : 181060 TID : 20391 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 20391 EDUNAME: db2lmw0 0
FUNCTION: DB2 UDB, database utilities, sqluMCContinueBackup,
probe:830
MESSAGE : ZRC=0x870F00B9=-2029059911=SQLO_SEM_TIMEOUT
"Return code from sqlowait when time out value has
been reached"
----- |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* LOAD operations with COPY YES option may timeout and fail, *
* when there *
* is no data to write to the LOAD COPY image for a 120-second *
* period. *
* This could happen if (for example) all the rows processed *
* within 120 *
* seconds are being rejected. Db2diag.log may have below *
* entry for *
* the LOAD. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 verision 9.5 FP9 *
**************************************************************** |
| Local-Fix: |
a) Use COPY NO or NONRECOVERABLE, instead of COPY YES load
option
b) Reduce the invalid data of load, if failure occurs during
load phase
c) Use INDEXING MODE DEFERRED if possible, if failure occurs
during build phase |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.08.2011
20.02.2012
20.02.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.9
|
 |
