AE DB Reporting Tool

Default values have been specified for most parameters. They can be changed if required. Parameters which must be adjusted to your system environment are written in red letters.

Structure of the INI File UCYBDBRT.INI

Section/Parameter Description
[GLOBAL]  

logging=

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=

Number of stored log files.

helplib=

Name of the message file.

helpcache=

Availability of messages 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 that are required in order to display a dialog program are held in the RAM.

Deadlock_Retry= It is not possible to determine the period between two attempts. The actual duration is a random number which lies between several milliseconds and a maximum of 10 seconds.

[OPTIONS]

 

fixFieldOrder=

Order in which the fields are listed in the analysis report.

Allowed values: "0" (default value) and "1"

"0" - The order results from the specification made in the utility's analysis definition.
"1" - The utility automatically selects the order in which the data is logically grouped.

[TRACE]

 

file=

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=

Number of stored trace files.

database=

Trace flag for the utility's database access.

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

reptool=

Trace flag for the Reporting Tool.

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

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

[ODBC]

 

SQLDRIVERCONNECT=

Connection for the database.

ODBCVAR - Eight-figure command field to control 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 - Disconnect 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 - Type of database connection: ODBC
    5. Position = I - Type of database connection: OCI/CLI.
    6. Position = N - Database access without User ID.
    6. Position = O - Database access with User ID.
    7. Position = N - Compression is deactivated.
    7. Position = R - Compression is activated.
    8. Position = Type of SQL Syntax; N - MS SQL Server.
    8. Position = Type of SQL Syntax; O - Oracle.
    8. Position = Type of SQL Syntax; D - DB2.

DSN - Alias name of the database connection.
UID - User ID for database access.
PWD - Password for database access. Should always (also "") be encoded. See: Encoding passwords

Only for ORACLE:
Code page settings must correspond to those of the database. AE therefore 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.

Example:
(Two lines are used for the connection parameters for lack of space. In the INI file, you should use only one line.)

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.

See: Notes for Configuration-File Adjustments

Example of an INI File

[GLOBAL]
logging=..\TEMP\LOGG_REP_##.TXT
logcount=10
helplib=uc.msl
helpcache=ALL


[OPTIONS]
fixFieldOrder=0


[TRACE]

file=..\TEMP\TRACE_REP_##.TXT
trccount=10
database=1
; 0=no
; 1=SQL
; 2=OPC
; 3=BindParam
; 4=data fields
reptool=9


[ODBC]
; ODBCVAR xxxxxxxx
;         |||||||+ type of SQL-Syntax N=SQL-SERVER  O=ORACLE  D=DB2
;         ||||||+- R=compress messages and local memory
;         |||||+-- O = with userid, N = without userid
;         ||||+--- I=OCI/CLI N=ODBC
;         |||+---- not used
;         ||+----- J = compare fieldnames case-insensitive (in case of ORACLE !!)
;         |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks)
;         +------- S = use Server-Cursor (SQL-SERVER)
;
;         SNNNNNRN for SQL-Server 2000
;         NNNNNNRN for SQL-Server 2005
;         NNJNINRO for Oracle 8.x with OCI (Oracle Call Interface)
;         NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface)

; SQL-Server 2000 with ODBC
SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=10BFDC349F38156A22
; SQL-Server 2005 with ODBC
;SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=UC4
; Oracle with OCI
;SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4;UID=scott;PWD=tiger
; DB2 with CLI
;SQLDRIVERCONNECT=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=UC4

See also:

Reporting