Kernel parameters for db2 v8.2 on Solaris 10

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tony
    #1

    Kernel parameters for db2 v8.2 on Solaris 10

    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.
    Tags: None
    • Tony
      #2
      Re: Kernel parameters for db2 v8.2 on Solaris 10

      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!

        Comment

        • Darin McBride
          #3
          Re: Kernel parameters for db2 v8.2 on Solaris 10

          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.

            Comment

            • w.l.fischer@googlemail.com
              #4
              Re: Kernel parameters for db2 v8.2 on Solaris 10

              On Oct 8, 9:47 pm, Tony <tonyedr...@gma il.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.)

                Comment

                • Tomas
                  #5
                  Re: Kernel parameters for db2 v8.2 on Solaris 10

                  On Oct 9, 11:05 am, w.l.fisc...@goo glemail.com wrote:
                  On Oct 8, 9:47 pm, Tony <tonyedr...@gma il.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.)
                  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:1 00:DB2 Instance Owners project::db2iad m:project.max-msg-
                  ids=(priv,7168, deny);project.m ax-sem-ids=(priv,10240 ,deny);project. max-
                  shm-ids=(priv,8192, deny);project.m ax-shm-memory=(priv,
                  46066515148,den y)

                  hth,

                  /T

                    Comment

                    • roger.kavallin@gmail.com
                      #6
                      Re: Kernel parameters for db2 v8.2 on Solaris 10

                      On Oct 8, 9:47 pm, Tony <tonyedr...@gma il.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

                        Comment

                        Previous template Next
                        Working...