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.
Shared 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"