| 
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?
 
  |