Fixes are available
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
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:
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