Kernel Parameters Tuning for DB2 in HPUX 11.23i (281 Views)
Reply
Super Advisor
apple
Posts: 560
Registered: ‎10-18-2007
Message 1 of 5 (281 Views)
Accepted Solution

Kernel Parameters Tuning for DB2 in HPUX 11.23i

Dear HP-UX Gurus,
I would like to tune these km values for nflocks, msgmnb, msgmax,shmmax,shmmni in HP-UX 11.23i itanium 64bits.
do i need to reboot the server after change it? which is the safest way to change kernel values? hope to hear from you. many thanks in advance
Please use plain text.
Honored Contributor
VK2COT
Posts: 921
Registered: ‎01-17-2006
Message 2 of 5 (281 Views)

Re: Kernel Parameters Tuning for DB2 in HPUX 11.23i

Hello,

It all depends on whether the tunable
parameter is dynamic or not. In other words,
you need to check if a change can happen without a reboot.

Let's pick up one of your tunables:

# kctune -v shmmax

The system shows:

Tunable shmmax
Description Maximum size of a shared memory segment (bytes)
Module sysv_shm
Current Value 1073741824 [Default]
Value at Next Boot 1073741824 [Default]
Value at Last Boot 1073741824
Default Value 1073741824
Constraints shmmax >=3D 2048
shmmax <=3D 4398046511104
Can Change Immediately or at Next Boot

Look for "Can Change" row. Therefore,
shmmax can be changed without the reboot.

To change, you can use SAM or SMH interface,
or command-line (I prefer it):

# kctune shmmax=...

As an exercise, it is left for you
to chech the other tunables.

Regards,

VK2COT
VK2COT - Dusan Baljevic
Please use plain text.
Super Advisor
apple
Posts: 560
Registered: ‎10-18-2007
Message 3 of 5 (281 Views)

Re: Kernel Parameters Tuning for DB2 in HPUX 11.23i

oh thank you.
how about this? Automatic Tuning Enabled, does it require reboot?
lily:/>kctune -v nflocks
Tunable nflocks
Description Maximum number of file locks
Module fs
Current Value 4096 [Default]
Value at Next Boot Default (automatic)
Value at Last Boot 4096
Default Value 4096 (automatic)
Constraints nflocks >= 50
nflocks <= 16777216
Can Change Automatic Tuning Enabled
Please use plain text.
Acclaimed Contributor
Dennis Handly
Posts: 24,762
Registered: ‎03-06-2006
Message 4 of 5 (281 Views)

Re: Kernel Parameters Tuning for DB2 in HPUX 11.23i

>how about this? Automatic Tuning Enabled, does it require reboot?
# kctune -v nflocks

Just look at the man page:
http://docs.hp.com/en/B2355-60103/nflocks.5.html
This tunable is dynamic
Please use plain text.
Honored Contributor
VK2COT
Posts: 921
Registered: ‎01-17-2006
Message 5 of 5 (281 Views)

Re: Kernel Parameters Tuning for DB2 in HPUX 11.23i

Hello,

nflocks tunable is dynamic (tuning will take
effect immediately on the running system).

When the value of nflocks is dynamically tuned
it cannot be set to a value lower than the
current number of file locks in the running
kernel.

Cheers,

VK2COT
VK2COT - Dusan Baljevic
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation