Configuring shared memory dumps

Use sp_shmdumpconfig to configure the shared memory dumps. The syntax is:

sp_shmdumpconfig "action", type, value, max_dumps, dump_dir,
dump_file, option1, option2, option3, option4, option5

The action parameter determines how Adaptive Server processes the dump. See the Reference Manual: Commands.

NoteShared memory dump files are created to assist Sybase Customer Support in analyzing problems in Adaptive Server. Use sp_shmdumpconfig only under the direction of Sybase Customer Support.

This example issues sp_shmdumpconfig with no parameters to display the current configuration for shared memory dumps:

sp_shmdumpconfig
Configured Shared Memory Dump Conditions
----------------------------------------

   Defaults   ---
     Maximum Dumps:          1
     Halt Engines:           Halt
     Cluster:                Local
     Page Cache:             Omit
     Procedure Cache:        Include
     Unused Space:           Omit
     Dump Directory:         $SYBASE
     Dump File Name:         Generated File Name
     Estimated File Size:    100 MB

Current number of conditions: 0
Maximum number of conditions: 10

Configurable Shared Memory Dump Configuration Settings
------------------------------------------------------
Dump on conditions: 1
Number of dump threads: 1
Include errorlog in dump file: 1
Merge parallel files after dump: 1

Server Memory Allocation
Procedure Cache  Data Caches  Server  Memory  Total Memory
---------------  -----------  -------------  ------------
          16 MB         9 MB           85 MB        108 MB

This example configures Adaptive Server to perform a shared memory dump whenever it encounters a signal 11 (that is, a segmentation fault):

sp_shmdumpconfig "add", signal, 11,1,"dump_dir"