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 IC73969 Status: Closed

DB2 ENGINE TRAPS WHILE COMPILING A PL/SQL PACKAGE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The instance has the following set: 
 
db2set DB2_COMPATIBILITY_VECTOR=ORA 
db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES 
 
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is 
0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.) 
 
-------Frame------ ------Function + Offset------ 
0x09000000056455F0 sqloCrashOnCriticalMemoryValidationFailure + 
0x34 
0x0900000005650F7C 
sqloCrashOnCriticalMemoryValidationFailure@glue6DB + 0x78 
0x090000000897BA68 sqlofmblkEx + 0x7C 
0x09000000089F25BC sqlofmblkEx@glue7C4 + 0x78 
0x09000000050AD7E8 
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x4C 
0x09000000050A7C34 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur 
+ 0x22B8 
0x0900000008A347E8 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env 
+ 0x40 
0x0900000008C7933C 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ 
LOCK_INFOP16sqlra_cached_varPiPUl 
+ 0x778 
0x0900000008C77200 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb 
+ 0x52C 
0x0900000008C73F80 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x6BC 
0x0900000008C01008 sqlri_ddl_get_section__FP8sqlrr_cb + 0xAC 
0x0900000008C00D64 sqlri_ddl_common__FP8sqlrr_cb + 0x4CC 
0x0900000008C00840 sqlriddl__FP8sqlrr_cb + 0x3C 
0x0900000008AD7908 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x34 
0x0900000007B1A610 
sqlra_internal_sql__FP8sqlrr_cbPUciT3UlPiT3P10sqlz_valueP21sqlra 
_internal_sql_cb 
+ 0x3A8 
0x0900000006FC7798 
sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpdbP17 
sqlrl_table_parmsPbN211_ 
+ 0x204 
0x0900000006FC6B08 
sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpdbP17 
sqlrl_table_parmsPbN211_@glue107C 
+ 0xAC 
0x09000000067A40A0 
@107@sqlnq_findFn__FP12sqlnq_stringN21iPsP15sqlra_func_pathPUcPP 
9sqlnq_funPiT4P9sqlnq_pidP17sqlnn_dat_TYPTYPEP3locbsN314_ 
+ 0xA2C 
0x09000000089AE31C 
sqlnq_resolveFn__FP9sqlnq_pidP12sqlnq_stringPUcPiP3locisT6 + 
0x148 
0x09000000089F0B60 
sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3loci 
T6 
+ 0x250
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Using Oracle Compatibility Mode and compiling PL/SQL         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The instance has the following set:                          * 
*                                                              * 
*                                                              * 
*                                                              * 
* db2set DB2_COMPATIBILITY_VECTOR=ORA                          * 
*                                                              * 
* db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code * 
* is                                                           * 
* 0x00000033 (SEGV_ACCERR:Invalid permissions for mapped       * 
* object.)                                                     * 
*                                                              * 
*                                                              * 
* -------Frame------ ------Function + Offset------             * 
*                                                              * 
* 0x09000000056455F0                                           * 
* sqloCrashOnCriticalMemoryValidationFailure +                 * 
* 0x34                                                         * 
*                                                              * 
* 0x0900000005650F7C                                           * 
*                                                              * 
* sqloCrashOnCriticalMemoryValidationFailure@glue6DB + 0x78    * 
*                                                              * 
* 0x090000000897BA68 sqlofmblkEx + 0x7C                        * 
*                                                              * 
* 0x09000000089F25BC sqlofmblkEx@glue7C4 + 0x78                * 
*                                                              * 
* 0x09000000050AD7E8                                           * 
*                                                              * 
* sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x4C        * 
*                                                              * 
* 0x09000000050A7C34                                           * 
*                                                              * 
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P * 
* 14sq                                                         * 
* lrr_cmpl_enviT7PP9sqlnq_qur                                  * 
*                                                              * 
* + 0x22B8                                                     * 
*                                                              * 
* 0x0900000008A347E8                                           * 
*                                                              * 
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P * 
* 14sq                                                         * 
* lrr_cmpl_env                                                 * 
*                                                              * 
* + 0x40                                                       * 
*                                                              * 
* 0x0900000008C7933C                                           * 
*                                                              * 
* sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14S * 
* QLP_                                                         * 
* LOCK_INFOP16sqlra_cached_varPiPUl                            * 
*                                                              * 
* + 0x778                                                      * 
*                                                              * 
* 0x0900000008C77200                                           * 
*                                                              * 
* sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_ * 
* idUi                                                         * 
* T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12 * 
* _P14                                                         * 
* SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb                   * 
*                                                              * 
* + 0x52C                                                      * 
*                                                              * 
* 0x0900000008C73F80 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 +      * 
* 0x6BC                                                        * 
* 0x0900000008C01008 sqlri_ddl_get_section__FP8sqlrr_cb + 0xAC * 
*                                                              * 
* 0x0900000008C00D64 sqlri_ddl_common__FP8sqlrr_cb + 0x4CC     * 
*                                                              * 
* 0x0900000008C00840 sqlriddl__FP8sqlrr_cb + 0x3C              * 
*                                                              * 
* 0x0900000008AD7908                                           * 
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +                * 
* 0x34                                                         * 
*                                                              * 
* 0x0900000007B1A610                                           * 
*                                                              * 
* sqlra_internal_sql__FP8sqlrr_cbPUciT3UlPiT3P10sqlz_valueP21s * 
* qlra                                                         * 
* _internal_sql_cb                                             * 
*                                                              * 
* + 0x3A8                                                      * 
*                                                              * 
* 0x0900000006FC7798                                           * 
*                                                              * 
* sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpd * 
* bP17                                                         * 
* sqlrl_table_parmsPbN211_                                     * 
*                                                              * 
* + 0x204                                                      * 
*                                                              * 
* 0x0900000006FC6B08                                           * 
*                                                              * 
* sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpd * 
* bP17                                                         * 
* sqlrl_table_parmsPbN211_@glue107C                            * 
*                                                              * 
* + 0xAC                                                       * 
*                                                              * 
* 0x09000000067A40A0                                           * 
*                                                              * 
* @107@sqlnq_findFn__FP12sqlnq_stringN21iPsP15sqlra_func_pathP * 
* UcPP                                                         * 
* 9sqlnq_funPiT4P9sqlnq_pidP17sqlnn_dat_TYPTYPEP3locbsN314_    * 
*                                                              * 
* + 0xA2C                                                      * 
*                                                              * 
* 0x09000000089AE31C                                           * 
*                                                              * 
* sqlnq_resolveFn__FP9sqlnq_pidP12sqlnq_stringPUcPiP3locisT6 + * 
*                                                              * 
* 0x148                                                        * 
*                                                              * 
* 0x09000000089F0B60                                           * 
*                                                              * 
* sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3 * 
* loci                                                         * 
* T6                                                           * 
*                                                              * 
* + 0x250                                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply this fix.                                              * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.01.2011
07.12.2011
07.12.2011
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.