|
Problem IT07165
|
Status: Closed |
LOAD FAILS WHEN INPUT LOB OR XML FILE IS LARGER THAN 4GB |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
A LOAD operation that includes lob or xml file(s) as input, will
fail
if the lob or xml file is larger than 4GB. You will see
messages in
db2diag.log like the following:
2015-01-28-02.51.07.510657+540 E3503836644A1787 LEVEL:
Warning
PID : 38404518 TID : 87092 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-2015 APPID: *N0.db2inst1.150127174905
AUTHID : DB2INST1 HOSTNAME: myhost1
EDUID : 87092 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, oper system services, sqloFileStats, probe:20
MESSAGE : ZRC=0x870F014C=-2029059764=SQLO_FSIZE_BIG "file size
too big."
DATA #1 : String, 17 bytes
File size too big
DATA #2 : File size, 8 bytes
7911117440
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x09000000067C0BAC sqloFileStats + 0x2EC
[1] 0x0900000006761E04 sqloFileStats + 0x1D4
[2] 0x0900000005725F74 sqloFileStatsEx + 0x4C0
[3] 0x09000000033BFA28
@161@sqluGetFileSizeIfExist__FPcPbPlP17SQLU_FORMATTER_CB + 0x390
[4] 0x09000000033BC82C
@161@sqluLoadFindFileInPath__FP13SQLUCACB_TYPEiT2PcT4P14sqluiSpe
cifierP9sqllf_csoUiPbP17SQLU_FORMATTER_CB + 0x480
[5] 0x09000000033BD2A0
sqluSetupLobfile__FPUcN21iPbPiPsN24T6P17SQLU_FORMATTER_CBUi +
0x398
[6] 0x09000000033CDD6C
sqlulccf__FPUciT2P8SQLD_TCBP10sqlz_valueP8sqluicwaP8sqeAgentUi +
0x2850
[7] 0x09000000033D1670
sqluGetAndFormatRecords__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBUi
PPUciP10sqlz_valuePUcPP10SQLD_VALUET8Pi + 0x61C
[8] 0x09000000033D5A44
sqluGetAndFormatRecords__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBUi
PPUciP10sqlz_valuePUcPP10SQLD_VALUET8Pi + 0x302C
[9] 0x0900000002A76F8C iRun__14sqluCFormatterFv + 0x17B8
[10] 0x09000000036EE314 sqluLoadEDUDriver__FPUcUi + 0xA30
[11] 0x0900000005ADD77C sqloEDUEntry + 0x4A8
[12] 0x0900000000549E10 _pthread_body + 0xF0
[13] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
This problem only occurs on DB2 10.5 Fix Pack 5. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 6 or higher. *
**************************************************************** |
| Local Fix: |
Use file sizes less than 4 GB |
| Solution |
First fixed in DB2 Version 10.5 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.02.2015
23.09.2015
22.04.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.6
|
 |
| 10.5.0.7
|
|
