IBM G210-1784-00 Manuale Utente

•  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 

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 

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: 

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. 

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)