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) |
****************************************************************
* 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. *
**************************************************************** |
