To achieve optimal performance using Veritas Storage Foundation for DB2, certain Solaris parameters need to be tuned. Changing these parameters requires modifying the Solaris kernel settings (specified in the /etc/system file) and rebooting the system.

You can add or change these tuning parameters in the /etc/system file using a text editor. The following example shows the contents of an /etc/system file:

* start DB2 *
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgseg=16384
set msgsys:msginfo_msgssz=16
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=256
set msgsys:msginfo_msgtql=512
*
set shmsys:shminfo_shmmax=134217728
set shmsys:shminfo_shmseg=16
set shmsys:shminfo_shmmni=300
*
set semsys:seminfo_semmni=256
set semsys:seminfo_semmap=258
set semsys:seminfo_semmns=512
set semsys:seminfo_semmnu=512
* end DB2 *