IBM Support

IT37209: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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:
    
    <StackTrace>
    -----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)
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37209

  • 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

    2021-06-10

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT37308 IT39523

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
04 May 2022