IBM Support

LI73844: DB2 INTERNAL LOGIC ERROR MAYBE CRASH DB2 INSTANCE WHEN DGTT TABLE IS USED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Dropping the DGTT table maybe crash intance due to the program
    internal logic error.
    
    Stack trace:
    
    0000002A955664D4 _intel_fast_memcmp + 0x0050
      (/home/nagopi51/sqllib/lib64/libirc.so)
    0000002A9797889A
    _Z20sqlrl_drop_g_t_tableP8sqlrr_cbPhsP8sqlrg_pdi + 0x0282
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A979743E9
    _Z23sqlrl_declare_g_t_tableP8sqlrr_cbPhsP17sqlrl_table_parmsP8sq
    lrg_pdP12sqlrg_seq_pdP18sqlrg_datapartinfo + 0x0611
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971D2C2C
    _Z22sqlnq_create_table_endP9sqlnq_qtbmiS0_RmP10sqlrl_fldsP25sqln
    q_base_table_seq_info + 0x281c
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971BC7D6 address: 0x0000002A971BC7D6 ; dladdress:
    0x0000002A95697000 ; offset in lib: 0x0000000001B257D6 ;
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971B9FC2
    _Z17sqlnq_table_defn2PP8stknode_i10actiontypePhP3loc + 0x03f2
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A98063889 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0459
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A96587F17 _Z12sqlnp_parserP8sqlnp_cb + 0x0aaf
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A96586C86 _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur +
    0x0376
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A9654A810
    _Z10sqlnn_cmplP20sqle_agent_privatecbP11sqlrrstrings17sqlnn_comp
    ileModesP14sqlrr_cmpl_enviiPP9sqlnq_qur + 0x0788
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    

Local fix

  • NO
    

Problem summary

  • internal logic error.
    
    Stack trace:
    
    0000002A955664D4 _intel_fast_memcmp + 0x0050
      (/home/nagopi51/sqllib/lib64/libirc.so)
    0000002A9797889A
    _Z20sqlrl_drop_g_t_tableP8sqlrr_cbPhsP8sqlrg_pdi + 0x0282
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A979743E9
    _Z23sqlrl_declare_g_t_tableP8sqlrr_cbPhsP17sqlrl_table_parmsP8sq
    lrg_pdP12sqlrg_seq_pdP18sqlrg_datapartinfo + 0x0611
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971D2C2C
    _Z22sqlnq_create_table_endP9sqlnq_qtbmiS0_RmP10sqlrl_fldsP25sqln
    q_base_table_seq_info + 0x281c
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971BC7D6 address: 0x0000002A971BC7D6 ; dladdress:
    0x0000002A95697000 ; offset in lib: 0x0000000001B257D6 ;
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A971B9FC2
    _Z17sqlnq_table_defn2PP8stknode_i10actiontypePhP3loc + 0x03f2
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A98063889 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0459
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A96587F17 _Z12sqlnp_parserP8sqlnp_cb + 0x0aaf
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A96586C86 _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur +
    0x0376
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    0000002A9654A810
    _Z10sqlnn_cmplP20sqle_agent_privatecbP11sqlrrstrings17sqlnn_comp
    ileModesP14sqlrr_cmpl_enviiPP9sqlnq_qur + 0x0788
      (/home/nagopi51/sqllib/lib64/libdb2e.so.1)
    

Problem conclusion

  • First Fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

  • NO
    

Comments

APAR Information

  • APAR number

    LI73844

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-23

  • Closed date

    2009-06-01

  • Last modified date

    2009-06-01

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

    LI73843

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSN

       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