安装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 = 2560
set semsys:seminfo_semmni = 3072
set shmsys:shminfo_shmmax = 2862489600
set 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 = 65535
set msgsys:msginfo_msgmnb = 65535
set msgsys:msginfo_msgmni = 2560
set msgsys:msginfo_msgtql = 2560
set semsys:seminfo_semmni = 3072
set semsys:seminfo_semmns = 6452
set semsys:seminfo_semmnu = 3072
set semsys:seminfo_semume = 240
set shmsys:shminfo_shmmax = 3753905356 //修改为 2862489600
set shmsys:shminfo_shmmni = 3072
set shmsys:shminfo_shmseg = 240
只需修改一处,其它的参数不需要修改。
然后保存system文件,重启计算机。