IBM Support

IT20401: SQLCODE -902 FROM SQLRICLS_COMPLEX ON QUERY WITH COLUMN-ORGANIZED TABLES AND ROW-ORGANIZED DETACHED CSE TEMPS IN DPF

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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>
    

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.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

  • Set query compilation DEGREE to 1 for the affected query.
    

Comments

APAR Information

  • APAR number

    IT20401

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-28

  • Closed date

    2017-06-27

  • Last modified date

    2017-06-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020