Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

msgmax and msgmnb dynamic kernel parms

JJ_4
Frequent Advisor

msgmax and msgmnb dynamic kernel parms

HP-UX 11i and db2 7.1

Just an FYI really for DB2 users.

It is a requirement that DB2 needs msgmax and msgmnb both need setting to 65535.

If you do this dynamically through SAM, then all is fine until reboot.

After reboot kmtune shows the following:
Parameter Current Dyn Planned
msgmax 8192 Y 65535
msgmnb 65535 Y 65535

as you can see msgmnb keeps the value, but msgmax resets back to 8192.

Trying to then use DB2 gives errors like:

db2 connect to sample
DB21016E The Command Line Processor encountered a system error while sending the command to the backend process.

kmtune -u -s msgmax=65535

can then be run to update the running kernel
Not enough Zappa makes you sad.
7 REPLIES
harry d brown jr
Honored Contributor

Re: msgmax and msgmnb dynamic kernel parms

JJ,

The formula is this:

min (msgmnb, msgseg * msgssz, 65535)

Which returns the smallest of the values. So what do you have msgseq and msgssz set to? If they are multiplied together what do you get?

msgmax <= msgmnb
msgmax <= ( msgssz * msgseg)


live free or die
harry
Live Free or Die
JJ_4
Frequent Advisor

Re: msgmax and msgmnb dynamic kernel parms

kmtune | grep msg
msgmap 514 - (2+MSGTQL)
msgmax 65535 Y 65535
msgmnb 65535 Y 65535
msgmni 256 - 256
msgseg 16384 - 16384
msgssz 16 - 16
msgtql 512 - 512
Not enough Zappa makes you sad.
harry d brown jr
Honored Contributor

Re: msgmax and msgmnb dynamic kernel parms

JJ,

Do you have the Dec 2001 patch bundle installed? I'm testing the change to msgmax right now, I'll let you know what happens. It's dynamic, so a reboot isn't necessary, but I'm just testing it for the fun of it :-)


live free or die
harry
Live Free or Die
harry d brown jr
Honored Contributor

Re: msgmax and msgmnb dynamic kernel parms

JJ,

I modified msgmax to 65535 without any issue, and I even rebooted to make sure it stayed put, which it did. I suggest using HP's custom patch manager, to make sure you have the latest and greatest patches.

live free or die
harry
Live Free or Die
JJ_4
Frequent Advisor

Re: msgmax and msgmnb dynamic kernel parms

This is all I have (albeit totally unreadable)

#
# Bundle(s):
#

B3899BA B.11.11.02 HP C/ANSI C Developer's Bundle for HP-UX 11.00 (S700)
B6835AA B.11.11.03 Netscape 6.01
B6848AA 1.1.2 GTK+ Support Libraries for HP-UX 11i
B8110AA 1.2.2.08.00 Java 2 SDK for HP-UX (700/800), PA1.1 + PA2.0 Add On
B8342AA B.11.11.09 Netscape Communicator 4.79
B9788AA 1.3.1.02.00 Java 2 SDK 1.3 for HP-UX (700/800), PA1.1 + PA2.0 Add On
BUNDLE11i B.11.11.0102.2 Required Patch Bundle for HP-UX 11i, February 2001
CDE-English B.11.11 English CDE Environment
CDE-French B.11.11 French CDE Environment
CDE-German B.11.11 German CDE Environment
CDE-Italian B.11.11 Italian CDE Environment
CDE-Spanish B.11.11 Spanish CDE Environment
CDE-Swedish B.11.11 Swedish CDE Environment
FDDI-00 B.11.11.01 PCI FDDI;Supptd HW=A3739A/A3739B;SW=J3626AA
FibrChanl-00 B.11.11.03 PCI FibreChannel;Supptd HW=A5158A
GOLDAPPS11i B.11.11.0112.6 Gold Applications Patches for HP-UX 11i, December 2001
GOLDBASE11i B.11.11.0112.6 Gold Base Patches for HP-UX 11i, December 2001
GigEther-00 B.11.11.14 PCI/HSC GigEther;Supptd HW=A4926A/A4929A/A4924A/A4925A;SW=J1642AA
HPUX11i-TCOE B.11.11 HP-UX Technical Computing OE Component
HPUXBase64 B.11.11 HP-UX 64-bit Base OS
HPUXBaseAux B.11.11 HP-UX Base OS Auxiliary
HWEnable11i B.11.11.0112.5 Hardware Enablement Patches for HP-UX 11i, December 2001
OnlineDiag B.11.11.00.04 HPUX 11.11 Support Tools Bundle
PROCSETS A.01.00.00.06 HP-UX Processor Sets Bundle
RAID-00 B.11.11.00 PCI RAID; Supptd HW=A5856A
#
# Product(s) not contained in a Bundle:
#

DB2V7CAE 7.1.0.40 Administration Client for HP-UX
DB2V7CONN 7.1.0.40 Connect Enterprise Edition for HP-UX
DB2V7HTML 7.1.0.40 Product Library (HTML)
DB2V7SDK 7.1.0.40 Application Development Tools for HP-UX
DB2V7WGRP 7.1.0.40 UDB Workgroup Edition for HP-UX
DB2V7XENT 7.1.0.40 UDB Enterprise - Extended Edition for HP-UX
IMNSearch 1.2.3.1 NetQuestion Online Documentation Search
PHKL_23240 1.0 VxFS fancy read ahead performance improvemnt
tusc 6.9 tusc
Not enough Zappa makes you sad.
harry d brown jr
Honored Contributor

Re: msgmax and msgmnb dynamic kernel parms

JJ, well you do have the Dec 2001 patches installed. When you change it via sam, does the pending and current change to 65535?

live free or die
harry
Live Free or Die
JJ_4
Frequent Advisor

Re: msgmax and msgmnb dynamic kernel parms

Oh yes.
Not enough Zappa makes you sad.