1.A. The APM CE Audit Trail is stored inside the APM database in these table: ts_audit_records and ts_audit_record_props.
2.A. Business transactions are stored in the database in various tables. Note that each table is associated with other tables with dependency keys.
These are the main tables: ts_transets and ts_tranunits.
3.A. The schema name and Unique indenter field name is stored in the tess-db-cfg.xml file. It is located in the MOM EM_HOME\config folder.
For example: If your database is Oracle, then the values will look like this:
Here, Schema Name is cemuser and the Unique Identifier field name is SERVICE_NAME
4.A. The APM CE transaction definitions are sent to the TIM as flat files as the TIM does not have a database. This process happens when clicking on Synchronize Monitors.
Path for flat files on Tim:
The flat files will be in this path on tim: /usr/local/wily/cem/tim/config.