DB2 - Problem description
Problem IT29021 | Status: Closed |
DB2 TRAPS IN SQLRL_GET_FULL_NAME() | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
DB2 can trap with a stack like this: 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 _IO_ftrylockfile 6 __intel_ssse3_rep_memcpy 7 sqlrl_get_full_name 8 sqlrl_userTempDropIndex 9 sqlrlCGTTindexRefresh 10 sqlrlc_systables_fetch 11 sqlnq_cat_look2 12 sqlnq_cat_look 13 sqlnq_handle_qtb_extref_rec 14 sqlnq_handle_named_ref 15 sqlnq_handle_named_ref 16 sqlnq_handle_named_ref 17 sqlnq_handle_named_ref 18 sqlnq_handle_named_ref 19 sqlnq_handle_named_ref_in_src 20 sqlnq_handle_table_ref 21 sqlnq_handle_from_table_ref 22 sqlnq_sem 23 sqlnp_smactn 24 sqlnp_parser 25 sqlnp_main 26 sqlnn_cmpl 27 sqlnn_cmpl 28 sqlra_compile_var 29 sqlra_find_var 30 sqlra_get_var 31 sqlri_ddl_common 32 sqlriddl 33 sqlriSectInvoke 34 sqlrr_execute_immediate 35 sqlrr_execimmd 36 sqljs_ddm_excsqlimm 37 sqljsParseRdbAccessed 38 sqljsParse 39 sqljsSqlam 40 sqljsDrdaAsInnerDriver 41 sqljsDrdaAsDriver 42 sqeAgent::RunEDU 43 sqzEDUObj::EDUDriver 44 sqloEDUEntry 45 start_thread 46 clone The purpose of this APAR is to help avoid the trap by producing an SQL0901N error instead. In the db2diag.log a message like this will be added when this issue occurs: FUNCTION: DB2 UDB, catalog services, sqlrlCGTTindexRefresh, probe:14259 RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT "SQLCA has already been built" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT30778 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.05.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |