Utility DB Archive

Structure of the INI File ucybdbar.ini

Parameter Name Description
[ GLOBAL ]
language =

The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.

if a message text is not available in the primary language the secondary language will be taken.

Values

  • E: english
  • D: german
  • F: french

Default: (E,D)

logging =

Full file name pattern for log file names

$$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components

* is replaced by the 3 digit number of a Worker Process.

## is replaced by the log file sequence number after the existing log files' corresponding numbers have been raised by one during startup of the component.

z/OS components only:

If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.

The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):

"recfm" = (all 27 z/OS plus * and A record formats are valid)

"lrecl" = (0, each positive number up to 32760 and X for each reclen)

"blksize" = (0, each positive number up to 32760)

"space" = ([CYL,TRK],(prim,sec,directory))

AE and Java components only:

Logging to standard output can be enabled by setting the value to CON:

For relative path indications the system uses the installation directory when creating files.

For BS2000/OSD Operation System the name may be specified with or without User ID. If without User ID the log file is written to the user ID under which the component has been started

Default: ..\temp\ucybdbar_log_##.txt

logCount =

number of log files being kept on disk

Default: 10

helplib =

name of the message text library

may have different names dependent on platform rules.

Default: uc.msl

helpcache =

Availability of the messages and language dependent strings.

Values

  • ALL: The complete message file is held in the RAM.
  • NONE: Always read from the hard drive.
  • CONTROLS: All language dependant strings that are necessary in order to display the dialog program are held in the RAM (not relevant for the Automation Engine).

Default: ALL

MaxDeadlockCount =

The maximum number of deadlocks per database operation.

Default: 2

path =

Start path for the component.

Default: .

cmd =

Command line call command for starting the component.

For the explanation of the command line arguments refer to http://docs.oracle.com/javase/7/docs/technotes/tools/windows/java.html

Default: "javaw" -cp .;.\lookandfeel.jar -jar ucybdbar.jar

title =

String pattern of window title for end recognition

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

Default: DB

docu_path =

The directory in which the help system is installed.

Default: ..\..\Documentation\uc4\webhelp

[ TRACE ]
file =

The path and the file name of the trace file.

Any file name for a text file with several place holders for current system information:

$$ is replaced by server process type (WP or CP) in the context of a server process.

* is replaced by the three-digit process number in the context of a server process.

## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.

xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).

z/OS components only:

The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:

"recfm" = (all 27 record formats of z/OS plus * and A are valid)

"lrecl" = (0, each positive number up to 32760 and X for each reclen)

"blksize" = (0, each positive number up to 32760)

"space" = ([CYL,TRK],(prim,sec,directory))

AE and Java components only:

Tracing to standard output can be enabled by setting the value to CON:

Currently the External Monitoring Interface (EMI) does not produce any trace regardless of the settings here.

For BS2000/OSD the name might be specified with or without user ID. If without the trace file is written to the user ID under which the component has been started.

Default: ..\temp\ucybdbar_trace_##.txt

trccount =

Number of stored trace files

Default: 10

database =

traceflags

Values

  • 0: no trace
  • 1: SQL
  • 2: OPC
  • 3: Bind parameters
  • 4: Data fields

Default: 0

[ ODBC ]
sqlDriverConnect =

Connection String for the database.

General format of the connection string is "OBDCVAR=<cmd>,<odbc-string>"

Maximum length: 256 characters

<cmd> is an eight figure command field for controlling database accesses like follows

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.

8. Position = Type of SQL Syntax; P - PostgreSQL.

<odbc-string> contains standard and vendor related keywords and values

DSN - Alias name of the database connection.

UID - User ID for database access. Note that this parameter is case sensitive.

PWD - Password for database access.

For Microsoft SQL Server only: Connection String can be extended with MARS Connection setting. We strongly recommend to set Mars_Connection=Yes.

For Oracle only: Code page settings must correspond to those of the database. Either use the environment variable NLS_LANG or extend the connection string with Session Parameters like this: "SP=NLS_LANGUAGE=language,NLS_TERRITORY=area,CODESET=character set,RECONNECT=interval"

Values

  • ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes: Microsoft SQL Server with MARS
  • ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2: Microsoft SQL Server without MARS
  • ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15: Oracle
  • ODBCVAR=NNJNIORP,host=localhost port=5432 dbname=UC4 user=UC4 password=--1037B2E22BF022EBE2 connect_timeout=10 client_encoding=LATIN9: PostgreSQL

Default: ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--10BFDC349F38156A22;Mars_Connection=Yes

[ AH_BODY ]
AH_Archive1 =

archive key 1

Default: 0

AH_Archive2 =

archive key 2

Default: 0

AH_ArchiveFlag =

archive flag

Default: 0

AH_Cancel =

the cancel flag: M=manually

Default: 1

AH_Category =

WIN_EVENT: Category

Default: 1

AH_CheckCount =

number of checks

Default: 1

AH_ChildCnt =

children count

Default: 0

AH_ChildCntFail =

failed children successful restarted

Default: 0

AH_ChildCntFailAll =

failed children total

Default: 0

AH_ChildCntRestart =

restarted children

Default: 0

AH_CodeNameDst =

codetable for file transfer

Default: 1

AH_CodeNameSrc =

codetable for file transfer (sender)

Default: 1

AH_Compress =

Compress level

Default: 1

AH_ContainerType =

object type controlled by the container

Default: 0

AH_Count =

file transfer: bytes transfered group: number of started activities

Default: 1

AH_CpuTime =

used CPU time

Default: 1

AH_DeleteFlag =

the delete flag

Default: 0

AH_Ert =

Estimated Runtime

Default: 1

AH_EventSubType =

event sub type

Default: 1

AH_EventType =

TT time event(timer), TS time event(time of execution)

Default: 1

AH_FileNameDst =

filename for file transfer

Default: 1

AH_FileNameSrc =

filename for file transfer (sender)

Default: 1

AH_FileSize =

bytes of the complete file

Default: 1

AH_HGDst =

name of agentgroup (source)

Default: 0

AH_HGSrc =

name of agentgroup

Default: 0

AH_HostDst =

name of the host or agentgroup

Default: 1

AH_HostSrc =

name of host (sender)

Default: 1

AH_Info =

additional information like job number

Default: 0

AH_InfoText =

text from Agent

Default: 1

AH_IntAccount =

account

Default: 1

AH_IOCount =

count of I/Os

Default: 1

AH_KernelTime =

used kernel time

Default: 1

AH_LastRP =

last processed restart point

Default: 1

AH_LoginDst =

name of login object

Default: 1

AH_LoginSrc =

name of login object for sender file

Default: 1

AH_MaxParallelHG =

agentgroup max parallel

Default: 0

AH_MaxRetCode =

up to this retcode the activity is ENDED_OK

Default: 1

AH_MsgNr =

return code

Default: 1

AH_Name =

name of the object

Default: 1

AH_OccurCount =

number of occourred events

Default: 1

AH_Operator =

G = Greater L = Less E = Equal N = NotEqual

Default: 1

AH_ParentAct =

AH_Idnr of activator parent

Default: 0

AH_ParentPrc =

AH_Idnr of processor parent

Default: 0

AH_ProcessId =

TSN / process id

Default: 1

AH_Records =

number of records

Default: 1

AH_RefNr =

reference job number

Default: 1

AH_RepeatType =

EV: R=repeated, S=single FT: include subdirectories R=yes S=no

Default: 1

AH_Rest =

. additional attributes

Default: 0

AH_Restart =

was this a restarted activation?

Default: 1

AH_RestartPoint =

restart point from where the task was restarted

Default: 1

AH_RetCode =

return code

Default: 1

AH_Reuseagentgroup =

reuse agentgroup in processflow

Default: 0

AH_Source =

WIN_EVENT: Source

Default: 1

AH_Status =

state of the activity

Default: 1

AH_TaskCount =

number of AJPP

Default: 0

AH_TExecType =

EV-TS: start after 'start time' E=Execute N=NoExecute EV-TT:S=start immediately FT: 1=file transfer with wildcard characters

Default: 1

AH_TimePeriod =

period in minutes or HHMM depending on the event type

Default: 1

AH_TimePeriodTZ =

Timezone for time period (event) when HHMM is used

Default: 0

AH_ReuseHostGroup =

Re-using the agent group calculation in workflows.

Default: 0

AH_TimeStamp1 =

activation time

Default: 1

AH_TimeStamp2 =

start time

Default: 1

AH_TimeStamp4 =

end time

Default: 1

AH_Transferred =

Transferred bytes

Default: 1

AH_TZ =

Timezone for object and script

Default: 0

AH_Unit =

unit of AH_Wert: 0=host specific, 1 = Byte, 2=KB, 3 = MB, 4=GB, 5=TB

Default: 1

AH_UserTime =

used user time

Default: 1

AH_Value =

value to compare

Default: 1