DB2 - Problem description
Problem IT37209 | Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Db2 Server may terminate abnormally with select from a table, after creating column mask and activating column access control for the table. When the select query is involved in a package, the same issue may occur when rebind the package. The stack looks similar to this example: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FA3A99D8FD6 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/home/db2di/sqllib/lib64/libdb2osse.so.1) 0x00007FA3A99D8C1B ossDumpStackTraceV98 + 0x002b (/home/db2di/sqllib/lib64/libdb2osse.so.1) 0x00007FA3A99D49C7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/home/db2di/sqllib/lib64/libdb2osse.so.1) 0x00007FA3B1294A29 sqlo_trce + 0x03e9 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1408851 sqloEDUCodeTrapHandler + 0x03d1 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B9065630 address: 0x00007FA3B9065630 ; dladdress: 0x00007FA3B9056000 ; offset in lib: 0x000000000000F630 ; (/lib64/libpthread.so.0) 0x00007FA3B0DA87D1 address: 0x00007FA3B0DA87D1 ; dladdress: 0x00007FA3A9F35000 ; offset in lib: 0x0000000006E737D1 ; (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B0D9E183 address: 0x00007FA3B0D9E183 ; dladdress: 0x00007FA3A9F35000 ; offset in lib: 0x0000000006E69183 ; (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B0DA6C92 address: 0x00007FA3B0DA6C92 ; dladdress: 0x00007FA3A9F35000 ; offset in lib: 0x0000000006E71C92 ; (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B0D9D151 _Z18sqlnq_compile_fgacP9sqlnq_qur + 0x0791 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B10DCF9C _Z9sqlns_qgsP9sqlnq_qur17sqlnq_requestTypePc + 0x02ac (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B027B78A _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x46da (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B02770A1 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0021 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1ADF6C6 _Z10sqlrr_cmplP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModehP5sql daPiPjPP9sqlri_shdP11compileInfo + 0x0516 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1D8BA4F _Z18sqlra_recreate_pkgP8sqlrr_cbiicP15sqlra_func_pathh + 0x2b3f (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1D1016D _Z16sqlra_rebind_pkgP8sqlrr_cbPhsS1_sS1_iicP15sqlra_func_pathb + 0x023d (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1D9E72E _Z37sqlraFindInvalidPackagesAndRebindThemP8sqlrr_cb + 0x07ce (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1D9D8DC _Z35sqlraPackageRebinderDaemonInnerMainP8sqeAgent + 0x04fc (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1D9C7F5 _Z35sqlraPackageRebinderDaemonOuterMainP8sqeAgent + 0x01d5 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3AF571343 _Z26sqleIndCoordProcessRequestP8sqeAgent + 0x0463 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3AF5984E1 _ZN8sqeAgent6RunEDUEv + 0x05a1 (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B2EF048E _ZN9sqzEDUObj9EDUDriverEv + 0x01be (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B1405D2A sqloEDUEntry + 0x057a (/home/db2di/sqllib/lib64/libdb2e.so.1) 0x00007FA3B905DEA5 address: 0x00007FA3B905DEA5 ; dladdress: 0x00007FA3B9056000 ; offset in lib: 0x0000000000007EA5 ; (/lib64/libpthread.so.0) 0x00007FA3A89D69FD clone + 0x006d (/lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |