DB2 - Problem description
Problem IC94719 | Status: Closed |
INSTANCE CRASH WHEN USING ASSOCIATIVE ARRAY OF VARIABLE LENGTH | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
DB2 may crash when invoking a stored procedure that contains a variable that is mapped to an associative array of variable length. The call stack that gets generated from the DB2 trap file will be as follows: <associativeArrayHeader::cloneHelper> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriArray.C:6564> <associativeArrayHeader::cloneAssocArrayHdr> <T:\db2_galileo\ntx64\s120403\engn\include\sqlriArray.h:585> <sqlriArrayDescriptor::cloneDyn> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriArray.C:1564> <sqlriArrayDescriptor::copy> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriArray.C:1878> <sqlrxArrayCopy> <T:\db2_galileo\ntx64\s120403\engn\sqv\sqlrxArray.C:71> <sqlriSetupGlobalVariablesInSection> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriSectInit.C:7996> <sqlriInitializeGlobalVariables> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlri_misc.C:8264> <sqlriSectInvoke> <T:\db2_galileo\ntx64\s120403\engn\include\sqlriManageSections.h :1582> <sqlrr_process_execute_request> <T:\db2_galileo\ntx64\s120403\engn\include\sqlriManageSections.h :1329> <sqlrr_execute> <T:\db2_galileo\ntx64\s120403\engn\sqr\sqlrr_req_sql.C:848> <pvmPackage::executeSection> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_pvm.C:2991> <PVM::run> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_pvm.C:6004> <pvm_entry> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_entrypoints.C:220> <sqloInvokeFnArgs> <T:\db2_galileo\ntx64\s120403\engn\sqo\sqloutil.C:1579> <sqlriInvokerTrusted> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriudf.C:8547> <sqlriInvokeInvoker> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriudf.C:7071> <sqlricall> <T:\db2_galileo\ntx64\s120403\engn\sqri\sqlriudf.C:2013> <sqlriSectInvoke> <T:\db2_galileo\ntx64\s120403\engn\include\sqlriManageSections.h :1582> <sqlrr_process_execute_request> <T:\db2_galileo\ntx64\s120403\engn\sqr\sqlrr_sql.C:1609> <sqlrr_execute> <T:\db2_galileo\ntx64\s120403\engn\sqr\sqlrr_req_sql.C:848> <pvmPackage::executeSection> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_pvm.C:2991> <PVM::run> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_pvm.C:6004> <pvm_entry> <T:\db2_galileo\ntx64\s120403\engn\psm\psm_entrypoints.C:220> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7, Fixpak 9 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.7, Fixpak 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.08.2013 10.02.2014 10.02.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.0., 9.7. | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.9 | |
9.7.0.9 |