You may encounter bad performance while mass inserting Data into a DB2 Table.

By default, the nagling is enabled on the TCP sockets. This improves overall performance, but it might briefly delay transmission of smaller packets. If the delay is undesirable or unacceptable (like delayed ACK), then you can add this entry to the registry to disable nagling only for the MsDb2 Provider :

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Host Integration Server\Data Integration\
and/or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Host Integration Server\Data Integration\

Add the name TcpNoDelay to the subkey, set the data type to the REG_SZ data type, and then set the value to Yes.

For Host Integration Server 2009, you need to install first the following KB : KB978452

For Host Integration Server 2010, 2013, you only need to add the registry entry.

Advertisements