Logging Locations for LOG TRANSACTIONS and LOG TRANSACTIONS TO FILE

With RBR processing, data is logged according to one of three scenarios:

1. EIM logs transactions into S_DOCK_TXN_LOG table or .DX files if:

   • Remote System Preference Enable Transaction Logging is checked

     • LOG TRANSACTIONS = TRUE in the .IFB file (default)

     • LOG TRANSACTIONS TO FILE = TRUE in the .IFB file (default)

     If LOG TRANSACTIONS = TRUE and LOG TRANSACTIONS TO FILE = TRUE (which are the default values), EIM logs a transaction into the .DX files, which are stored in <SiebelFileSystem\eim> folder. EIM creates the "marker" transaction in the S_DOCK_TXN_LOG table.

     S_DOCK_TXN_LOG.LOG_DATA1 (or LOG_DATA_2, 3, 4) stores the name and the location of the .DX file as in the following example:

     N128*d:\15051sia\FS\eim\1-CP-1.dx

     In this example, 1-CP-1.dx is the name of the .DX file and it is located in the \\15051sia\FS\eim folder.

     Once the data is created in the .DX file and the marker transactions have been created in the S_DOCK_TXN_LOG table, Transaction Processor (TxnProc) captures the .DX files from the \eim folder and brings them into the TxnProc folder for Transaction Router (TxnRouter) to process.

2. EIM logs transactions into the S_DOCK_TXN_LOG table, and eventually, TxnProc or TxnMerge creates the .DX file in the <SiebSrvr\Docking\TxnProc> folder if:

   • LOG TRANSACTIONS = TRUE in the .IFB file (default)

   • LOG TRANSACTIONS TO FILE = FALSE in the .IFB file

3. EIM does not log any transactions into the S_DOCK_TXN_LOG table or in the .DX file if:

   • LOG TRANSACTIONS = FALSE in the .IFB file

     This is the case regardless of what value is defined for LOG TRANSACTIONS TO FILE.

   The LOG TRANSACTIONS parameter is explicitly used to control whether changes made by EIM to the Siebel database should be visible to remote clients (by logging transactions for use by the Docking Manager, which synchronizes the Siebel database with remote clients).