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

CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY
LEAD TO A TRAP

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
If you have an application using a cursor-based update or delete
on a table with a RCAC (row and column access control) defined,
you may get a FODC_Trap with a similar stack ;


-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007FC3F794E936 _Z25ossDumpStackTrace
StackTraceV98 + 0x002b
                (/home/dbcvdp2/sqllib/lib64/libdb2osse.so.1)
0x00007FC3F794A767 OSSTrapFile::dumpEx(unsigned long, int,
siginfo*, void*, unsigned long) + 0x00d7
                (/home/dbcvdp2/sqllib/lib64/libdb2osse.so.1)
0x00007FC4011BA6E7 sqlo_trce + 0x03c7
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC401336BF1 sqloEDUCodeTrapHandler + 0x03d1
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC409D93890 address: 0x00007FC409D93890 ; dladdress:
0x00007FC409D81000 ; offset in lib: 0x0000000000012890 ;
                (/lib/x86_64-linux-gnu/libpthread.so.0)
0x00007FC400008D05 sqlng_prepare_SUBQ_operation(sqlng_blk*,
sqlnq_qnc*, int) + 0x0165
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFD04CE
sqlng_build_SBQR_opsqlng_build_SBQR_op(sqlng_blk*, sqlnq_pid*) +
0x120e
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400005DAE sqlng_process_parse_tree_node(sqlng_blk*,
sqlnq_pid*) + 0x05ce
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*)
+ 0x016b
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000073B9 sqlng_process_parse_tree_node(sqlng_blk*,
sqlnq_pid*) + 0x1bd9
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*)
+ 0x016b
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000073B9 sqlng_process_parse_tree_node(sqlng_blk*,
sqlnq_pid*) + 0x1bd9
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*)
+ 0x016b
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFC3FFA sqlng_build_TA_op(sqlng_blk*,
sqlng_scan_blk*, sqlno_qtb*) + 0x25fa
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFF4B56 sqlng_process_fetch_op(sqlng_blk*,
sqlno_plan_operator*) + 0x07f6
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*,
sqlno_plan_operator*) + 0x02d1
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFECB32 sqlng_process_pipe_op(sqlng_blk*,
sqlno_plan_operator*) + 0x02e2
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF9A7C5 sqlng_process_update_op(sqlng_blk*,
sqlno_plan_operator*) + 0x0385
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*,
sqlno_plan_operator*) + 0x02d1
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFFCBFF sqlng_process_temp_op(sqlng_blk*,
sqlno_plan_operator*) + 0x03af
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFEFFFA sqlng_scan_derived_table(sqlng_blk*,
sqlno_plan_operator*, unsigned char, sqlnq_qun*) + 0x059a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFEE599 sqlng_process_scan_op(sqlng_blk*,
sqlno_plan_operator*) + 0x0259
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400008E48 sqlng_prepare_SUBQ_operation(sqlng_blk*,
sqlnq_qnc*, int) + 0x02a8
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFD04CE sqlng_build_SBQR_op(sqlng_blk*, sqlnq_pid*) +
0x120e
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400005DAE sqlng_process_parse_tree_node(sqlng_blk*,
sqlnq_pid*) + 0x05ce
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*)
+ 0x016b
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFD0E8A sqlng_build_CASE_op(sqlng_blk*, sqlnq_pid*) +
0x089a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400005D47 sqlng_process_parse_tree_node(sqlng_blk*,
sqlnq_pid*) + 0x0567
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*)
+ 0x016b
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFCBB72 sqlng_build_FLTR_op(sqlng_blk*, sqlno_qtb*,
sqlno_iset*, sqlno_qun2plan_array*) + 0x01e2
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFFE089 sqlng_process_filter_op(sqlng_blk*,
sqlno_plan_operator*) + 0x0279
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*,
sqlno_plan_operator*) + 0x02d1
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFFECB32 sqlng_process_pipe_op(sqlng_blk*,
sqlno_plan_operator*) + 0x02e2
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4000F912E sqlng_process_return_op(sqlng_blk*,
sqlno_plan_operator*) + 0x09be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*,
sqlno_plan_operator*) + 0x00be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*,
sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFF8E635 sqlng_main(sqlnq_qur*) + 0x3045
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC400134DF7 sqlnn_cmpl(sqeAgent*, sqlrrstring*, short,
sqlnn_compileMode, short, sqlrr_cmpl_env*, int, int,
sqlnq_qur**) + 0x5c87
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC40012F161 sqlnn_cmpl(sqeAgent*, sqlrrstring*, short,
sqlnn_compileMode, short, sqlrr_cmpl_env*) + 0x0021
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC401C83A6A sqlra_compile_var(sqlrr_cb*, sqlra_cmpl_env*,
unsigned char*, int, unsigned short, int, int, int, int, int,
SQLP_LOCK_INFO*, sqlra_cached_var*, int*, SQLP_LOCK_INFO*,
bool*) + 0x110a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC401C9F205 sqlra_find_var(sqlrr_cb*, sqlra_cached_stmt*,
sqlra_stmt_id, unsigned int, unsigned int, unsigned char*,
unsigned int, unsigned short, unsigned char, sqlra_cmpl_env*,
sqlra_fill_mode, int*, int, int*, int, int, int, int*,
SQLP_LOCK_INFO*, sqlra_cached_var**, int*, bool,
SQLP_LOCK_INFO*, bool*) + 0x0905
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC401D44208 sqlra_get_var(sqlrr_cb*, int, int, bool,
bool*, bool*) + 0x0f48
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC4019B8A1E sqlrr_prepare(db2UCinterface*,
db2UCprepareInfo*) + 0x045e
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFA169B7 sqljs_ddm_prpsqlstt(db2UCinterface*,
sqljDDMObject*) + 0x0407
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFA0649B sqljsParseRdbAccessed(sqljsDrdaAsCb*,
sqljDDMObject*, db2UCinterface*) + 0x00eb
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFA0757E sqljsParse(sqljsDrdaAsCb*, db2UCinterface*,
sqeAgent*, bool) + 0x054e
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FF9FA4E6 address: 0x00007FC3FF9FA4E6 ; dladdress:
0x00007FC3F7EB8000 ; offset in lib: 0x0000000007B424E6 ;
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFA00B33 address: 0x00007FC3FFA00B33 ; dladdress:
0x00007FC3F7EB8000 ; offset in lib: 0x0000000007B48B33 ;
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FFA017EF sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) +
0x011f
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC3FF3FB3A3 sqeAgent::RunEDU() + 0x0de3
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC402ECB45E sqzEDUObj::EDUDriver() + 0x01be
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC40133408A sqloEDUEntry + 0x057a
                (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1)
0x00007FC409D886DB address: 0x00007FC409D886DB ; dladdress:
0x00007FC409D81000 ; offset in lib: 0x00000000000076DB ;
                (/lib/x86_64-linux-gnu/libpthread.so.0)
0x00007FC3F682D88F clone + 0x003f
                (/lib/x86_64-linux-gnu/libc.so.6)
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6 or later                                   *
****************************************************************
Local Fix:
N/A
Solution


Workaround


****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6 or later                                   *
****************************************************************


Comment


Upgrade to 11.5.6 or later


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

03.09.2020
21.06.2021
21.06.2021


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)