DIA3208E Error encountered in TCP/IP protocol support

30 March,2013 by Tom Collins

Question : I recently received a query from an application owner, who reported application outage issue.

 An inspection of the db2diag.log file found this message. How can I solve this problem?

DIA3208E  Error encountered in TCP/IP protocol support. TCP/IP function "close". Socket was "3". Errno was "9".
 Errno was "9".


Answer: The DIA3208E  Error encountered in TCP/IP protocol support  message indicates multiple db2tcpcm processes. If the instance is stopping and there is an attempt to terminate the sockets simultaneously , only one can close without an error

Option 1 -   db2set DB2TCPCONNMGRS=1

Option 2 – Install DB2 version 9.5 FixPack 6

 Read More

DB2 – verify DB2 is available - DBA DB2

Locate the DB2 connection port number on Linux - DBA DB2

DB2 - Collecting data for database performance problems - DBA DB2

Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DIA3208E Error encountered in TCP/IP protocol support

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright