IBM Support

LI73896: SIGNAL 11 IN SQLV_HEX2HEXCHARS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 may trap in sqlv_hex2hexchars. Stack traceback may look
    like:
    
    <StackTrace>
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    00002AC454480A61 ossDumpStackTrace + 0x007d
            (/opt/IBM/db2/V9.5/lib64/libdb2osse.so.1)
    00002AC45447C75E _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
            (/opt/IBM/db2/V9.5/lib64/libdb2osse.so.1)
    00002AC45099CE20 sqlo_trce + 0x0342
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC4509D9B3F sqloEDUCodeTrapHandler + 0x0105
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44E2DDE70 address: 0x00002AC44E2DDE70 ; dladdress:
    0x00002AC44E2D0000 ; offset in lib: 0x000000000000DE70 ;
            (/lib64/libpthread.so.0)
    00002AC4512C00FF sqlv_hex2hexchars + 0x0059
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44FB5727D sqlnls_fill_error + 0x0119
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44FB5BFD2 sqlnlscpRequestPkgInfo + 0x03d4
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC45155EB26 address: 0x00002AC45155EB26 ; dladdress:
    0x00002AC44E4EB000 ; offset in lib: 0x0000000003073B26 ;
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC45155BE79
    _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
    15db2UCCursorInfo + 0x0219
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC450B864AC _Z14sqlrr_execimmdP14db2UCinterface + 0x00b4
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44FFD67C9
    _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject +
    0x00b5
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44F5815A4
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x03e8
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44F5818E9 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface
    + 0x030d
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    00002AC44F57F520 address: 0x00002AC44F57F520 ; dladdress:
    0x00002AC44E4EB000 ; offset in lib: 0x0000000001094520 ;
            (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
    
    or it may look like:
    
    0x09000000C5CE9F68 sqlv_hex2hexchars + 0x88
    0x09000000C5CE7DC0 sqlnls_fill_error + 0x280
    0x09000000C5F4C444 sqlnlscpRequestPkgInfo + 0x764
    0x09000000C5F35518
    sqlrr_rds_common_pre1__FP14db2UCinterfaceiT2Ui + 0x17D8
    0x09000000C5F376E8
    sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP
    15db2UCCursorInfo + 0x6A8
    0x09000000C629C5A8 sqlrr_excsqlset__FP14db2UCinterface + 0x528
    0x090000000A3A7144
    sqljsParseExcSqlSetObjects__FP13sqljsDrdaAsCbP14db2UCinterface +
    0x344
    0x090000000A3A7E8C
    sqljs_ddm_excsqlset__FP14db2UCinterfaceP13sqljDDMObject + 0x16C
    
    The problem exists in DB2 v9.5 only
    
    
    Component: engn_nls
    Defect: WSDBU00373358
    

Local fix

  • Local Fix / Work Around: Set APPHEAPSZ to a value instead of
                             AUTOMATIC.
    
    This may function as a work-around if the the db2diag.log
    contains "DIA8301C No memory available in the application heap"
    immediately prior to the crash.
    

Problem summary

  • Users Affected:  All
    
    Problem Description. DB2 may trap in the sqlv_hex2hexchars
    function
    
    Problem Summary: DB2 may trap on the sqlv_hex2hexchars function.
    

Problem conclusion

  • Problem first fixed in DB2 v9.5 FP4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73896

  • Reported component name

    DB2 UDB EXE LIN

  • Reported component ID

    5724E4904

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-24

  • Closed date

    2009-06-01

  • Last modified date

    2009-06-01

  • 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 UDB EXE LIN

  • Fixed component ID

    5724E4904

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 June 2009