Hi Sam,
You can also find the configured database information in the config.$AUTOSERV file under $AUTOUSER directory.
Example:
$ cd $AUTOUSER
$ more config.PRD
# Keyword: Provider=<ORA|SYB>
#
# Specifies which Relational Database Management System (RDBMS)
# provider CA Workload Automation AE uses.
#
# The valid values are as follows:
#
# ORA = Identifies Oracle as the database provider.
# SYB = Identifies Sybase as the database provider.
#
Provider=ORA
#+---------
#
# Keyword: DBAccess=username/password
#
# Defines the user name and password (in encrypted format) used by
# the scheduler and application server to connect to the database.
# The database user name and password is defined during the CA
# Workload Automation AE installation.
DBAccess=autosys/E6F5F6A37E4ED383DA19CC52A6890474
#+----------
#
# Keyword: EventServer_1=<SYBASE_SVR:SYBASE_DB,DBPORT,DBHOST |
# SYBASE_SVR:SYBASE_DB,DBPORT,DBHOST,PRINCIPAL |
# ORACLE_SVR,DBPORT,DBHOST >
# Specifies the database for a specific event server. Typically,
# this name is AEDB. In dual event server mode, the value for both
# secondary event servers can be different and it is specified as
#
# Keyword: EventServer_2=<SYBASE_SVR:SYBASE_DB,DBPORT,DBHOST,PRINCIPAL |
# ORACLE_SVR,DBPORT,DBHOST >
#
# When CA Workload Automation AE runs in single event server mode,
# only one event server is defined. If you wish to run CA Workload
# Automation AE in dual event server mode, you must specify the
# database that the second event server will connect to in the
# EventServer_2 keyword.
#
#
# The valid values for a Sybase database are as follows:
#
# SYBASE_SVR:SYBASE_DB,DBPORT,DBHOST,PRINCIPAL
# Identifies Sybase as the database for a specific event server.
#
# For Sybase, the parameters that compose this keyword value
# consist of the Sybase server name:database name combination,
# database TCP-IP port, the database host and the optional server
# principal if kerberos authentication is used, comma-delimited.
#
# Example: EventServer_1=SYBSVRPROD:AEDB,5000,MACHPROD,SybPrincipal
#
#
# The valid values for an Oracle database are as follows:
#
# ORACLE_SVR,DBPORT,DBHOST
# Identifies Oracle as the database for a specific event server.
#
# For Oracle, the parameters that compose this keyword value
# consist of the Oracle SID, database TCP-IP port, and the
# database host, comma-delimited.
#
# Example: EventServer_1=orcl,1521,MACHPROD
#
# Note: For Oracle database, database TCP-IP port and database host
# values will be ignored when DBAccessMode value is set to 1.
#
EventServer_1=DB1,1521,dbserver1 < ========
EventServer_2=DB2,1521,dbserver2 < ========
+----------
#
# Keyword: DBLibWaitTime=<value>
#
# Defines the time (in seconds) the scheduler and the application
# server wait before breaking the connection with an event server
# in an unknown state. That is, the scheduler and the application
# server maintain and check connections with the databases, and if
# an event server is in an unknown state, the connection is broken
# after the specified time.
#
# Default: 90
#
# Note: If you set the DBLibWaitTime parameter to 0 (zero), the
# scheduler or the application server do not time out. They
# wait until the database responds. We do not recommend
# setting this parameter to 0 because the scheduler may stop
# responding.
#
#DBLibWaitTime=90
#+----------
#
# Keyword: DBEventReconnect=<value> - Single Server Mode
# DBEventReconnect=<value,value> - Dual Server Mode
#
# Defines the number of times the scheduler or the application
# server try to connect (or reconnect) to an event server before
# shutting down or before rolling over to single event server mode.
#
# Default: 50 (in single event server mode)
# 50,5 (in dual event server mode)
#
# Limits: For dual event server mode, specify two numbers separated
# by a comma.
#
DBEventReconnect=50,5
#
# In Dual Event Server Mode, this parameter contains two values
# describing the connection and rollover behaviors as follows:
#
#DBEventReconnect=50,5
.........
I hope this can help.
Thanks,
Roya