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

    Question Unanswered: Shared memory error in Linux 64 bit

    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

  2. #2
    Join Date
    Apr 2011
    Posts
    19
    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.
    Code:
     Size of database shared memory (4KB)  (DATABASE_MEMORY) = COMPUTED

Posting Permissions

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