Can multiple Central Loggers in a TIBCO ActiveMatrix Service Getway (ASG) environment connect to the same database?
Article ID: KB0086392
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix Service Gateway | - |
| Not Applicable | - |
Description
Resolution:
Description
=========
Yes, it is possible for multiple for multiple Central Loggers (or asg-engine -u asg-cl) to connect to the same database.
Resolution
=========
The following columns in the ASG_TRANSACTIONS table can be used to differentiate between ASG engines from different environments, accessing the same Common Logging database.
(1)
TRN_SITE
Its value is taken from the Global Variable "tibco.clientVar.CL/Logging/siteNumber=<n>" in asg_cl.properties.
TRN_SITE column of ASG_TRANSACTIONS will be updated with "n" specified in the siteNumber.
(2)
TRN_ENGINE
This column contains the name of the engine which handled the transaction.
It is possible to assign an engine name: using the "-n" parameter while starting asg-engine on the command line.
Here are some additional recommendations:
If you are going to have muliple CL engines from different environments write into the same DB then make sure that the sizing of the DB is done properly and you implement some housekeeping procedures (archival and deletion of old entries etc).
Issue/Introduction
Feedback
