Real Time Information Director User Documentation

RTID Security and Auditing
Hewlett-Packard Company 17 529618 - 002
Transaction logging is an option that you choose as part of the persistent
configuration of the Director. If you want transactions to be logged, specify the
name of the log table as the value of the property
RTID_TRANSACTION_LOG_TABLE in your properties file. If the value of that
property is blank, or if the property isn’t specified at all, transaction logging does
not occur.
If transaction logging is in effect, a transaction is logged, whether the transaction was
successful or not. If the transaction was successful, logging is part of the same TMF
transaction that inserted the data; if not, the log entry is a separate transaction. Note that,
if a document is successfully processed but transaction logging fails, the document load is
rolled back along with the transaction logging!
If enabled, transaction logging occurs for all insert or update. There is no way to specify
logging for specific types of transactions. Query transactions are not reflected in the log
table.
For each transaction, the log contains a row of the following format. The meaning of
each column depends on whether the document is an IDoc or a native document, as
described below. If a document couldn’t be parsed, some columns might be set to null or
to default values. If a primary key is missing, SQL will report an error.
SOURCE_NM CHAR(16) NOT NULL Primary key
TRANSACTION_DOCUMENT_TY CHAR(16) NOT NULL Primary key
TRANSACTION_DOCUMENT_NO CHAR(48) NOT NULL Primary key
SYSTEM_UPDATE_DT TIMESTAMP(6) NOT NULL Primary key
SOURCE_REFERENCE_DOC_NO CHAR(35)
DOCUMENT_STATUS_CD CHAR(8)
RECORDS_AFFECTED_CT NUMERIC(4,0)
MAP_VERSION_NO CHAR(4)
MESSAGE_TX VARCHAR(3500)
Transaction Logging for IDocs and Native Documents
The values of fields in the transaction log come from either the document header or the
top-level record of the inbound document. Any value not available in one of these
locations is set to null in the log table.
In the case of an IDoc, the columns in the log table have the following meanings:
SOURCE_NM Concatenation of IDOCTYP & SNDPOR from the
IDOC header
TRANSACTION_DOCUMENT_TY MESTYP from the IDOC header
TRANSACTION_DOCUMENT_NO DOCNUM from the IDOC header
SYSTEM_UPDATE_DT The currentTimeStamp from documentHandler object.