Administration Guide > Configuration > Structure of the Configuration Files > Database Agent

Database Agent

Default values have been specified for most parameters. They can be changed if required. Parameters that must be adjusted to your system environmentAn Environment consists of Deployment Targets which represent your endpoints. Different environments are used for different phases in the software delivery cycle, for example Development, QA, Staging, Production. An environment is typically set up once and used by several applications. are written in red letters.

Structure of the INI File UCXJSQLX.INI

Section/Parameter Description
[GLOBAL]  
name=

Name of the agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host.

The agent name is limited to 32 of the following characters: "A-Z", "0-9", "_", ".", "$", "@", "-" and "#"

Hyphens ("-") are only allowed in agent names. They must not be used in the names of any other objects.
system=

Name of the AE system.

This entry must be identical to the entry in the Automation EngineThis component drives an Automation Engine system and consists of different types of server processes.'s INI file.

language=

Language that is used to log on. Entries for primary and secondary language.

Allowed values: "E", "D", "F"
Default: "E,D" (primary: English, secondary: German)

If there is no message in the primary language, a message in the secondary language is searched for.

logging=

Path and file name of the log file.

The number signs serve as placeholders for a series in numerical order. If you start the agent, the log files are renamed so that the most current log file is always the one with the number 00.

logcount= Number of stored log files.

LogMaxSize=

The maximum size of the log file in bytes.

A new log file will be created when the limit that has been defined here is reached.

Default value: 10 MB

The default value will be used when you set the value "0".

You can use one of the following prefixes with this value:
k...kilo, M...mega, G...giga

Examples: 100k corresponds to 100 kilobytes, 20M to 20 megabytes and 1G to 1 gigabyte.

The agent reads LogMaxSize, if a value is set, and is not 0, the value is used. If LogMaxSize doesn't exist, or is 0, the agent uses the max_logging_kb setting.

max_logging_kb=

The maximum size of the log file.

A new log file is created when the size that you specify here has been reached.

Default value: 1000 KB

The agent reads LogMaxSize, if a value is set, and is not 0, the value is used. If LogMaxSize doesn't exist, or is 0, the agent uses the max_logging_kb setting.

log_to_file=

Creation of log files.

Allowed values: "0", "1" (default values)

"0" = No log files are created.
"1" = Log files are created.

Logging contents are always sent to the Automation Engine regardless of the specifications made here. These contents are available in the System OverviewThe UserInterface window that contains information about the Automation Engine system..

helplib=

Name of the message file.

[AUTHORIZATION]  
InitialPackage=

The name and the path of the file that includes the authentication package (company-key file).

This parameter must be specified if you use the authentication methods "Server" or "Server and Agent". Any attempt to log in fails if the company-key file cannot be found.

When the agent starts, it reads the company-key file and stores its information in the file that is specified in the parameter KeyStore=. The first file is deleted afterward.

KeyStore=

The name and the path of the file that includes the information of the authentication packageA Package is an instance (a version, a revision, a tag, …) of your application and defines the content which you want to deploy. Here you decide, if you want to deploy the entire application or just a few specified components. (see parameter InitialPackage=).

If no file name and/or path is specified, the system uses the name (file ending *.kstr) or the path of the agent's INI file. If you define a file name, the ending *.kstr is not automatically appended.

The KeyStore file is created when the agent starts for the first time. You must not delete, rename or move it subsequently. Regardless of the authentication method that you use, any attempt to log in will fail if the agent cannot find this file when it starts. In this case, you must open the menu item "Renew transfer key" in the affected agent's System Overview.

Java agents (SAP, RA, databaseA database is an organized collection of data including relevant data structures. and JMX) that run under UNIX create a keystore file with the following right: "-rw-r--r—". In doing so, other OS users can also access this file.

[TRACE]

 

file=

Path and file name of the trace file.

The number signs serve as placeholders for a series in numerical order. When you start a trace, the trace files are renamed so that the most current trace file is always the one with the number 00.

trccount=

Number of stored trace files.

TraceMaxSize=

The maximum size of the trace file in bytes.

A new trace file will be created when the limit that has been defined here is reached.

Default value: 10 MB

The default value will be used when you set the value "0".

You can use one of the following prefixes with this value:
k...kilo, M...mega, G...giga

Examples: 100k corresponds to 100 kilobytes, 20M to 20 megabytes and 1G to 1 gigabyte

tcp/ip=

Trace flags of the agent.

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

Set trace flags only in close cooperation with Automic Support.

[TCP/IP]  

bindaddr=

IP address or hostComputer, target system. name for communication processA communication process is part of the component Automation Engine. It is responsible for connecting the components. connection.

Use this parameter if the connection should be established via a particular IP address (for example, the computer has more than one network interface card).

connect=

Time interval in seconds during which the agent attempts to establish connection to the Automation Engines. Affects the connection setup for a restartA restart refers to the repetition of an object's execution. This action differs from a new start in some parts. or after a lost connection.

Default value: 60 seconds

This parameter is only effective until the first successful logon to the AE system has been made. Afterwards, you can use the parameter RECONNECT_TIME in the Host Characteristics for this purpose.

cp=

Address of the AE system's communication process to which the agent should connect.

Allowed formats:
DNS name
:port number
TCP/IP address
:port number

[ORACLE]

 

enable_output=

Transfer of outputs that are made by stored procedures.

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

"0" - The output is not written to the jobAn Automation Engine object type for a process that runs on a target system. reportA report provides more detailed information about a task's execution or a component..
"1" - The agent writes outputs to the job report.

buffer_size=

Buffer size in bytes for the outputs that should be written to the job report.

Default value: 8000

vsession_machine=

Determines the value that the agent returns if a SELECT is made to the MACHINE column of the V$SESSION view.

The MACHINE column is defined as VARCHAR2(64). To define a shorter value, you can use this parameter.

This setting is only relevant if you use the Avaloq Agent.

[SQL]

 

connect=

Time interval in seconds during which the job tries to establish a connection to the database.

retention_time=

Number of seconds after which an unused database connection should be terminated.

type=

Database type.

Allowed values: "MSSQL", "ORACLE", "DB2", "MYSQL", "INFORMIX", "INGRES", "HANA" and "SYBASE", "POSTGRESQL", "EXASOL"

retry=

Number of connection attempts to the database.

The number that is specified in this parameter determines how often the agent tries to connect to the database. After the nth failure, the job ends with statusThis represents the condition of a task (such as active, blocked, generating). ENDED_NOT_OK.

The agent continues to connect to the database if this parameter is not specified in the INI file. The job remains active until the database is available again or until it is canceled.

newline=

Output of blank lines after tables that are used in reports.

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

"0" - The agent does not insert a blank line after a table.
"1" - A blank line is inserted after each table.

useOraClient=

Connection method to Oracle databases.

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

"0" - The agent can only connect to an Oracle Database Instance. The Job objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task contains the relevant connection data.
"1" - The agent can connect to Oracle RAC nodes. The Oracle file tnsnames.ora contains the relevant connection data.

WindowsAuthentication=

The Windows userIn the Automation Engine, a user is an instance of a User object, and generally the user is a specific person who works with Automic products. The User object is assigned a user ID and then a set of access rights to various parts of the Automation Engine system and product suite. These access rights come in the form of Automation Engine authorizations and privileges, Decision user roles and EventBase rights and ARA web application object rights. You can manage all these centrally in the ECC user management functions. See also, Unified user management. under which the agent has started is used to log on to MS SQL databases.

Allowed values: "0" (default) and "1"
"0" - SQL Server authentication: Login data used to log on to the database is retrieved from the Login objects that are used in database jobs.
"1" - Windows authentication: The Windows loginAn Automation Engine object type that stores account credentials used by agents on target systems. of the OS user under which the agent runs is used.

Requirements:

  • An MS SQL Server database is used (type=MSSQL).
  • The database agent runs on a Windows operating system.
  • UC_HOSTCHAR_DEFAULT: ANONYMOUS_JOB = "Y"

If you install the JDBC driver, you must also copy the file "sqljdbc_auth.dll" to the database agent's BIN directory. This file's architecture must comply with the architecture of the Java Virtual Machine that is used. For example: If you start the agent using a JVM with an x64 architecture, the DLL must also be an x64 file.

In database jobs, you must specify a Login object that includes a suitable entry for the particular agent even if you use the Windows authentication. The Login object's user and passwordA secret combination of characters for a Automation Engine user. are neither used nor checked.

[VARIABLES]

This section contains agent variables with agent information and settings.

[CP_LIST]

List of communication processes.

This listShows entities in a grid view is created when the agent starts and extended when new communication processes are activated. More detailed information about establishing a connection is provided in the chapter Multi-Server Operation.

The communication process that has been defined in the parameter cp= (section [TCP/IP]) is not included in the cp list.

Format:
Port number
=DNS name
or
Port number
=TCP/IP address

Example of an INI File

[GLOBAL]
name=SQL01
system=UC4
language=E
logging=temp/UCXJSQLX_LOGG_##.TXT
logcount=10
max_logging_kb=1000
log_to_file=1
helplib=uc.msl


[AUTHORIZATION]
InitialPackage=
KeyStore=


[TRACE]
file=temp/UCXJSQLX_TRACE_##.TXT
trccount=10
max_trace_kb=1000
tcp/ip=0


[TCP/IP]
connect=60
cp=PC01:2217


[ORACLE]
enable_output=1
buffer_size=8000


[SQL]
connect=60
retention_time=60
type=MSSQL
retry=3
newline=1
useOraClient=0


[VARIABLES]
UC_HOST_JCL_VAR=SQL
UC_EX_PATH_JOBREPORT=temp


[CP_LIST]
2218=PC01

 

See also:

Notes for Configuration-File Adjustments

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH