Knowledgebase

Monitoring FairCom DB Process State

The state of the FairCom DB process can be monitored using system utilities and FairCom DB utilities. System utilities commonly available on Unix systems include the following:

• ps lists the current processes on the system. This utility can be used to confirm that the server process exists and is in a running state.
• truss traces system calls and signals for a command or process. This utility can be used to determine what operations the server is currently performing.
• pstack prints a hex and symbolic stack trace for each lwp in a process. This utility can be used to determine what each server thread is currently doing. Also see the proc man page for details on other process monitoring tools.
• gcore creates a core image of the specified process. This utility can be used to view a detailed snapshot of the server’s operation at a point in time.

The Windows Performance Monitor and Task Manager can be used to observe the state of the FairCom DB process and its current activity.

The ctstat utility can be used to monitor server activity. By observing FairCom DB statistics over time, the server’s activity can be measured. For example, transaction commits, communication read/write operations, and disk read and write operations can be examined to determine what the server is currently doing.

The ctadmn utility can be used to monitor client activity. Details can be listed for all client connections, including current request, elapsed request time, and elapsed transaction time.