|
Problem IC77930
|
Status: Closed |
LOAD OPERATIONS WITH COPY YES OPTION MAY FAIL WITH SQLO_SEM_TIMEOUT. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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,
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 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 :
| 04.08.2011
20.02.2012
20.02.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
