Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Logging and Monitoring

 
CHECKPOINT_MONITOR

Determines if each occurrence of an internal FairCom Server checkpoint will cause a time stamp message to be sent to the FairCom Server console screen and to the CTSTATUS.FCS file.

 
CTSTATUS_MASK (CTSTATUS_MASK, CTSTATUS_MASK)

Allows certain types of entries in CTSTATUS.FCS to be suppressed.

 
CTSTATUS_SIZE

Controls the size of the FairCom Server status file.

 
DISK_FULL_ACTION

Enables FairCom DB to monitor available disk space and to shut down the database engine when the disk space falls below the specified limit.

 
DISK_FULL_LIMIT

Activates a disk space threshold mechanism to detect when a disk volume is getting full (the specified number of bytes must remain available on a disk volume after a file has been extended).

 
DISK_FULL_VOLUME

Allows volume-specific disk full checks.

 
FUNCTION_MONITOR

Causes the client number, function number, function name, and file name are displayed in a scrolling fashion on the FairCom Server console screen.

 
HEAP_DEBUG_LEVEL

Enables additional tracking and checking of internal memory suballocations - Consult with FairCom support team as this option can significantly impact performance in certain use cases.

 
LOCK_MONITOR

Deprecated: Monitors the number of active record locks.

 
MEMORY_MONITOR

Sends a message to the console whenever allocated memory exceeds the next memory threshold.

 
MEMORY_TRACK

Sends debug output to the console every time the net memory allocation count changes by a multiple of the threshold value.

 
MONITOR_MASK

Suppress the message sent to the system console if a file without a matching name does match the unique file ID when a file open is attempted.

 
PERF_MONITOR

Allows entries to be placed on a queue for client side processing and monitoring of server events.

 
REQUEST_TIME_MONITOR

Specifies a request time in seconds for monitoring function that exceed the specified time.

 
SNAPSHOT_FILENAME

Captures user information pertaining the to file specified to SNAPSHOT.FCS in addition to the system snapshot.

 
SNAPSHOT_INTERVAL

Enables automatic snapshots at specified intervals.

 
SNAPSHOT_LOCKWAIT_USEC

Changes the default histogram intervals (box width) for the lock waiting time histograms.

SNAPSHOT_LOGFLUSHTIME_USEC

Controls the width of the fixed transaction log flush time histogram, and the initial width of the adaptive transaction log flush time histogram.

 
SNAPSHOT_TRANTIME_USEC

Changes the default histogram intervals (box width) for the transaction time histogram.

 
SNAPSHOT_USERID

Captures user information to SNAPSHOT.FCS in addition to the system snapshot.

 
SYSLOG (SYSLOG, SYSLOG)

Specifies a keyword indicating contents to be stored in the System Event Log.

 
SYSVIEW_WHAT

Enables system status reports triggered by the specified event.

 
SYSVIEW_WHEN

Enables system status reports triggered by the specified event.

 
Diagnostics

Diagnostics keywords are intended to be used to help collect data to be analyzed for troubleshooting. The use of these keywords should be avoided in normal operation as they may cause additional overhead (e.g., logging).

 
DEADLOCK_MONITOR

Causes a time stamp message goes to the FairCom Server console screen each time the FairCom Server detects and resolves a dead lock.

 
DIAGNOSTICS SNAPSHOT_AUTOMATIC

Write system snapshots to the human-readable SNAPSHOT.FCS text file.

 
DIAGNOSTICS SNAPSHOT_IOTIME

Enables collecting disk read and write timings on a per-file basis when high-resolution timer support is activated.

 
DIAGNOSTICS SNAPSHOT_SHUTDOWN

Write system snapshots to the human-readable SNAPSHOT.FCS text file.

 
DIAGNOSTICS SNAPSHOT_WORKTIME

Enables collecting FairCom DB function call counts and timings on a per-c-tree file basis.

In This Section

CHECKPOINT_MONITOR

CTSTATUS_MASK

CTSTATUS_SIZE

DBENGINE_CHECK

DEADLOCK_MONITOR

DISK_FULL_ACTION (Original)

DISK_FULL_ACTION (SUBSYSTEM)

DISK_FULL_LIMIT

DISK_FULL_VOLUME

FUNCTION_MONITOR

HEAP_DEBUG_LEVEL

LOCK_MONITOR

MEMORY_MONITOR

MEMORY_TRACK

MONITOR_MASK

MONITOR_MASK

PERF_MONITOR

REQUEST_TIME_MONITOR

SNAPSHOT_FILENAME

SNAPSHOT_INTERVAL

SNAPSHOT_LOCKWAIT_USEC

SNAPSHOT_LOGFLUSHTIME_USEC

SNAPSHOT_TRANTIME_USEC

SNAPSHOT_USERID

SYSLOG

SYSVIEW_WHAT

SYSVIEW_WHEN

DIAGNOSTICS SNAPSHOT_AUTOMATIC

DIAGNOSTICS SNAPSHOT_IOTIME

DIAGNOSTICS SNAPSHOT_SHUTDOWN

DIAGNOSTICS SNAPSHOT_WORKTIME

TOCIndex