AE DB Unload

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

Structure of the INI File UCYBDBUN.ini

Section/Parameter

Description

[GLOBAL]  

logging=

The path and the file name of the log file.

The number characters are used as place holders 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.

OUTPUT=

The path and the name of the file that contains the unloaded data.

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. 

Reorg_Commit_Sleep=

The waiting time in milliseconds after the data records have been deleted. This specification can be used to avoid that the database is permanently blocked. The number of data records is defined with CommitCount=.

Default value: 100

CommitCount=

The number of data records that should be deleted at once.

Default value: 100

language=

Language.

Allowed values: "D", "F" and "E" (default)
"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. When you select several languages here, the first language is used as the default language.

docu_path= The directory in which the help system is installed.

cmd=

The command line command that can be used to start the utility.

path=

The start path for the utility.

title=

This parameter serves internal purpose in the utility. The value must not be changed.

[ENVIRONMENT]

 

classpath=

The path and the file name of the archive for layout files.

[TRACE]

 

file=

The path and the file name of the trace file.

The number characters are used as place holders 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 stored trace files.

database=

The trace flag for the utility's database access.

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

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

level=

The trace level for the program flow of the utility.

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

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

[TRANSPORT]

 

all_entities=

The setting for the scope of the unloaded data in the Transport Case.

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

"0" = Only object attributes that contain a value are exported.
"1" = The utility exports all object attributes regardless of their contents.

This setting is important if the unloaded data is subsequently changed by using AE DB ChangeDienstprogramm zum Ă„ndern von Transportkoffer-Exporten..

Activate this setting if data is unloaded from the system client by means of a Transport Case which should subsequently be loaded to other clients.

[REORG]

 

no_archive_check=

Archiving check.

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

"0" = Checks if the data has been archived before.
"1" = There is no such check.

reorg_chunk_size=

The number of data records of the relevant top table (such as "AH") that should be deleted per transaction including all its corresponding entries in sub-tables.

The system uses the default value when you specify a value that does not lie within the allowed range of values.

Allowed values: "50" to "5000"
Default value: "1000"

reorg_sleep_time=

The waiting time in milliseconds that the system should wait after each deletion transaction.

Allowed values: "0" (default) to "10000"

max_deadlock=

The maximum number of deadlocks per operation.

Default value: "100"

[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 the 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 - Database access without the User ID.
    6. Position = O - Database access with the 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 the database access.
PWD - The password for the database access. Should always (also "") be encoded. See: Encoding passwords

Only for ORACLE:
The 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. In the INI file, you should only use 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\UCYBDBUN_LOGG_##.TXT
logcount=10
OUTPUT=..\DB\UC_DATA.TXT
helplib=uc.msl
helpcache=ALL
;wait time in milliseconds (only in case of Reorg)
;Reorg_Commit_Sleep=500
CommitCount=100
language=E
docu_path=C:\AUTOMIC\Documentation
cmd="javaw" -jar -cp .;.\UC4LAF.jar UCYBDBUN.jar
path=.
title=UCYBDBUN


[ENVIRONMENT]
classpath=.;.\UC4LAF.jar


[TRACE]
file=..\TEMP\UCYBDBUN_TRACE_##.TXT
trccount=10
database=0
; 0=no
; 1=SQL
; 2=OPC
; 3=BindParam
; 4=data fields
level  =0
; 0=no
; 1=Basic trace
; 2=Function level
; 3=Section level
; 4=everything


[REORG]
reorg_chunk_size=1000
no_archive_check  = 0
max_deadlock      = 100


[TRANSPORT]
all_entities = 1



[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-insensitiv (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:

Unloading Databases