Specifying Database Connection Parameters
For Progress databases, you can specify connection parameters directly in Audit DB Maintenance or include them in a parameter file. If you use a parameter file, you must still specify the database name in the Audit DB Maintenance screen. If the database is not located in the PROPATH, you must also specify the full path in Database Directory.
Note: Typically, each implementation has additional parameters that are needed to accommodate specific requirements that cannot be specified directly in the maintenance screen. These can be supplied in the parameter file.
For Oracle databases, you specify some values in Audit DB Maintenance, but a parameter file is always required. This is because two sets of connections are required for Oracle databases: one for the Progress schema holder and one for the Oracle database. The values that you specify in the Audit DB Maintenance fields apply to the Progress schema holder only. Connection to the Oracle database is defined in the parameter file.
Database Online
This field indicates whether the system should attempt to connect to the audit database. It does not indicate that an audit database is running, nor that a connection to the database has been tested or is currently active.
Physical Database Name
Enter the actual physical name of the Progress database or schema holder. Database names are typically case sensitive and can be up to 12 characters long.
The database directory and physical name together make up the complete path name to this database. These are used on the database connect statement when connecting to this database.
For example, on a UNIX system if your database is stored as /qad/d7/qadaud01.db, then the directory is set to /qad/d7 and the physical name is qadaud01. You do not need the .db extension.
Database Directory
Enter the complete path name of the operating system directory where this database is stored. Path names may be case sensitive and can be up to 50 characters long.
The following fields should only be specified if they are not included in a parameter file. If you do specify them with a parameter file, any values in the parameter file are used instead of these values.
Host
Enter the name of the host server where the Progress database or schema holder can be found. This name follows the -H parameter on the Progress connect statement. It is only required when the database is located on a different computer.
Server
Enter the name of the service to be used by the broker process when starting up the remote database. This name follows the ‑S parameter in the Progress connect statement. It is only required when the database is not located on the current machine.
Type
Specify the audit database type, either Progress or Oracle. You must use a parameter file to connect to Oracle audit databases.
Network
Enter the type of network being used. Valid values are TCP (default) and SNA (Progress/400). If left blank, TCP is assumed. This value follows the -N parameter on the Progress connect statement.