The transaction audit information log data tables must be deployed with InfoSphere® MDM. Each contains default information.
The data tables with default values that must be deployed with the TAIL module include:
- CDBUSINESSTXTP – This table holds the external, or callable, transaction code types, names, and transaction log indicator required to configure a particular transaction for logging by TAIL; the terms callable and external refer to transactions that exist at the controller-level. Default data is supplied in this table for use with InfoSphere MDM. By default, all external transactions are logged if /IBM/DWLCommonServices/TAIL/enabled is set “true” in the Configuration and Management component.
- CDINTERNALTXNTP – This table holds all of the internal transaction code types and names so that internal transactions may be logged during a particular external transaction-the term internal refers to transactions or methods that exist at the component-level.
- BUSINTERNALTXN – This table holds values for external transactions and their internal transactions, as well as an indicator for whether each internal transaction within a external transaction is to be logged. See Using the Configuration and Management components for more information on configuring these options.
- INTERNALTXNKEY – This table holds all values necessary for a particular internal transaction to log particular keys that in turn may be used for log retrieval. All of the following fields will be configured as keys (element_name) for a business object: PartyId, ContractId, ContractIdPK, PersonPartyId, OrganizationPartyId. If the business object does not contain any of the aforementioned fields, then only the primary key of the business object is stored as a key.
- EXTERNALTXNKEY – This table holds all the values necessary for a particular external transaction to log its corresponding transaction keys that in turn may be used for log retrieval.
- V_GROUP – This table contains metadata about all of the business objects.
- V_ELEMENT – This table stores information about all elements of a business object.