DB2 on HP-UX 11.31

[Chauhan Amit]

Hi Experts,

Has anybody worked on DB2 on HP-UX 11.31, I am getting following error while creating the instanace:

[/opt/IBM/db2/V9.1/instance] ./db2icrt -a SERVER -p 80005 -s ese -w 64 -u db2fins2 db2inst2

DBI1030E Kernel parameter msgmax must be set to 65535.

Explanation:
DB2 requires certain kernel parameters to be updated.

User Response:
o Update all necessary kernel parameters as documented in the "Quick Beginnings" manual.
o Reboot the system
o Try this command again

DBI1109E The kernel parameters must be updated before using this command.

Explanation:
Some of the kernel parameters are not configured properly.

We don't have Kernel parameter "msgmax" available in 11.31 , this has been obsolete.

Any Suggestions ??

Regards,
Amit

[Dennis Handly]

You should report the problem to IBM to get them to fix it.

Otherwise you can bluff DB2 by creating your own parm.

[Oviwan]

hey

yes this is obsolete:
http://docs.hp.com/en/B2355-60130/msgmax.5.html

you can try it with: msgmnb

regards

[Chauhan Amit]

Thanks for your replies. We have already tuned whatever kernel parameters applicable.
How to bluff db2 ??

Regards,
Amit

[Dennis Handly · Accepted solution]

>We have already tuned whatever kernel parameters applicable.

Have you contacted IBM?

>How to bluff db2??

Using "kctune -u", of course.

[Oviwan]

hey

I think this sould solve your issue:
IY89581: MODIFICATIONS NEEDED IN DB2 INSTALL SCRIPT TO MAKE THE DB2 PRODUCT INSTALLABLE ON UPCOMING HP-UX 11.31

http://www-01.ibm.com/support/docview.wss?uid=swg1IY89581

Regards

[Chauhan Amit]

Hi,

Thanks for the link , but it seems this is to resolve the installation related issue.
My installation went without any issue.

Regards,
Amit

[Chauhan Amit]

Hi Dennis,

Appreciate your help. Bluffing the DB2 via kctune did the trick. I am able to start the instance without any issues:
Here is the output:

Confidential computer software. Valid license from HP required for
possession, use or copying. Consistent with FAR 12.211 and 12.212,
Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government
under vendor's standard commercial license.

logout
DBI1070I Program db2icrt completed successfully.

Thanks,
Amit