cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 on HP-UX 11.31

SOLVED
Go to solution
Chauhan Amit
Respected Contributor

DB2 on HP-UX 11.31

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
If you are not a part of solution , then you are a part of problem
7 REPLIES
Dennis Handly
Acclaimed Contributor

Re: DB2 on HP-UX 11.31

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

Otherwise you can bluff DB2 by creating your own parm.
Oviwan
Honored Contributor

Re: DB2 on HP-UX 11.31

hey

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

you can try it with: msgmnb

regards
Chauhan Amit
Respected Contributor

Re: DB2 on HP-UX 11.31

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

Regards,
Amit
If you are not a part of solution , then you are a part of problem
Dennis Handly
Acclaimed Contributor
Solution

Re: DB2 on HP-UX 11.31

>We have already tuned whatever kernel parameters applicable.

Have you contacted IBM?

>How to bluff db2??

Using "kctune -u", of course.
Oviwan
Honored Contributor

Re: DB2 on HP-UX 11.31

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
Respected Contributor

Re: DB2 on HP-UX 11.31

Hi,

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

Regards,
Amit
If you are not a part of solution , then you are a part of problem
Chauhan Amit
Respected Contributor

Re: DB2 on HP-UX 11.31

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
If you are not a part of solution , then you are a part of problem