安装DB2前,需要修改Solaris内核参数。
DB2 提供了一个叫做 db2osconf 的工具。该工具根据系统的大小对内核参数的值给出建议。
db2osconf 的参数
Usage:-c # Client only-f # Compare to current-h # Help screen-l # List current-m <mem in GB> # Specify memory in GB-n <num CPUs> # Specify number of CPUs-p <perf level> # Msg Q performance level (0-3)-s <scale factor> # Scale factor (1-3)-t <threads> # Number of threads
查看系统对内核参数的建议值
cd /opt/IBM/db2/V8.1/bin/
./db2osconf
内核参数
set msgsys:msginfo_msgmni = 2560set semsys:seminfo_semmni = 3072set shmsys:shminfo_shmmax = 2862489600set shmsys:shminfo_shmmni = 3072
Total kernel space for IPC:0.42MB (shm) + 1.12MB (sem) + 1.45MB (msg) == 3.00MB (total)
编辑内核参数
vi /etc/system
* Recommended kernel parameters for "DB2 for Solaris"* for systems with more than 512MB of physical memory*set msgsys:msginfo_msgmax = 65535set msgsys:msginfo_msgmnb = 65535set msgsys:msginfo_msgmni = 2560set msgsys:msginfo_msgtql = 2560
set semsys:seminfo_semmni = 3072set semsys:seminfo_semmns = 6452set semsys:seminfo_semmnu = 3072set semsys:seminfo_semume = 240
set shmsys:shminfo_shmmax = 3753905356 //修改为 2862489600 set shmsys:shminfo_shmmni = 3072set shmsys:shminfo_shmseg = 240
只需修改一处,其它的参数不需要修改。
然后保存system文件,重启计算机。