Filter
Top Products
• 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