Hi all,

Do you know how to change kernel parameters on Solaris 10 for DB2?

I just installed DB2 ESE v8.2 on a new Solaris 10 box. But during the
installation, it asks for changing the kernel parameter like this:

DBI1030E Kernel parameter MSGMNB must be set to 65535.

I know it can be changed on the /etc/system for Solaris 9, but no idea
how it can be done on Solaris 10.

Many thanks.

Actually there IS an etc/system file on Solaris 10. But the SA refused
my request because Solaris 10 provides the other way to change kernel
parameters, like project file, which can have less impact to the whole
server. The problem is DB2 have to use 3 users to work on it, doesn't
like Oracle, which only need one user ID. Anyone has experience on
this situation?

Any reply will be appreciated!

Tony wrote:

Hi all,
>
Do you know how to change kernel parameters on Solaris 10 for DB2?
>
I just installed DB2 ESE v8.2 on a new Solaris 10 box. But during the
installation, it asks for changing the kernel parameter like this:
>
DBI1030E Kernel parameter MSGMNB must be set to 65535.
>
I know it can be changed on the /etc/system for Solaris 9, but no idea
how it can be done on Solaris 10.

You may want to ensure you have the latest version of DB2 before creating
any instance (apply FP16 first). Solaris 10 wasn't out when 8.2 came out,
so things like this may have been broken by the new version of Solaris.
They should be addressed in later fixpaks.

Or, just go with DB2 9.5 - version 8 is near its end-of-service already anyway.

On Oct 8, 9:47*pm, Tony <tonyedr...@gmail.comwrote:

Actually there IS an etc/system file on Solaris 10. But the SA refused
my request because Solaris 10 provides the other way to change kernel
parameters, like project file, which can have less impact to the whole
server. The problem is DB2 have to use 3 users to work on it, doesn't
like Oracle, which only need one user ID. Anyone has experience on
this situation?
>
Any reply will be appreciated!

I don't remember the specifics now, but you have to use commands like
mkproj etc. and all the parameters are set per user, so I had to
repeat this for every user. But just googling for an "db2 solaris 10
kernel parameters" should yield answers. (Or even googling for oracle
solaris 10 kernel parameters, as they suffer the same limitation.)

On Oct 9, 11:05*am, w.l.fisc...@googlemail.com wrote:

On Oct 8, 9:47*pm, Tony <tonyedr...@gmail.comwrote:
>

>

>
I don't remember the specifics now, but you have to use commands like
mkproj etc. and all the parameters are set per user, so I had to
repeat this for every user. But just googling for an "db2 solaris 10
kernel parameters" should yield answers. (Or even googling for oracle
solaris 10 kernel parameters, as they suffer the same limitation.)

I'm not entirely familiar with the details, but at our site we have
all instance owner users in the same Unix group, and the DBAs are also
in this group (as a secondary group). /etc/project then has an entry
with the kernel parms assigned to this group. Something like this:

group.db2iadm:100:DB2 Instance Owners project::db2iadm:project.max-msg-
ids=(priv,7168,deny);project.max-sem-ids=(priv,10240,deny);project.max-
shm-ids=(priv,8192,deny);project.max-shm-memory=(priv,
46066515148,deny)

hth,

/T

On Oct 8, 9:47*pm, Tony <tonyedr...@gmail.comwrote:

Actually there IS an etc/system file on Solaris 10. But the SA refused
my request because Solaris 10 provides the other way to change kernel
parameters, like project file, which can have less impact to the whole
server. The problem is DB2 have to use 3 users to work on it, doesn't
like Oracle, which only need one user ID. Anyone has experience on
this situation?
>
Any reply will be appreciated!

Tony.. Had similar problem when I installed DB2 8.2 on Solaris , 3
instances etc but I choosed to put the changes to default ie all
instead of putting it to a specific user.

/roger