This section discusses the available options for monitoring FairCom DB’s transaction activity.
The CHECKPOINT_MONITOR server configuration keyword can be used to cause the server to log the starting and completion times of checkpoint operations to the server status log and the server console. This option can be used to determine how often checkpoints occur. If checkpoints occur very frequently, the server’s performance can be affected. In such a situation, the CHECKPOINT_INTERVAL and LOG_SPACE keywords can be used to reduce the frequency of checkpoint operations.
The SnapShot() function can be used to retrieve transaction activity details. See the discussion of the SNAPSHOT.FCS file format for details.