IBM Support

LI74499: A CLIENT PROCESS RUNNING IMPORT AGAINST A REMOTE SERVER MAY CRASH

Subscribe

You can track all active APARs for this component.

 

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:

    IC64050

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":"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:
24 February 2010