Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Diagnostics

Diagnostic keywords are used to provide additional detailed FairCom DB monitoring of specific internal parameters and metrics. Typically, these keywords should only be used under the specific advice of a FairCom engineer as they may negatively impact the performance of your FairCom DB Server. Please do not hesitate to contact your nearest FairCom office should you have any questions regarding use of any of these keywords.

WARNING: The keywords listed below should be used ONLY on the advice of your application developer. They can seriously alter the operation of the FairCom DB Server.

CHECK_TRNLOG_BUFFER_WRITES

Checks to see if the transaction log writes are skipping bytes.

DIAGNOSTIC_INT

Overrides the size of the default internal buffer for trapping the communications is 128K bytes. Should only be used under advice from a FairCom engineer.

 
DIAGNOSTIC_STR

Prepends a path onto the name of the communications trap file (TRAPCOMM.FCS). Should only be used under advice from a FairCom engineer.

 
DIAGNOSTICS ABEND_ABORT (Deprecated)

Enables a method for generating a process core on an abnormal shutdown by having FairCom DB call abort().

 
DIAGNOSTICS ABORT_NODE_LIST

Enables a circular memory buffer to hold information relevant to debugging a L59 error.

 
DIAGNOSTICS AUTO_PREIMG_CHECKLOCK / AUTO_PREIMG_CHECKREAD

Causes the file mode for files affected by AUTO_PREIMG configuration entries to be augmented by one or both of ctCHECKLOCK and ctCHECKREAD. Not for changing the file mode stored on disk for the files in question.

 
DIAGNOSTICS AUTO_TRNLOG_CHECKLOCK / AUTO_TRNLOG_CHECKREAD

Causes the file mode for files affected by the AUTO_TRNLOG configuration entry will be augmented by one or both of ctCHECKLOCK and ctCHECKREAD. Not for changing the file mode stored on disk for the files in question.

 
DIAGNOSTICS CHECK_UDEFER

Used to tune UDEFER options. Internal FairCom engineering use only - Not for production use.

 
DIAGNOSTICS COMM_LEVEL_X

Enables communication diagnostics.


DIAGNOSTICS DADV_ERR

Enables logging diagnostic message to CTSTATUS.FCS when a DADV_ERR error occurs.

 
DIAGNOSTICS DBGSEMTIM

Enables high-resolution measurement of the time threads wait at each mutex and semaphore call.

 
DIAGNOSTICS DEBUG

Enables a general method to signal debugging intent and to input data for diagnostic or debugging use.

 
DIAGNOSTICS EXTENDED_TRAN_NO

Forces the server to log each physical open of a non-extended transaction number file to the CTSTATUS.FCS file.

 
DIAGNOSTICS FILE_LOGON

Causes the following four file counters to be output upon each logon and logoff: physical files open, logical files open, File Control Blocks (FCBs) in use, and FCBs available.

 
DIAGNOSTICS FLUSH_BLM

Enables at file close, a check to see if any buffer or cache pages have been missed when flushing and clearing the buffer/cache space.

 
DIAGNOSTICS FORCEI_SHADOWUPD

Enables a check for unexpected instances of shadow updates during shadow entry clean-up and will list such updates in a server's CTSTATUS.FCS.

 
DIAGNOSTICS KEY_COMPARE

Enables an index tree-walk history which contains the nodes visited as well as the key comparisons made.

 
DIAGNOSTICS KLLX

Enables, at the end of automatic recovery, all leaf nodes to be checked to see if any uncommitted key values were inadvertently treated as committed.

 
DIAGNOSTICS L59

Reverts server to the prior behavior of a server termination with an L59 failure code when flaws are detected in abort node list processing

 
DIAGNOSTICS LDAP

Enables LDAP diagnostic log messages to be written to CTSTATUS.FCS.

 
DIAGNOSTICS LOCK_LOGON

Displays the net lock count upon each FairCom DB Server logon and logoff.

 
DIAGNOSTICS LOGON_COMM

Enables the logon communications sequence to be output by the server.

 
DIAGNOSTICS LOWL_CRC_ON

Enables low-level CRC communication checks.

 
DIAGNOSTICS MEMORY_LEAK

Enables debug information upon each memory alloc() (get) and free() (put) output to MEMLEAK.FCS. This option will result in extreme performance degradation.

 
DIAGNOSTICS MEMTRACK (DIAGNOSTICS MEMTRACK, DIAGNOSTICS MEMTRACK)

Deprecated: Enables the FairCom Server memory tracking feature. Should be used only when recommended by a FairCom engineering team member - It will impact performance.

 
DIAGNOSTICS NO_EXCEPTION_HANDLER

Disables the Exception Handler in case the addition of this error handler created any unexpected behavior.

 
DIAGNOSTICS NO_LOG_EXTENSION

Forces the transaction log extension logic to skip the writing of 0xff fill. The logs are then extended only as actual log writes take place.

 
DIAGNOSTICS NODE_REQUEST_TIME

Enables tracking the cumulative time spent finding each index node in the index cache.

 
DIAGNOSTICS NONE

Explicitly blocks certain keywords from being used in a subsequent stage of configuration loading.

 
DIAGNOSTICS PCRP_ERR

Enables the occurrence of a PCRP_ERR to log a message to CTSTATUS.FCS and create a process stack trace or minidump of the process. Requires a custom build.

 
DIAGNOSTICS PROCESS_EXIT

Enables FairCom DB to take the following actions before exiting: 1) Dump a process stack trace. 2) Display a dialog box on Windows.

 
DIAGNOSTICS QUEUE_LOGON

Provides the current number of items in the FairCom DB Server queues.

 
DIAGNOSTICS REMAINING_THREADS

Enables listing threads still active at server shutdown (causing the final system checkpoint to be skipped) to the CTSTATUS.FCS log file.

 
DIAGNOSTICS REPL_READ_BUFFER

Enables a check that the log data is being correctly read into the replication buffer.

 
DIAGNOSTICS SUBALLOCATOR_OFF

Forces FairCom DB to allocate memory directly from the heap instead of using its internal memory suballocator.

 
DIAGNOSTICS THREAD_DUMP

Enables low-level thread diagnostics.


DIAGNOSTICS TR_TRAN_ERR

When using a two-phase transaction commit on a local/master replication model, this keyword will log additional transaction errors to TR_TRAN.FCS in the server’s LOCAL_DIRECTORY.

 
DIAGNOSTICS TRACK_LOGON

Provides a net count of memory allocation requests. See also MEMORY_TRACK.

 
DIAGNOSTICS TRAN_RECOVERY

Causes transaction recovery log messages to be written to the file RECOVERY.FCS.


DIAGNOSTICS TREE_WALK

Enables an index tree-walk history which contains the nodes visited as well as the key comparisons made.

DIAGNOSTICS TRNLOG_WRITE

Writes a diagnostic message to CTSTATUS.FCS for each write that the server makes to the transaction logs.


DIAGNOSTICS UPDFLG (DIAGNOSTICS UPDFLG, DIAGNOSTICS UPDFLG)

Logs each change to a file update flag (updflg) to CTSTATUS.FCS.


DIAGNOSTICS UNOD_ERR

Enable UNOD_ERR (51) diagnostic stack dump.

 
DIAGNOSTICS WRITE_ERR_DUMP

Causes the contents of a write request to be appended to the WRITE_ERR.FCS file and a notification to be logged to CTSTATUS.FCS if a WRITE_ERR occurs.

 
DIAGNOSTICS WRITETHRU

Causes all file names to be listed in the CTSTATUS.FCS file if it detects a file that is not under transaction control and does not have WRITETHRU defined.

In This Section

CHECK_TRNLOG_BUFFER_WRITES

DIAGNOSTIC_INT

DIAGNOSTIC_STR

DIAGNOSTICS LDAP

DIAGNOSTICS ABEND_ABORT (Deprecated)

DIAGNOSTICS ABORT_NODE_LIST

DIAGNOSTICS AUTO_PREIMG_CHECKLOCK / AUTO_PREIMG_CHECKREAD

DIAGNOSTICS AUTO_TRNLOG_CHECKLOCK / AUTO_TRNLOG_CHECKREAD

DIAGNOSTICS CHECK_KEY_MARKS

DIAGNOSTICS CHECK_UDEFER

DIAGNOSTICS COMM_LEVEL_X

DIAGNOSTICS CTQUIET

DIAGNOSTICS DADV_ERR

DIAGNOSTICS DBGSEMTIM

DIAGNOSTICS DEBUG

DIAGNOSTICS EXTENDED_TRAN_NO

DIAGNOSTICS FALG_ERR

DIAGNOSTICS FILE_CLOSE_FLUSH

DIAGNOSTICS FILE_LOGON

DIAGNOSTICS FLUSH_BLM

DIAGNOSTICS FORCEI_SHADOWUPD

DIAGNOSTICS FULL_DUMP

DIAGNOSTICS KEY_COMPARE

DIAGNOSTICS KLLX

DIAGNOSTICS L59

DIAGNOSTICS LOCK_LOGON

DIAGNOSTICS LOGON_COMM

DIAGNOSTICS LOWL_CRC_ON

DIAGNOSTICS MEMORY_LEAK

DIAGNOSTICS MEMTRACK

DIAGNOSTICS NO_EXCEPTION_HANDLER

DIAGNOSTICS NO_LOG_EXTENSION

DIAGNOSTICS NODE_REQUEST_TIME

DIAGNOSTICS NODEQ_MESSAGE

DIAGNOSTICS NONE

DIAGNOSTICS PCRP_ERR

DIAGNOSTICS POPN_ERR

DIAGNOSTICS PROCESS_EXIT

DIAGNOSTICS QUEUE_LOGON

DIAGNOSTICS READ_ERR

DIAGNOSTICS REMAINING_THREADS

DIAGNOSTICS REPL_READ_BUFFER

DIAGNOSTICS SUBALLOCATOR_OFF

DIAGNOSTICS THREAD_DUMP

DIAGNOSTICS TR_TRAN_ERR

DIAGNOSTICS TRACK_LOGON

DIAGNOSTICS TRAN_RECOVERY

DIAGNOSTICS TREE_WALK

DIAGNOSTICS TRNLOG_WRITE

DIAGNOSTICS UNOD_ERR

DIAGNOSTICS UPDFLG

DIAGNOSTICS WRITE_ERR_DUMP

DIAGNOSTICS WRITETHRU

TOCIndex