IBM DB2 tuning parameters: WebSphere Application Server http://publib7b.boulder.ibm.com/wasinfo1/en/info/ae/ae/rprf_db2parameters.html

IBM Redbook SG24-6417: DB2 UDB/WebSphere Performance Tuning Guide http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/SG246417.html

IBM Redbook SG24-6012: DB2 UDB V7.1 Performance Tuning Guide http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/SG246012.html

IBM Redbook SG24-5511: Database Performance Tuning on AIX http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/SG245511.html

SQL Server Database Performance Tuning Tips http://www.sql-server-performance.com/

Oracle Performance and Scalability http://www.oracle.com/appsnet/technology/performance/content.html

Tuning TCP/IP settings on LMS servers

For each operating system, different parameters can be changed to optimize overall network performance. The following sections provide TCP/IP tuning guidelines organized by operating system. These changes are recommended for the servers hosting the LMS application as well as the servers running the HTTP servers.

Additional TCP/IP tuning information for a variety of operating systems can be found at http://www.psc.edu/networking/perf_tune.html

Microsoft Windows 2000 servers

In Windows 2000, all important TCP/IP parameters must be set using the registry editor (regedit.exe). Start the editor and go to:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Modify the following parameters (described below). If a parameter does not exist, you have to create it manually. After changing the settings, you will need to reboot the machine.

Note: A detailed description of Microsoft Windows 2000 TCP/IP implementation can be found at: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itsolutions/network/deploy/depovg /tcpip2k.asp.

TcpTimedWaitDelay

This parameter defines the time in seconds that needs to elapse before Windows can release a closed connection and make it available for re-use. This interval between closure and release is known as the TIME_WAIT state or 2MSL (twice the maximum segment lifetime) state. During this time, reopening the connection to the client and server costs less than establishing a new connection. Reducing the value of this entry allows TCP to release closed connections faster, providing more resources for new connections.

Recommended value: 30 (decimal) = 0x0000001e (hexadecimal)

After applying this change, you should see fewer connections in TIME_WAIT. Display them with the netstat command.

MaxUserPort

This parameter determines the highest port number TCP can assign when an application requests an available user port from the system.

Recommended value: At least 32768 (decimal) = 0x00008000 (hexadecimal)

Appendix A: LMS Performance and Fine-tuning Information 107

Page 114
Image 114
IBM G210-1784-00 Tuning TCP/IP settings on LMS servers, Microsoft Windows 2000 servers, TcpTimedWaitDelay, MaxUserPort