Solaris

hi guys,

Prior to the installation of IBM DB2 database on Solaris 10, i need to set the following parameters:

kernel.shmmax (SHMMAX) 1 073 741 824 (64-bit kernel)
kernel.sem (SEMMNI) 1 024
kernel.msgmni (MSGMNI) 1 024
kernel.msgmax (MSGMAX) 65 536
kernel.msgmnb 65 536

I understand that putting these entries in /etc/system is no longer recommended, we need to use project settings instead. But i'm unable to find the project equivalent attribute for MSGMAX above. For e.g, for the MSGMNI, the attribute is project.max-msg-ids.

Please advise how i can set the project settings for the above parameters.

I'm thinking of proceeding as follows:
projadd -p 101 -c "IBM DB2" \
-U bodadm,dbdadm \
-K "project.max-shm-memory=(priv,1073741824,deny)" \
-K "project.max-sem-ids=(priv,1024,deny)" \
-K "project.max-msg-ids=(priv,1024,deny)" \
-K "project.<no idea>=(priv,65536,deny)" \
-K "process.max-msg-qbytes=(priv,65536,deny)" \
DB2

also i add the 2 users bodadm,dbdadm in /etc/user_attr

Please help.

regards.

If I am reading your post correctly: kernel.msgmax (MSGMAX) 65 536

The following tunables are now obsolete in the Solaris 10 Operating System: msginfo_msgmax

From: Oracle document 1006158.1

thanks for yr reply

indeed the parameter is obsolete and also this parameter used to be added to the /etc/system file. See link:
System V IPC Configuration (Solaris Tunable Parameters Reference Manual)

I was asking for its equivalent to be used in projects. The above link gives
process.max-msg-messages (old - msgsys:msginfo_msgtql) but i dont know whether it is meant for kernel.msgmax (MSGMAX).


By the way how can i access the oracle document 1006158.1?


regards.