Hi I had created the database in my 64 bit server. i have only one database in it.

when connecting to it , i got the shared memory error

[db2inst1@lnx6 ~]$
[db2inst1@lnx6 ~]$ db2 connect to warehous
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
[db2inst1@lnx6 ~]$


I have RHEL 6 64 bit, DB2 9.7 64 bit,

And the sysctl configurations are....

[root@lnx6 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024
kernel.msgmni = 16384
[root@lnx6 ~]#



Can some suggest me the exact value to avoid the memory issue

On some of our systems we had to switch to computed to avoid these type errors. If I remember it is a known issue on some Sun boxes.