Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Red face Unanswered: Shared memory issue

    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!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    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...

  4. #4
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    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

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •