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:

Enable SAP ASE to generate a shared memory dump:
```
sp_configure "dump on conditions", 1
```
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"
```
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
```
Disable shared memory dumps on SAP ASE:
```
sp_configure "dump on conditions", 0
```