Question: How do I tell different databases apart in Alert emails?
Answer:
-
Specify a different DSN or Connection String name for each target database when starting
a Foxhound Monitor session for that database, or
set the GlobalDBId property to a different non-default value for each target database that uses
Version 7 or later of SQL Anywhere. If the target database GlobalDBId property is set to a non-default value, that value will
be shown in (parentheses) after the DSN or Connection String name in Alert emails.
This makes it easier to tell different remote databases apart
in a replicating or synchronizing environment.
Here's how to set the GlobalDBId option:
SET OPTION PUBLIC.global_database_id = '47';
Here's how to display the value after you've set it:
SELECT DB_PROPERTY ( 'GlobalDBId' )
Here are the non-default GlobalDBId value ranges:
See also...
How do I get multiple copies of Foxhound?
|