Adjusting the Operating System Shared Memory Parameters

Adjust shared memory segments if Adaptive Server cannot obtain large memory as a single segment or if Backup Server stripes fail due to insufficient segments.

Depending on the number and types of devices used for backup (dump) and recovery (load), you may need to adjust the shared memory segment parameter in the operating system configuration file to accommodate concurrent Backup Server processes. There are six default shared memory segments available for process attachments.

If any reconfiguration through sp_configure requires additional memory, Adaptive Server allocates shared memory segments after start-up. To account for these additional segments, allocate the maximum memory available to Adaptive Server by using the allocate max shared memory configuration parameter. See the System Administration Guide.

  1. Adaptive Server 15.5 requires an additional 32MB of shared memory than earlier versions of Adaptive Server. Increase the value of the configuration parameter 'max memory' to accommodate the additional memory requirement. To query the amount of shared memory:
    # kctune shmmax
    To increase the amount of shared memory. For example:
    # kctune shmmax+=33554432

    The default total logical memory parameter for HP is 45,056 2K pages (88MB) on the 64-bit operating system.

  2. To adjust the shared memory value of the operating system, use the System Administration Manager (SAM). After you install Adaptive Server, change any configuration parameter, procedure cache, or data cache size. This may require that you increase the value of the max memory configuration parameter.