Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Unanswered: can't allocate memory to Sybase on DEC unix

    I need some help. I have a DEC unix box running SYBASE 11.5....I run a vmstat -P and it shows I have 3GB of memory available. My current configuration on SYBASE is only using 768 MB. Here is the output from my vmstat -P:

    Total Physical Memory = 3072.00 M

    I edited the shm-max entry in my /etc/sysconfig file to 2147483648 which I thought was 2 GB. I then changed my .cfg file to reflect 1048576 pages or 2GB. When I reboot the DEC box, it does not grab that memory and my SYBASE server can't allocate the amount of memory I was asking it to. I was wondering if my vmstat lies to me or if there is some other throttle somewhere that I am not thinking about. THanks.
    Dogboy

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Seems to me that the max memory is 1.7 Gb for this type of configuration.

  3. #3
    Join Date
    Sep 2003
    Location
    GENEVA
    Posts
    4

    Exclamation Memory limited to 1.75GB

    Hi,

    As on HP-UX (without memory windows), total memory allocated to Sybase has to be less than 1.75GB.

    Try to configure tour total memory to 1.7GB


    Hope this will help

  4. #4
    Join Date
    Feb 2004
    Posts
    28

    Re: can't allocate memory to Sybase on DEC unix

    Actually you can assign more than 1.7GB memory on dec, provided that your shared memory parameters are configured correctly in DEC OS.

    DEC OS can use multiple shared memory segments; each shared segment can be of max 2GB.

    Here is a sample configuration from a DEC box with 4GB physical RAM.

    ipc:
    shm-max = 2147483647
    shm-seg = 64
    ssm-threshold = 0

    rt:
    aio-max-num = 1024

    proc:
    maxusers = 128
    max-proc-per-user = 640
    max-threads-per-user = 32768
    per-proc-stack-size = 25165824
    per-proc-data-size = 4831838208
    max-per-proc-data-size = 4831838208
    per-proc-address-space = 4831838208
    max-per-proc-address-space = 4831838208

    vm:
    vm-maxvas = 4831838208
    vm-maxwire = 4294967296
    vm-vpagemax = 1048576
    new-wire-method = 0



    I hope it helps.

    j

    Originally posted by dogboy11
    I need some help. I have a DEC unix box running SYBASE 11.5....I run a vmstat -P and it shows I have 3GB of memory available. My current configuration on SYBASE is only using 768 MB. Here is the output from my vmstat -P:

    Total Physical Memory = 3072.00 M

    I edited the shm-max entry in my /etc/sysconfig file to 2147483648 which I thought was 2 GB. I then changed my .cfg file to reflect 1048576 pages or 2GB. When I reboot the DEC box, it does not grab that memory and my SYBASE server can't allocate the amount of memory I was asking it to. I was wondering if my vmstat lies to me or if there is some other throttle somewhere that I am not thinking about. THanks.

  5. #5
    Join Date
    Feb 2004
    Posts
    26

    Re: can't allocate memory to Sybase on DEC unix

    Actually I got it fixed. It was two configurations in the sysconfigtab table that didn't exist in our current sysconfigtab. The per-proc-address-space and vm-maxvas. Once I added those then everything was good. Thanks for your help.
    Dogboy

Posting Permissions

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