DB2 load with error SQL2044N Reason Code "3"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lltong - 27 Feb 2007 04:46 GMT

I have db2 ESE v9 fix pak 2 installed on red hat linux kernel 2.6.
When I use db2 load facility even with 1 row to be inserted, I see
this error message:
SQL2044N An error occurred while accessing a message queue. Reason
code: "3".

I read some post online about SQL2044 and learned sometimes it is
about the linux kernel parameter not being set up correctly. But it is
not my case here. I've got the big enough msgmni:
# For DB2
kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024
kernel.shmall = 16737418240
kernel.shmmax = 33474836480

I am not sure what went wrong...Please help!

Thanks,

Lisa

Reply to this Message

Phil Sherman - 27 Feb 2007 17:39 GMT

use "cat" to examine the appropriate files in the /proc/sys/kernel
directory and verify that all of the parameters for db2 have actually
taken effect. If they haven't and you have SELinux activated, then
SELinux may be preventing the db2 startup procedure from setting the
appropriate values.

I patched this by placing the appropriate commands in /etc/rc.local:
    sysctl -w kernel.shmmax=268435456
    echo 250 128000 32 1024 >/proc/sys/kernel/sem
    echo 1024 >/proc/sys/kernel/msgmni
Note that these values are for a 32bit 8.1 instance.

Phil Sherman

> I have db2 ESE v9 fix pak 2 installed on red hat linux kernel 2.6.
> When I use db2 load facility even with 1 row to be inserted, I see
[quoted text clipped - 16 lines]
>
> Lisa

Reply to this Message

lltong - 27 Feb 2007 23:44 GMT

Hi Phil,

Thanks for your response.

I double checked the system parameter. I am sure they are taken
effect:
cat /proc/sys/kernel/msgmni
1024
cat /proc/sys/kernel/shmmax
33474836480

Any other suggestions?

Thanks!

Lisa

> use "cat" to examine the appropriate files in the /proc/sys/kernel
> directory and verify that all of the parameters for db2 have actually
[quoted text clipped - 30 lines]
>
> > Lisa

Reply to this Message