安装DB2前,需要修改Solaris内核参数

    技术2022-05-11  84

    安装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文件,重启计算机


    最新回复(0)