DB2 - Problem description
Problem IT01754 | Status: Closed |
LOAD OPERATIONS INVOLVING XML OR LOB DATA IN NON-PARALLEL ENVIRONMENTS MAY CRASH IN INTERNAL HANDLE MANIPULATION FUNCTIONS | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
This is seen in very large and long-running loads with INTRA_PARALLEL set to NO Stack is showing: <StackTrace> -------Frame------ ------Function + Offset------ 0x0900000005D9A828 sqlrh_return_value__FP8sqlrr_cbPUiPP10sqlz_valuePiPUcUiUl + 0x390 0x090000000492DE58 sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x218 0x0900000006ADF66C xmlrnCSOInputStreamInitialize__19XmlrnCSOInputStreamFP8sqeAgent + 0x78 0x0900000008A03BC0 xmlrnInsertDocument__FP11XmlrnIUD_CB + 0x498 0x09000000065E84C0 @148@sqldFormatXDADesc__FP8sqeAgentP13SQLD_TDATARECT2P8SQLD_TCBi T5PUlPiP10sqlz_valueT8P8SQLD_CCB + 0xB4C 0x090000000669F984 sqluLoadFormatFixedVar__FP8sqeAgentP13SQLD_TDATARECT2PP10SQLD_VA LUEiP8SQLD_TCBPiPUcP15SQLD_XOR_UPDATEP8SQLD_CCBP17SQLU_FORMATTER _CB + 0xD8 0x09000000065E33BC sqluFormatDMRec__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBUiPP10SQLD _VALUEP14sqlrg_mdc_infoP12SQLU_RP_INFOT3i + 0x1460 0x0900000006695A4C @148@sqluGetAndFormatRecords__FP8sqlulacbP13SQLUCACB_TYPEP17SQLU _FORMATTER_CBUiPPUciP10sqlz_valuePUcPP10SQLD_VALUET9Pi + 0xA8C 0x090000000668DBF0 iRun__14sqluCFormatterFv + 0xF9C 0x090000000755C70C sqluLoadEDUDriver__FPUcUi + 0x5A4 0x0900000004E5ACC0 sqloEDUEntry + 0x1C </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.7 FP10 * **************************************************************** | |
Local Fix: | |
Turn INTRA_PARALLEL ON | |
Solution | |
First fixed in V9.7 FP10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.05.2014 10.11.2014 10.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |