Configuring Shared Memory Dump Conditions

Use sp_shmdumpconfig to define or modify the shared memory dump conditions and system-wide attributes of those conditions.

The syntax for sp_shmdumpconfig is:
sp_shmdumpconfig "action", type, value, max_dumps, dump_dir,
dump_file, option1, option2, option3, option4, option5
Note: sp_shmdumpconfig uses positional parameters. When setting a parameter that falls to the right of parameters you do not want to set, specify null values for the unset parameters.
sp_shmdumpconfig allows you to:
  • Create new dump conditions

  • Modify existing dump conditions

  • Drop existing dump conditions

  • Reset the dump count for a dump condition

  • Display the current shared memory dump configuration

  • Set and modify system wide attributes for a dump condition.

Set these parameters to use sp_shmdumpconfig:
  • dump on conditions – determines whether SAP ASE generates a dump of data in shared memory

  • maximum dump conditions – sets the maximum number of dump conditions that can be configured

    See System Administration Guide: Volume 1 > Setting Configuration Parameters.

See the Reference Manual: Procedures.

This example describes a typical shared memory dump:

  1. Enable SAP ASE to generate a shared memory dump:
    sp_configure "dump on conditions", 1
  2. Specify the dump condition using sp_shmdumpconfig. This example request a one-time memory dump on a signal 11:
    sp_shmdumpconfig "add", signal, 11, 1 ,"/sybase"
  3. You can turn off collection by deleting the dump condition after collecting the desired data. For example, to drop the condition for error 631 and disable shared memory dumps:
    sp_shmdumpconfig "drop", "error", 631
  4. Disable shared memory dumps on SAP ASE:
    sp_configure "dump on conditions", 0