AE DB Revision Report

language=

The language that the login window suggests by default.

Allowed values: "E" (default), "D", "F"
"D" = German
"F" = French
"E" = English

The language that you select when you log on affects the utility's interface and the log-file messages. If you select several languages here, the first language is used as the default language.

logging=

The path and file name of the log file.

The number characters are used as placeholders for consecutive numbering. When you start the utility, the log files are renamed so that the current log file always shows the number "00".

logcount=

The number of stored log files.

helplib=

The name of the message file.

helpcache=

The availability of the message and language dependent strings.

Allowed values: "ALL" (default value), "NONE", "CONTROLS"

"ALL" = The entire message file is kept in the RAM.
"NONE" = The message file is always read from the hard drive.
"CONTROLS" = All language dependent strings which are required for displaying a Dialog program are held in the RAM. 

[TRACE]

file=

The path and file name of the trace file.

The number characters are used as placeholders for consecutive numbering. When you start the agent, the log files are renamed so that the current log file always shows the number "00".

trccount=

The number of the stored trace files.

databaseA database is an organized collection of data including relevant data structures.=

The trace flag for database access of the utility.

Allowed values: "0" (default value) to "9"

Trace flags must only be used in close cooperation with Automic Support.

[ODBC]

SQLDRIVERCONNECT=

The connection for the database.

ODBCVAR - Eight-digit command field for controlling database accesses.

1. Position = N - Do not use server cursor.
1. Position = S - Use server cursor (MS SQL Server 2000).
2. Position = N - Do not reestablish database connection after 1000 commits.
2. Position = D - Disconnects database after 1000 commits (perhaps due to memory problems).
3. Position = N - Field names are compared case-sensitively (Oracle).
3. Position = J - Field names are compared case-insensitively (Oracle).
4. Position = N - Not used.
5. Position = N - The type of the database connection: ODBC
5. Position = I - The type of the database connection: OCI/CLI.
6. Position = N - The database access without User ID.
6. Position = O - The database access with User ID.
7. Position = N - Compression is deactivated.
7. Position = R - Compression is activated.
8. Position = The type of SQL Syntax; N - MS SQL Server
8. Position = The type of SQL Syntax; O - Oracle
8. Position = The type of SQL Syntax; D - DB2

DSN - The alias name of the database connection.
UID - The user ID for database access.
PWD - the passwordA secret combination of characters for a Automation Engine user. for database access. Should always (also "") be encoded. See: Encoding Passwords

Only for ORACLE:
Code page settings must correspond to those of the database. Automic recommends using the variable NLS_LANG or the parameter SP=.

Syntax:
SP=NLS_LANGUAGE=language,NLS_TERRITORY=area,CODESET=character set,RECONNECT=interval,commit_write='BATCH,NOWAIT'

RECONNECT refers to the frequency that is used to re-establish the database connection. This parameter is given priority even if a "D" was set in the 2nd digit of ODBCVAR (see above).

Automic recommends using the parameter commit_write='BATCH,NOWAIT' in order to increase performance.

For example:
(Two lines are used for the connection parameters for lack of space. You should only use one line in the INI file.)

SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;
SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15,commit_write='BATCH,NOWAIT'

See also: Setting up ORACLE databases

Only for DB2:

Use "N" on the 6. position in the connection string, when the UID for database access is a domain user.