Utility DB Client Copy

Structure of the INI File ucybdbcc.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\ucybdbcc_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

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" -Xmx512m -cp .;.\lookandfeel.jar -jar ucybdbcc.jar

title =

String pattern of window title for end recognition

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

Default: UCYBDBCliCpy

WorkTablePath =

The directory in which the worktable files are created.

Default: .

CommitCntDel =

The number of data records that should be deleted at once when clients are removed (only for MS SQL Server and Oracle databases).

This parameter can improve the performance of the running system during the deletion process.

Default: 0

deadlockCnt =

The maximum number of deadlocks per operation.

Default: 25

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\ucybdbcc_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

[ ENVIRONMENT ]
CLASSPATH =

Path and file name of the Jar files in the UserInterface and Java functions library.

Default: .;.\lookandfeel.jar

[ SOURCEDB ]
sqlDriverConnect =

Connection String for the database where clients should be copied from.

Same format as the connection string (SQLDRIVERCONNECT=) in ODBC Section of the Automation Engine configuration file.

Default: ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--10BFDC349F38156A22

[ TARGETDB ]
CommitCnt =

Number of database actions after which a commit to the database is necessary.

Default: 1000

sqlDriverConnect =

Connection String for the database where clients should be copied to.

Same format as the connection string (SQLDRIVERCONNECT=) in ODBC Section of the Automation Engine configuration file.

Default: ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--10BFDC349F38156A22

TargetDB =

The use of the destination database.

Values

  • 0: The destination database is the same as the source database.
  • 1: For the destination database data of the entry SQLDRIVERCONNECT= is used.

Default: 1