when i try to login to one of my database i get the shared memeory error and check all the kernel configurations it looks fine but i get this often...


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

here is the kernel parameter

[root@WESSSTDW01 ~]# 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
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 536870912
kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024
[root@WESSSTDW01 ~]#


thanks!

because memory is not available.. there are many reasons for this error
is this a 32bit system
there are some technotes in dev.works about this
memory size ? free memory ?
more detail are needed to debug this

thanks for your reply..

i will provide the req. info as much as i can...

it is correct what iam using is a 32bit box..

i was getting this error often...

Memory for database: REPORTER

utilh pckcacheh other catcacheh bph (3) bph (2)
64.0K 1.4M 128.0K 832.0K 31.7M 16.0M

bph (1) bph (S32K) bph (S16K) bph (S8K) bph (S4K) shsorth
157.1M 832.0K 576.0K 448.0K 384.0K 192.0K

lockh dbh apph (83) apph (77) apph (75) apph (72)
26.2M 37.4M 64.0K 64.0K 64.0K 64.0K

apph (27) apph (26) apph (25) apph (24) apph (23) apph (22)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (21) apph (20) apph (19) apph (18) apph (17) apph (16)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (15) apph (14) apph (13) apph (12) apph (11) apph (10)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (9) apph (8) apph (7) appshrh
64.0K 64.0K 64.0K 768.0K

Memory for database: WAREHOUS

utilh pckcacheh other catcacheh bph (S32K) bph (S16K)
64.0K 3.3M 128.0K 1.1M 832.0K 576.0K

bph (S8K) bph (S4K) shsorth lockh dbh apph (146)
448.0K 384.0K 384.0K 26.2M 37.7M 64.0K

apph (84) apph (80) apph (69) apph (68) apph (67) apph (66)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (65) apph (64) apph (63) apph (62) apph (61) apph (60)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (59) apph (58) apph (57) apph (56) apph (55) apph (54)
64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

apph (53) apph (52) apph (51) appshrh
64.0K 64.0K 64.0K 704.0K

free memory

[db2inst1@WESSPTDW01 ~]$ free
total used free shared buffers cached
Mem: 33132692 3044468 30088224 0 350900 1998476
-/+ buffers/cache: 695092 32437600
Swap: 30716240 0 30716240
[db2inst1@WESSPTDW01 ~]$


can some help me as i get this error often,

if i need to increase the kernel paramter .. kindly let me know

A workaround for this is the use of the registry DB2_OVERRIDE_BPF. At database start this automaticly sets all you bufferpools to the value (in pages) specified by this parameter.