AE DB Archive

helplib=

The name of the message file.

helpcache=

The availability of 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 required for displaying a dialog program are held in the RAM. 

language=

The default language that is used for login.

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

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.

MaxDeadlockCount=

The maximum number of deadlocks per operation.

docu_path=

The directory in which the help system is installed.

cmd=

The command-line command for starting the utility.

path=

The start path for the utility.

title=

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

The utility processes the data records block by block. This parameter specifies the block size (number of data records).

Default value: 200 000

[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.

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

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. AE does not recommend setting trace flags because the logging of database accesses decreases performance.

[AH_BODY]

This section serves to specify the data that should be written to the archiving file.

"1" - Data is included in the archiving process.
"0" - Data is not included in the archiving process.

AH_TimeStamp1=

Activation time.

AH_TimeStamp1=

Start time.

AH_TimeStamp4=

End time.

AH_MsgNr=

The message number and the message inserts.

AH_LoginDst=

The name of the Login object for file transfer (destination).

AH_ProcessId=

TNS/Process ID.

AH_CpuTime=

Used CPU time.

AH_KernelTime=

Used system time.

AH_UserTime=

Used user time.

AH_IOCount=

IO counter.

AH_InfoText=

Text from the agent.

AH_HostDst=

The host name for the file transfer (destination).

AH_CodeNameDst=

The code table for the file transfer (destination).

AH_FileNameDst=

The file name for the file transfer (destination).

AH_HostSrc=

The host name for the file transfer (source).

AH_LoginSrc=

The name of the Login object for the file transfer (source).

AH_CodeNameSrc=

The code table for the file transfer (source).

AH_FileNameSrc=

The file name for the file transfer (source).

AH_Count=

The number of transferred bytes (for file transfer) or started tasks (for a group).

AH_FileSize=

The bytes of the complete file.

AH_Records=

The number of records in the file.

AH_Status=

Status of the activity.

AH_RetCode=

The task's return code .

AH_Restart=

The restarted activation.

AH_RefNr=

The RunID of the reference task for a restart.

AH_RestartPoint=

The restart point of the restarted task .

AH_LastRP=

The last processed restart point.

AH_EventType=

TT - Time event (timer).
TS - Time event (time of execution).

AH_RepeatType=

Event:
R = repeated
S = single
File transfer: include subdirectories
R = yes
S = no

AH_TimePeriod=

The period in minutes or HHMM depending on the event type.

AH_CheckCount=

The number of checks.

AH_OccurCount=

The number of occurred events.

AH_EventSubType=

The event's subtype

AH_Operator=

G = greater
L = less
E = equal
N = not equal

AH_Value=

Comparing value

AH_Unit=

The unit of the comparing value:
0 = host specific
1 = Byte
2 = Kilobyte
3 = Megabyte
4 = Gigabyte
5 = Terabyte

AH_Cancel=

Cancels the flag:
M = manually

AH_Source=

WIN_EVENT: Source

AH_Category=

WIN_EVENT: Category

AH_TExecType=

Time event with a start time:
E = execute
N = do not execute
Time event with an interval:
S = start immediately
File transfer:
1 = File transfer with wildcard characters

AH_MaxRetCode=

The return code settings of the Runtime tab.

AH_IntAccount=

The internal account of the Attributes tab.

AH_Name=

The name of the object.

AH_Transferred=

The transferred number of bytes.

AH_Compress=

The compression type

"0" - None
"1" - Normal
"2" - Strong

AH_Archive1=

The archive key 1 of the Header tab.

AH_Archive2=

The archive key 2 of the Header tab.

AH_Info=

Additional information, such as job number.

AH_ParentAct=

The parent's ID (Activator).

AH_ParentPrc=

The parent's ID (Processor).

AH_DeleteFlag=

Deletion flag.

AH_TaskCount=

The number of tasks.

AH_ArchiveFlag=

The archive flag.

AH_Rest=

Additional attributes.

AH_TZ=

The TimeZone for object and script.

AH_TimePeriodTZ=

The TimeZone for the event.

AH_ReuseHostGroup=

Re-using the agent group calculation in workflows.

AH_HGSrc=

The name of an agent group.

AH_HGDst=

The name of an agent group as the destination of file transfers.

AH_MaxParallelHG=

The maximum number of parallel tasks in agent groups.

AH_ChildCnt=

The number of subordinated tasks.

AH_ChildCntFail=

The number of subordinated tasks that have been canceled and successfully repeated.

AH_ChildCntFailAll=

The umber of subordinated tasks that have been canceled.

AH_ChildCntRestart=

The number of subordinated tasks that have been repeated.

AH_ContainerType=

The object type of the related container.

[ODBC]

SQLDRIVERCONNECT=

The database connection.

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 passwordA secret combination of characters for a Automation Engine user. 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" is 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.