topic Re: DB2 on HP-UX 11.31 in Operating System - HP-UX

DB2 on HP-UX 11.31

Chauhan Amit — Mon, 15 Sep 2008 07:29:09 GMT

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

Re: DB2 on HP-UX 11.31

Dennis Handly — Mon, 15 Sep 2008 07:53:06 GMT

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

Otherwise you can bluff DB2 by creating your own parm.

Re: DB2 on HP-UX 11.31

Oviwan — Mon, 15 Sep 2008 08:02:01 GMT

hey

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

you can try it with: msgmnb

regards

Re: DB2 on HP-UX 11.31

Chauhan Amit — Mon, 15 Sep 2008 08:06:17 GMT

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

Regards,
Amit

Re: DB2 on HP-UX 11.31

Dennis Handly — Mon, 15 Sep 2008 08:17:46 GMT

>We have already tuned whatever kernel parameters applicable.

Have you contacted IBM?

>How to bluff db2??

Using "kctune -u", of course.

Re: DB2 on HP-UX 11.31

Oviwan — Mon, 15 Sep 2008 08:34:41 GMT

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

Re: DB2 on HP-UX 11.31

Chauhan Amit — Mon, 15 Sep 2008 08:55:33 GMT

Hi,

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

Regards,
Amit

Re: DB2 on HP-UX 11.31

Chauhan Amit — Mon, 15 Sep 2008 09:36:39 GMT

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