|
Problem IT20401
|
Status: Closed |
SQLCODE -902 FROM SQLRICLS_COMPLEX ON QUERY WITH COLUMN-ORGANIZED TABLES AND ROW-ORGANIZED DETACHED CSE TEMPS IN DPF |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
A query terminated abnormally with severe error sqlcode -902 in
sqlricls_complex.
(It is possible the same defect could result in other severe
sqlcodes such as -901.)
The error scenario can occur only when all of the following
conditions hold:
- DPF configuration
- the query references column-organized tables
- the access plan chosen by the query compiler contains a
detached common subexpression TEMP in the row-organized portions
of the access plan
- the access plan also contains multiple row-organized portions
of the access plan interspersed with column-organized portions
db2diag.log
2016-12-01-22.39.24.195012-300 I19876154E940         LEVEL:
Severe
PID     : 947                  TID : 139914981140224 PROC :
db2sysc 2
INSTANCE: db2inst1             NODE : 002            DB   :
BLUDB
APPHDL  : 0-34288              APPID:
9.9.9.9.33991.161202141947
AUTHID  : DB2INST1             HOSTNAME: ims2114
EDUID   : 10816                EDUNAME: db2agnts (BLUDB) 2
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
MESSAGE : ZRC=0x8759007F=-2024210305=SQLKF_PGM_ERROR "FCM coding
error"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -902   sqlerrml: 3
 sqlerrmc: 127
 sqlerrp : SQLRI1C6
 sqlerrd : (1) 0x8759007F      (2) 0x0000007F      (3)
0x00000000
           (4) 0x00000000      (5) 0xFFFFF1FD      (6)
0x00000002
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)  
           (7)      (8)      (9)      (10)        (11)    
 sqlstate:
Stack Trace
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F409546C366
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
                (/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00007F409546BFAB ossDumpStackTraceV98 + 0x002b
                (/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00007F4095468157 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
                (/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00007F409C5FFA17 sqlo_trce + 0x03c7
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409C764F3B sqloDumpDiagInfoHandler + 0x020b
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F40A38A8850 address: 0x00007F40A38A8850 ; dladdress:
0x00007F40A3899000 ; offset in lib: 0x00000
0000000F850 ;
                (/lib64/libpthread.so.0)
0x00007F40A38A59C6 pthread_kill + 0x0036
                (/lib64/libpthread.so.0)
0x00007F409C764AF2 sqloDumpEDU + 0x0052
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409797B8BB _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x167b
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409CD74200 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x07d0
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409E1853F7 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a7
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409E184AC0
_Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x0940
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409CE8C0E5 _Z11sqlrrMapZrcP8sqlrr_cbjmi + 0x0035
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409D55B30F _Z16sqlricls_complexP8sqlrr_cbilll + 0x54bf
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409CDB562A
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0eaa
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409A9759CD address: 0x00007F409A9759CD ; dladdress:
0x00007F40959BD000 ; offset in lib: 0x00000
00004FB89CD ;
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409A9742A0 _Z21sqleProcessSubRequestP8sqeAgent + 0x03e0
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409A9A83B7 _ZN8sqeAgent6RunEDUEv + 0x05d7
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409E185956 _ZN9sqzEDUObj9EDUDriverEv + 0x0116
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F409C762428 sqloEDUEntry + 0x0578
                (/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00007F40A38A0806 address: 0x00007F40A38A0806 ; dladdress:
0x00007F40A3899000 ; offset in lib: 0x00000
00000007806 ;
                (/lib64/libpthread.so.0)
0x00007F40944C19BD clone + 0x006d
                (/lib64/libc.so.6)
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher *
**************************************************************** |
| Local Fix: |
Disable intraquery parallelism for the query by, for example,
setting the CURRENT DEGREE special register to 1 (dynamic
queries) or binding the application with bind option DEGREE 1. |
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 |
| Workaround |
Set query compilation DEGREE to 1 for the affected query. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.04.2017
27.06.2017
27.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
