How Many Tables Are Used For Mediator Instance Tracking?

1.	How Many Tables Are Used For Mediator Instance Tracking?
Answer» There are in total 5 tables which are used by MEDIATOR instance TRACKING: Mediator_instance - One row for each mediator MESSAGE flow. Mediator_case_instance - One row for each mediator case (~ routing rule). If a mediator component has two routing rules then this should have 2 records for that mediator instance. Mediator_case_detail - Captures mediator audit trail for each mediator routing rule. Number of records may vary based on the nature of mediator component. Eg: if mediator component is having a async req-resp routing rule then this would contain 2 rows for the corresponding mediator routing rule. Mediator_document - Stores the payload for routing rules which are configured as DEFERRED (~ parallel in JDEV). So if all the routing rules are "sequential" then this will not contain any records. Mediator_audit_document - Stores the payload for audit trail and only when "instanceTrackingLevel" for mediator is "Complete". There are in total 5 tables which are used by mediator instance tracking:

Answer»

There are in total 5 tables which are used by MEDIATOR instance TRACKING:

Mediator_instance - One row for each mediator MESSAGE flow.
Mediator_case_instance - One row for each mediator case (~ routing rule).
If a mediator component has two routing rules then this should have 2 records for that mediator instance.
Mediator_case_detail - Captures mediator audit trail for each mediator routing rule. Number of records may vary based on the nature of mediator component.
Eg: if mediator component is having a async req-resp routing rule then this would contain 2 rows for the corresponding mediator routing rule.
Mediator_document - Stores the payload for routing rules which are configured as DEFERRED (~ parallel in JDEV). So if all the routing rules are "sequential" then this will not contain any records.
Mediator_audit_document - Stores the payload for audit trail and only when "instanceTrackingLevel" for mediator is "Complete".

There are in total 5 tables which are used by mediator instance tracking:

Discussion