[HPADM] Sybase and shared memory

From: Kazakin, Leon (Leon.Kazakin_at_CIBC.ca)
Date: 12/18/03

  • Next message: COUNTERMAN, DANIEL (CONTRACTOR): "[HPADM] RE: [Samba] Netbios ?"
    To: "'hpux-admin@dutchworks.nl'" <hpux-admin@dutchworks.nl>
    Date: Thu, 18 Dec 2003 13:56:54 -0500
    
    

    Hi all,

    I was approached by a DBA and requested to increase shmmax from 1,53GB to
    3 GB on 4GB RAM N class
    and
    5 GB on 6GB RAM N class.

    Those systems run 64-bit Sybase and that's pretty much it for the workload.
    It's HP-UX 11.

    I have some Oracle tuning experience, but none with Sybase.

    Any thoughts?

    Regards,
    Leon

    --
                 ---> Please post QUESTIONS and SUMMARIES only!! <---
            To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
           Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
     
     Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
                http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
    

  • Next message: COUNTERMAN, DANIEL (CONTRACTOR): "[HPADM] RE: [Samba] Netbios ?"

    Relevant Pages

    • [HPADM] unsubscribe
      ... I was approached by a DBA and requested to increase shmmax from 1,53GB to ... GB on 6GB RAM N class. ... Those systems run 64-bit Sybase and that's pretty much it for the workload. ... To subscribe/unsubscribe to this list, ...
      (HP-UX-Admin)
    • How much RAM?
      ... How much RAM we need to assign (for Sybase) to install Sybase ... to our new db server? ...
      (comp.databases.sybase)
    • [HPADM] SUMMARY: Sybase and shared memory
      ... If the DBA is really going to use all that shared memory, ... You can set shmmax to a large value and then ... Sybase and shared memory ...
      (HP-UX-Admin)
    • [HPADM] SHMMAX modification
      ... Last night we changed the value for SHMMAX in one of our N4000 servers. ... This server has 10GB of RAM. ... following error executing a telnet to the server: ...
      (HP-UX-Admin)