Fixes are available
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
A client process (it may be CLP, or other process that calls db2Import() API directly) running IMPORT against a remote server may crash. The crashing client process' stack trace includes the following functions: Example #1 - ... 00000000004898C8 clp_bp_sigterm + 0x00a4 (/home/v95fp3a/sqllib/bin/db2bp) 0000003486030280 address: 0x0000003486030280 ; dladdress: 0x0000003486000000 ; offset in lib: 0x0000000000030280 ; (/lib64/libc.so.6) 00002B395FF4B931 _Z20sqlak_callbDrdaInputP14db2UCinterface + 0x21b3 (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FDDDF02 _Z14sqljrGenSqlDtaP14db2UCinterfacej + 0x05bc (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FDF1573 _Z15sqljrDrdaArCallP14db2UCinterfaceP9UCstpInfo + 0x0107 (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395F766123 _Z8sqleprocPcP7sqlcharP5sqldaS3_P5sqlca + 0x07dd (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FC5E232 sqleproc_api + 0x00dc (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FDB78A8 _Z8sqluirmrP7sqluecbP11db2ImportInP12db2ImportOutP13SQLO_MEM_POO L + 0x06c8 (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FDB6BB6 _Z8sqluimptPcS_P15sqlu_media_listP7sqldcolP6sqllobS_P7sqlcharS_i P11db2ImportInP12db2ImportOutPiS1_PvP5sqlca + 0x0908 (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 00002B395FD4C44D db2Import + 0x04f5 (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) 000000000043307B _Z18clpbp_exe_sqluimptv + 0x01a1 (/home/v95fp3a/sqllib/bin/db2bp) ... note: we won't see the clp_bp_sigterm and clpbp_exe_sqluimpt if we are not using CLP to run the IMPORT. Example #2 - =>[1] sqlak_callbDrdaInput(0xffffffff7913eb90, 0x0, 0x88000000, 0xffffffff79121988, 0x4, 0xffffffff79121940), at 0xffffffff7e100d98 [2] sqljrGenSqlDta(0xffffffff7913eb90, 0x8000, 0xffffffff78f08608, 0x18, 0xffffffff78f081a0, 0x0), at 0xffffffff7e354d50 [3] sqljrDrdaArCall(0xffffffff7913eb90, 0xffffffff78f027f8, 0x0, 0x0, 0xffffffff7913f920, 0xffffffff7ed9c0c8), at 0xffffffff7e38eb3c [4] sqleproc(0xffffffff7fffdcb4, 0x4, 0xffffffff79121940, 0xffffffff7fffdce8, 0xffffffff7fffe444, 0x0), at 0xffffffff7e168d3c [5] sqleproc_api(0xffffffff7fffdcb4, 0x0, 0xffffffff7fffde2c, 0xffffffff7fffdce8, 0xffffffff7fffe444, 0x1), at 0xffffffff7e1354d4 [6] sqluirmr(0xffffffff78e20080, 0x13000010001, 0x64, 0x1664, 0xffffffff7fffea18, 0xffffffff7e957a10), at 0xffffffff7e3144bc [7] sqluimpt(0x1664, 0x1010000, 0xffffffff78e20080, 0x0, 0x1664, 0xffffffff7fffe8b0), at 0xffffffff7e313454 [8] db2Import(0xffffffff7fffe9e0, 0xffffffff7fffea88, 0xffffffff7ffff170, 0x0, 0x0, 0xffffffff7ed9c170), at 0xffffffff7e29dd20 [9] sqluimpr_api(0xffffffff7ffff13e, 0x0, 0x0, 0x100117840, 0xffffffff7ffff038, 0x0), at 0xffffffff7e29d578 [10] main(0xffffffff7ffff583, 0xffffffff7ffff587, 0xffffffff7ffff590, 0x100117840, 0x1, 0x100000000), at 0x100001438 You won't hit this problem if you use certain IMPORT options (rowcount, skipcount, restartcount, warningcount, commitcount automatic, allow write access, METHOD N, METHOD P)
Local fix
adding a WARNINGCOUNT n option with a large n (e.g. 2,000,000,000) will avoid this problem without changing the behaviour of your import operation
Problem summary
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * A client process (it may be CLP, or other process that calls * * * * db2Import() API directly) running IMPORT against a remote * * server * * may crash. The crashing client process' stack trace * * includes * * the following functions: * * * * * * * * Example #1 - * * * * * * * * ... * * * * 00000000004898C8 clp_bp_sigterm + 0x00a4 * * * * (/home/v95fp3a/sqllib/bin/db2bp) * * * * 0000003486030280 address: 0x0000003486030280 ; dladdress: * * * * 0x0000003486000000 ; offset in lib: 0x0000000000030280 ; * * * * (/lib64/libc.so.6) * * * * 00002B395FF4B931 _Z20sqlak_callbDrdaInputP14db2UCinterface + * * * * 0x21b3 * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FDDDF02 _Z14sqljrGenSqlDtaP14db2UCinterfacej + * * 0x05bc * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FDF1573 * * _Z15sqljrDrdaArCallP14db2UCinterfaceP9UCstpInfo * * + 0x0107 * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395F766123 _Z8sqleprocPcP7sqlcharP5sqldaS3_P5sqlca + * * * * 0x07dd * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FC5E232 sqleproc_api + 0x00dc * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FDB78A8 * * * * _Z8sqluirmrP7sqluecbP11db2ImportInP12db2ImportOutP13SQLO_MEM_P * L + 0x06c8 * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FDB6BB6 * * * * _Z8sqluimptPcS_P15sqlu_media_listP7sqldcolP6sqllobS_P7sqlcharS * P11db2ImportInP12db2ImportOutPiS1_PvP5sqlca + 0x0908 * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 00002B395FD4C44D db2Import + 0x04f5 * * * * (/opt/ibm/db2/V9.5fp3a/lib64/libdb2.so.1) * * * * 000000000043307B _Z18clpbp_exe_sqluimptv + 0x01a1 * * * * (/home/v95fp3a/sqllib/bin/db2bp) * * * * ... * * * * * * * * note: we won't see the clp_bp_sigterm and clpbp_exe_sqluimpt * * if * * we are not using CLP to run the IMPORT. * * * * * * * * Example #2 - * * * * * * * * =>[1] sqlak_callbDrdaInput(0xffffffff7913eb90, 0x0, * * 0x88000000, * * 0xffffffff79121988, 0x4, 0xffffffff79121940), at * * * * 0xffffffff7e100d98 * * * * [2] sqljrGenSqlDta(0xffffffff7913eb90, 0x8000, * * * * 0xffffffff78f08608, 0x18, 0xffffffff78f081a0, 0x0), at * * * * 0xffffffff7e354d50 * * * * [3] sqljrDrdaArCall(0xffffffff7913eb90, * * 0xffffffff78f027f8, * * 0x0, 0x0, 0xffffffff7913f920, 0xffffffff7ed9c0c8), at * * * * 0xffffffff7e38eb3c * * * * [4] sqleproc(0xffffffff7fffdcb4, 0x4, 0xffffffff79121940, * * * * 0xffffffff7fffdce8, 0xffffffff7fffe444, 0x0), at * * * * 0xffffffff7e168d3c * * * * [5] sqleproc_api(0xffffffff7fffdcb4, 0x0, * * 0xffffffff7fffde2c, * * 0xffffffff7fffdce8, 0xffffffff7fffe444, 0x1), at * * * * 0xffffffff7e1354d4 * * * * [6] sqluirmr(0xffffffff78e20080, 0x13000010001, 0x64, * * 0x1664, * * 0xffffffff7fffea18, 0xffffffff7e957a10), at * * 0xffffffff7e3144bc * * [7] sqluimpt(0x1664, 0x1010000, 0xffffffff78e20080, 0x0, * * * * 0x1664, 0xffffffff7fffe8b0), at 0xffffffff7e313454 * * * * [8] db2Import(0xffffffff7fffe9e0, 0xffffffff7fffea88, * * * * 0xffffffff7ffff170, 0x0, 0x0, 0xffffffff7ed9c170), at * * * * 0xffffffff7e29dd20 * * * * [9] sqluimpr_api(0xffffffff7ffff13e, 0x0, 0x0, * * 0x100117840, * * 0xffffffff7ffff038, 0x0), at 0xffffffff7e29d578 * * * * [10] main(0xffffffff7ffff583, 0xffffffff7ffff587, * * * * 0xffffffff7ffff590, 0x100117840, 0x1, 0x100000000), at * * * * 0x100001438 * * * * * * * * You won't hit this problem if you use certain IMPORT options * * * * (rowcount, skipcount, restartcount, warningcount, * * commitcount * * automatic, allow write access, METHOD N, METHOD P) * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fixpack 5. * ****************************************************************
Problem conclusion
First fixed in DB2 Version 9.5 Fixpack 5.
Temporary fix
Comments
APAR Information
APAR number
LI74499
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
2009-05-15
Closed date
2010-02-24
Last modified date
2010-02-24
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 PSN
UP
R950 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":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
17 October 2021