home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC78901 Status: Closed

ENGINE CRASHING WHILE COMPILING ORACLE PACKAGE CODE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Engine trap when freeing pUCintfc->pXcompArea 
 
 
The stack looks like: 
 
pdresilience.sqloCrashOnCriticalMemoryValidationFailure() at 
0x9000000056f3fdc 
sqloCrashOnCriticalMemoryValidationFailure@glue6F1() at 
0x9000000056fa170 
sqlbfix.sqlofmblkEx.fdpr.chunk.7 at 0x900000008e9e77c 
sqlofmblkEx@glue7E6 at 0x900000008f737fc 
sqlnp_main.fdpr.chunk.2 at 0x900000005085600 
sqlnn_cmpl.fdpr.chunk.32 at 0x90000000507eb48 
sqlnn_cmpl at 0x90000000909a054 
sqlra_compile_var at 0x90000000921e984 
sqlra_find_var at 0x900000009220934 
sqlra_get_var at 0x900000009221758 
sqle_agent_services.sqlri_ddl_get_section at 0x90000000926ffec 
sqlri_ddl_common at 0x90000000926fd48 
sqlriddl at 0x90000000926f820 
sqlriSectInvoke.fdpr.chunk.4 at 0x900000009024704 
sqlra_internal_sql.fdpr.chunk.27 
sqlnn_regen_procedure.fdpr.chunk.4 at 0x90000000737f33c 
.@149@sqlrlFindProcedurePostProc at 0x9000000073a706c 
.@149@sqlrlFindProcedureWithQualifier.fdpr.chunk.5 at 
0x9000000079c8bb8 
.@149@sqlrlFindModuleProcedure 
.@149@sqlrlFindProcedureWithQualifier.fdpr.chunk.2 at 
0x9000000073a4348 
 
It crashed while trying to clean up the structure: 
sqlexc_XcompArea because it points to an address that doesn't 
correspond to an allocated block. 
Possibly a stale pointer stored (and not cleared) in 
pUCintfc->pXcompArea from an earlier compilation ends up being 
referenced in a subsequent compilation.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97fp6                                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fixed in DB2 Version 97 Fixpack 6.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.09.2011
10.12.2012
10.12.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList