; ; Automic Configuration File for Utility DB Reorg ; [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. ; E - english ; D - german ; F - french ; language=(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)) ; logging=../temp/ucybdbre_log_##.txt ; ; logCount: number of log files being kept on disk ; logCount=10 ; ; helplib: name of the message text library ; helplib=uc.msl ; ; helpcache: Availability of the messages and language dependent strings. ; 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). ; helpcache=ALL ; ; alloc_Size: The utility processes the data records block by block. This parameter specifies the block size (number of data records). ; alloc_Size=200000 ; ; path: Start path for the component. ; path=. ; ; cmd: Command line call command for starting the component. ; cmd="javaw" -cp .;./lookandfeel.jar -jar ucybdbre.jar ; ; title: String pattern of window title for end recognition ; title=DB ; ; docu_path: The directory in which the help system is installed. ; docu_path=../../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)) ; file=../temp/ucybdbre_trace_##.txt ; ; trccount: Number of stored trace files ; trccount=10 ; ; database: traceflags ; 0 - no trace ; 1 - SQL ; 2 - OPC ; 3 - Bind parameters ; 4 - Data fields ; database=0 [ODBC] ; ; sqlDriverConnect: Connection String for the database. ; General format of the connection string is "OBDCVAR=," ; ; 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. ; ; 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. ; 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 - PostgreSQL ; ;sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--10BFDC349F38156A22 sqlDriverConnect=ODBCVAR=NNJNIORO,DSN=AUTOMIC;UID=modified;PWD=modified;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,commit_write='BATCH,NOWAIT' [REORG] ; ; auto_Reorg: The maximum age of the data records in days. ; All data records that are older than specified in this parameter are reorganized except the parameter no_archive_check= has been set to value "0". In this case, the utility only reorganizes the data records which have previously been archived. ; In both cases, auto_reorg= overrules the settings that are made in the utility's interface (such as the reorganization of messages that are older than n days) when fewer days are specified in the INI-file parameter. The lower value always overrules the higher value. ; 0..32767 - age in days. ; auto_Reorg=32 ; ; no_Archive_Check: Archiving check. ; 0 - Checks if data has been archived before. ; 1 - There is no such check. ; no_Archive_Check=1