Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

DIAGNOSTICS TR_TRAN_ERR

When the local/master replication model experiences out-of-sync data between the master and local servers, this server configuration option enables logging of errors during the two-phase commit sequence. The log entries are written to the file TR_TRAN.FCS in the server's LOCAL_DIRECTORY directory.

Sample log messages:

Wed Mar 1 09:35:46 2017 Transaction operation TRANABT failed: loc=1 master_err=127 local_err=0

Wed Mar 1 09:37:44 2017 Transaction operation TRANEND failed: loc=5 master_err=128 local_err=71

Wed Mar 1 09:43:25 2017 Transaction operation TRANEND failed: loc=5 master_err=128 local_err=0

Wed Mar 1 10:30:45 2017 Transaction operation TRANEND failed: loc=6 master_err=0 local_err=768

The log message includes the function that failed, location code where the error occurred, and master and local server error codes.

This feature can be enabled/disabled at runtime using ctSETCFG() or the ctadmn option to change a DIAGNOSTICS option.

TOCIndex