安裝DB2前，需要修改Solaris核心參數

安裝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檔案，重新開機計算機。