IY95759: A DB2 CLIENT PROCESS CAN HANG IN SQLCCTCPSEND IN DB2 V9 FIXPAK 2 ON AIX

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Due to the implementation of SSL support in db2 udb v9.1 fixpak
    2.
    ( see technote :
    http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc
    =DA400&uid=swg21249656&loc=en_US&cs=UTF-8&lang=en&rss=ct71db2 )
    
    A 32-bit AIX client can hang when connecting to a
    server.
    
    A stack of the hanging process will show sqlcctcpsend as the top
    function.  DB2 trace will be similar.  The server side will
    never receive the data sent from the client.
    
    
    11803        103:989800512   | SQLConnect1 entry
    11804        103:989801293   | | CLI_utlValidateLength entry
    11805        103:989801813   | | CLI_utlValidateLength exit
    ...
    ...
    12696        103:996394709   | | | | | | | | | | | sqlccsend
    entry
    12697        103:996395271   | | | | | | | | | | | sqlccsend
    data [probe
    1]
    12698        103:996395927   | | | | | | | | | | | sqlccsend
    data [probe
    2]
    12699        103:996396521   | | | | | | | | | | | sqlccsend
    data [probe
    3]
    12700        103:996397282   | | | | | | | | | | | |
    sqlcctcpsend entry
    12701        103:996397628   | | | | | | | | | | | |
    sqlcctcpsend data
    [probe 30]
    12702        103:996398528   | | | | | | | | | | | | | sqlohsig
    entry
    12703        103:996408059   | | | | | | | | | | | | | sqlohsig
    exit
    

Local fix

  • n/a
    

Problem summary

  • Users Affected : All users using 32bit AIX clients running
    fixpak 2.
    Problem description : the client application will hang.
    Problem summary : Application will be stuck in sqlcctcpsend
    code.
    

Problem conclusion

  • First fixed in db2 udb Version 9.1 fixpak 2a
    

Temporary fix

Comments

APAR Information

  • APAR number

    IY95759

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive

  • Submitted date

    2007-03-08

  • Closed date

    2007-06-18

  • Last modified date

    2007-10-30

  • 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 ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R910 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

910

Reference #:

IY95759

Modified date:

2007-10-30

Translate my page

Machine Translation

Content navigation