IBM Support

IC66500: THE DIA3208E ERROR IS LOGGED IN DB2DIAG.LOG WHEN DB2STOP IS CALLED WHILE THE INSTANCE IS STOPED SUCCESSFULLY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The DIA3208E error is logged in db2diag.log when multiple
    communication managers ( tcpcm ) are working and db2stop is
    called while the instance is stoped successfully.
      The following db2diag.log entry at db2stop is a eye-catcher of
    this issue.
    
    $ db2stop
    2008-10-07 09:35:47     0   0   SQL1064N  DB2STOP processing was
    successful.
    DB2STOP processing was successful.
    
    $ db2diag
    2008-10-07-09.35.45.429886+540 I46390A429         LEVEL: Error
    PID     : 729240               TID  : 1800        PROC : db2sysc
    0
    INSTANCE: db2v9ins             NODE : 000
    EDUID   : 1800                 EDUNAME: db2tcpcm 0
    FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child,
    probe:155
    MESSAGE : DIA3208E Error encountered in TCP/IP protocol support.
    TCP/IP
              function "close". Socket was "6". Errno was "9".
    

Local fix

  • db2set DB2TCPCONNMGRS=1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User using database with multiple connections                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The DIA3208E error logs are recorded on                      *
    * multiplecommunication managers ( tcpcm ) working when        *
    * db2stop iscalled even if the instance is stoped              *
    * successfully.                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2 Version 9.7 FixPak 2                          *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 FixPak 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC66500

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-22

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

  • APAR is sysrouted FROM one or more of the following:

    IZ36186

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC66500

Modified date: 25 May 2010