DB2 - Problembeschreibung
Problem IT07165 | Status: Geschlossen |
LOAD FAILS WHEN INPUT LOB OR XML FILE IS LARGER THAN 4GB | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.02.2015 23.09.2015 22.04.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.6 | |
10.5.0.7 |