Changes Captured

Startup Configuration Changes

If you modify the SAP ASE configuration file while the SAP ASE is shut down, SAP ASE records any changes to the configuration in the ch_events table it starts (recording a value of NULL for the mode and username values for these changes).

Reading the Configuration File

ch_events records the event when you read, write, verify, and restore the configuration file, but does not record the configuration value changes. For example, if you change the value for number of user connections and then issue:

sp_configure “configuration file”, 0, “read”, “srv.config”

ch_events records that you read the configuration file, but does not record the configuration value changes.

sp_configure Changes

SAP ASE records all changes made by sp_configure, including:

Name of the configuration parameter
Old configuration value
New configuration value
Whether the parameter is dynamic or static
Timestamp of the date and time the change was made
Login of the user making the change

Configuration changes caused by reading from the configuration file are not recorded. That is, SAP ASE records the reading, writing, verifying, and restoring operations, but does not record the configuration changes caused by a reading operation. You can also change configuration values by reading a different or manually modified configuration file. Although SAP ASE records that it read the file, it does not record the individual parameter changes.

Changes to Server Options

ch_events records all changes made by sp_serveroption, including:

Name of affected server
Name of option that was changed
Old option value
New option value
Timestamp of the date and time the change was made
Login of the user making the change

Changes to Database Options

ch_events records these changes made by sp_dboption:

Name of affected database
Name of option that was changed
Old option value
New option value
Timestamp of the date and time the change was made
Login of the user making the change

Changes to Cache Configuration

ch_events records all changes made by sp_cacheconfig and sp_poolconfig to cache configurations.

Recorded changes from sp_cacheconfig include:

Name of affected cache
Old cache size
New cache size
Attribute (cache type, cache replacement policy, partition number), if applicable
Timestamp of the date and time the change was made
Login of the user making the change
(Cluster Edition only) Instance to which this change applies

Recorded changes from sp_poolconfig include:

Name of affected cache
Configuration pool
Old cache pool size
New cache pool size
Name of changed attribute (affected pool, wash size, asynchronous prefetch (APF) percentage)
Timestamp of the date and time the change was made
Login of the user making the change
(Cluster Edition only) Instance to which this change applies

Changes to Trace flags and Switches

ch_events records changes to dbcc traceon | off and set switch on | off.

Recorded changes from dbcc traceon | off include:

Trace flag affected
Session ID
Old trace flag state (on or off)
New trace flag state (on or off)
Timestamp of the date and time the change was made
Login of the user making the change
(Cluster Edition only) Instance to which this change applies

Recorded changes from set switch on | off include:

Switch number affected
Old switch state (on or off)
New switch state (on or off)
Name of changed attribute (server-wide or session-specific, with override, with no_info)
Timestamp of the date and time the change was made
Login of the user making the change

Changes to Number of Engines

The changes tracked by create thread pool, alter thread pool, and drop thread pool include:

Name of pool name affected
Old pool size
New pool size
Name of changed attribute (new pool name, idle timeout, and so on)
Timestamp of the date and time the change was made
Login of the user making the change
(Cluster Edition only) Instance to which this change applies

SAP ASE Startup and Shutdown Events

ch_events records this information for startup, shutdown, shutdown with nowait, and abrupt (unscheduled) shutdown events for SAP ASE and instances from the Cluster Edition:

Name of the action (startup, shutdown, shutdown with nowait, abrupt shutdown).
Time spent waiting for a shutdown. Not applicable for shutdown with no_wait.
Name of the host on which the server starts.
Timestamp of the date and time the change was made.
Login of the user making the change.
(Cluster Edition only) Instance to which this change applies.

Note: Because ch_events records the shutdown when you issue the shutdown command, ch_events may record multiple shutdowns during a polite shutdown if you issue the command more than once.

Enabling or Disabling Auditing

ch_events records this information about tracking, global auditing, and configuration history auditing:

Name of the action (enable or disable)
Timestamp of the date and time the change was made
Login of the user making the change