| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT38563 | Status: Closed |
DATABASE CRASH WHEN ARRAY TYPE VARIABLE USED IN "DGTT AS (SELECT..) WITH DATA" SQL STATEMENT | |
| product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
| Problem description: | |
Database crash can happen when array type variable used in "DGTT AS (SELECT ..) WITH DATA" SQL statement. The relevant stack shows: gsignal sqloExitEDU sqle_panic(int) sqloCrashOnCriticalMemoryValidationFailure sqlofmblkEx sqlriArrayDescriptor::destroy() sqlriArrayDescriptor::copy(sqlrr_cb*, sqlriArrayDescriptor*, bool) sqlrxArrayCopy(sqeAgent*, sqlz_value*, sqlz_value*, bool) sqlriSetupGlobalVariablesInSection(sqlrr_cb*, sqlri_shd*) sqlriInitializeGlobalVariables(sqlrr_cb*) sqlriSectInvoke(sqlrr_cb*, sqlri_opparm*) sqlrr_smp_router(sqlrr_cb*) sqlrr_subagent_router(sqeAgent*, SQLE_DB2RA_T*) sqleProcessSubRequest(sqeAgent*) sqeAgent::RunEDU() sqzEDUObj::EDUDriver() sqlzRunEDU(char*, unsigned int) sqloEDUEntry Workaround: - set DEGREE=1 - Split SQL into two SQLs, "DGTT (SELECT ..) WITH NO DATA" + "INSERT" | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ARRAY TYPE VARIABLE * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description, install the fix. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or higher * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * ARRAY TYPE VARIABLE * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description, install the fix. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or higher * **************************************************************** | |
| Comment | |
Upgrade to 11.5.7 or higher | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.09.2021 01.12.2021 01.12.2021 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
