Each dump condition can inherit attributes from the system-wide default settings. Specifying an attribute value for a condition overrides the system-wide defaults. To update the system-wide default settings, use the sp_shmdumpconfig stored procedure with a type value of defaults.
It is typically more convenient to specify any attribute values in the system-wide default settings, and to allow all dump conditions to inherit these values.
SAP recommends that all dump conditions have an explicit dump directory (the dump_dir parameter). To ensure this, specify a dump directory in the system-wide defaults and allow all dump conditions to inherit this value.
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: 101 MB Current number of conditions: 0 Maximum number of conditions: 10 Configurable Shared Memory Dump Configuration Settings ------------------------------------------------------ Dump on conditions: 0 You must run 'sp_configure 'dump on conditions',1' to enable the shared memory dump facility. 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 86 MB 109 MB