***************************************************************************
** ucxjlx6m version 12.2.4+hf.3.build.1576940312637 changelist 1576751564 **
** JOB 0057482089 (ProcID:0000013173) START AT 10.09.2020 / 05:15:58 **
** UTC TIME 10.09.2020 / 02:15:58 **
** TEXT=" Job started " **
***************************************************************************
cd /automic/Utility_1221/bin
.bash_profile loaded
running: ucybdbar -B -S0500
========================================================
Starting C++ batch mode loader...
User account (user/domain)
Startup parameter <-B -S0500 >
Application name
Launch from
LoadLibrary pointer = <0x1f064a0>
20200910/051558.401 - U00033125 Operating System:
20200910/051558.401 - U00033125 Operating System:
20200910/051558.401 - U00033105 Program 'ucybdbar' version '12.2.1+build.1539353944290' started, start parameter: '-B -S0500 ', (changelist '1539338296').
20200910/051558.401 - U00038259 Build Date: '2018-10-12', '16:22:35'
20200910/051558.401 - ----------------------------------------------------------------------------------------------------
20200910/051558.401 - ;
20200910/051558.401 - ; Automic Configuration File for Utility DB Archive
20200910/051558.401 - ;
20200910/051558.401 -
20200910/051558.401 - [GLOBAL]
20200910/051558.401 - ;
20200910/051558.401 - ; language: The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.
20200910/051558.401 - ; if a message text is not available in the primary language the secondary language will be taken.
20200910/051558.401 - ; E - english
20200910/051558.401 - ; D - german
20200910/051558.401 - ; F - french
20200910/051558.401 - ;
20200910/051558.401 - language=(E,D)
20200910/051558.401 - ;
20200910/051558.401 - ; logging: Full file name pattern for log file names
20200910/051558.401 - ; $$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components
20200910/051558.401 - ; * is replaced by the 3 digit number of a Worker Process.
20200910/051558.401 - ; ## 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.
20200910/051558.401 - ; z/OS components only:
20200910/051558.401 - ; If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.
20200910/051558.401 - ; The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):
20200910/051558.401 - ; "recfm" = (all 27 z/OS plus * and A record formats are valid)
20200910/051558.401 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
20200910/051558.401 - ; "blksize" = (0, each positive number up to 32760)
20200910/051558.401 - ; "space" = ([CYL,TRK],(prim,sec,directory))
20200910/051558.401 - ;
20200910/051558.401 - logging=../temp/ucybdbar_log_##.txt
20200910/051558.401 - ;
20200910/051558.401 - ; logCount: number of log files being kept on disk
20200910/051558.401 - ;
20200910/051558.401 - logCount=10
20200910/051558.401 - ;
20200910/051558.401 - ; helplib: name of the message text library
20200910/051558.401 - ;
20200910/051558.401 - helplib=uc.msl
20200910/051558.401 - ;
20200910/051558.401 - ; helpcache: Availability of the messages and language dependent strings.
20200910/051558.401 - ; ALL - The complete message file is held in the RAM.
20200910/051558.401 - ; NONE - Always read from the hard drive.
20200910/051558.401 - ; 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).
20200910/051558.401 - ;
20200910/051558.401 - helpcache=ALL
20200910/051558.401 - ;
20200910/051558.401 - ; MaxDeadlockCount:
20200910/051558.401 - ;
20200910/051558.401 - MaxDeadlockCount=2
20200910/051558.401 - ;
20200910/051558.401 - ; path: Start path for the component.
20200910/051558.401 - ;
20200910/051558.401 - path=.
20200910/051558.401 - ;
20200910/051558.401 - ; cmd: Command line call command for starting the component.
20200910/051558.401 - ;
20200910/051558.401 - cmd="javaw" -cp .;./lookandfeel.jar -jar ucybdbar.jar
20200910/051558.401 - ;
20200910/051558.401 - ; title: String pattern of window title for end recognition
20200910/051558.401 - ;
20200910/051558.401 - title=DB
20200910/051558.401 - ;
20200910/051558.402 - ; docu_path: The directory in which the help system is installed.
20200910/051558.402 - ;
20200910/051558.402 - docu_path=../../Documentation/uc4/webhelp
20200910/051558.402 -
20200910/051558.402 - [TRACE]
20200910/051558.402 - ;
20200910/051558.402 - ; file: The path and the file name of the trace file.
20200910/051558.402 - ; Any file name for a text file with several place holders for current system information:
20200910/051558.402 - ; $$ is replaced by server process type (WP or CP) in the context of a server process.
20200910/051558.402 - ; * is replaced by the three-digit process number in the context of a server process.
20200910/051558.402 - ; ## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.
20200910/051558.402 - ; xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).
20200910/051558.402 - ; z/OS components only:
20200910/051558.402 - ; The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:
20200910/051558.402 - ; "recfm" = (all 27 record formats of z/OS plus * and A are valid)
20200910/051558.402 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
20200910/051558.402 - ; "blksize" = (0, each positive number up to 32760)
20200910/051558.402 - ; "space" = ([CYL,TRK],(prim,sec,directory))
20200910/051558.402 - ;
20200910/051558.402 - file=../temp/ucybdbar_trace_##.txt
20200910/051558.402 - ;
20200910/051558.402 - ; trccount: Number of stored trace files
20200910/051558.402 - ;
20200910/051558.402 - trccount=10
20200910/051558.402 - ;
20200910/051558.402 - ; database: traceflags
20200910/051558.402 - ; 0 - no trace
20200910/051558.402 - ; 1 - SQL
20200910/051558.402 - ; 2 - OPC
20200910/051558.402 - ; 3 - Bind parameters
20200910/051558.402 - ; 4 - Data fields
20200910/051558.402 - ;
20200910/051558.402 - database=0
20200910/051558.402 -
20200910/051558.402 - [ODBC]
20200910/051558.402 - ;
20200910/051558.402 - ; sqlDriverConnect: Connection String for the database.
20200910/051558.402 - ; General format of the connection string is "OBDCVAR=,"
20200910/051558.402 - ;
20200910/051558.402 - ; is an eight figure command field for controlling database accesses like follows
20200910/051558.402 - ; 1. Position = N - Do not use server cursor.
20200910/051558.402 - ; 1. Position = S - Use server cursor (MS SQL Server 2000).
20200910/051558.402 - ; 2. Position = N - Do not reestablish database connection after 1000 commits.
20200910/051558.402 - ; 2. Position = D - Disconnect database after 1000 commits (perhaps due to memory problems).
20200910/051558.402 - ; 3. Position = N - Field names are compared case-sensitively (Oracle).
20200910/051558.402 - ; 3. Position = J - Field names are compared case-insensitively (Oracle).
20200910/051558.402 - ; 4. Position = N - Not used.
20200910/051558.402 - ; 5. Position = N - Type of database connection: ODBC.
20200910/051558.402 - ; 5. Position = I - Type of database connection: OCI/CLI.
20200910/051558.402 - ; 6. Position = N - Database access without User ID.
20200910/051558.402 - ; 6. Position = O - Database access with User ID.
20200910/051558.402 - ; 7. Position = N - Compression is deactivated.
20200910/051558.402 - ; 7. Position = R - Compression is activated.
20200910/051558.402 - ; 8. Position = Type of SQL Syntax; N - MS SQL Server.
20200910/051558.402 - ; 8. Position = Type of SQL Syntax; O - Oracle.
20200910/051558.402 - ; 8. Position = Type of SQL Syntax; D - DB2.
20200910/051558.402 - ; 8. Position = Type of SQL Syntax; P - PostgreSQL.
20200910/051558.402 - ;
20200910/051558.402 - ; contains standard and vendor related keywords and values
20200910/051558.402 - ; DSN - Alias name of the database connection.
20200910/051558.402 - ; UID - User ID for database access. Note that this parameter is case sensitive.
20200910/051558.402 - ; PWD - Password for database access.
20200910/051558.402 - ; ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes - Microsoft SQL Server with MARS
20200910/051558.402 - ; ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2 - Microsoft SQL Server without MARS
20200910/051558.402 - ; ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 - Oracle
20200910/051558.402 - ; ODBCVAR=NNJNIORP,host=localhost port=5432 dbname=UC4 user=modified password=modified connect_timeout=10 - PostgreSQL
20200910/051558.402 - ;
20200910/051558.402 - ;sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=???
20200910/051558.402 - sqlDriverConnect=ODBCVAR=NNJNIORO,DSN=ATMCDB;UID=uc4;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,commit_write='BATCH,NOWAIT'
20200910/051558.402 - [AH_BODY]
20200910/051558.402 - ;
20200910/051558.402 - ; AH_Archive1: archive key 1
20200910/051558.402 - ;
20200910/051558.402 - AH_Archive1=0
20200910/051558.402 - ;
20200910/051558.402 - ; AH_Archive2: archive key 2
20200910/051558.402 - ;
20200910/051558.402 - AH_Archive2=0
20200910/051558.402 - ;
20200910/051558.402 - ; AH_ArchiveFlag: archive flag
20200910/051558.402 - ;
20200910/051558.402 - AH_ArchiveFlag=0
20200910/051558.402 - ;
20200910/051558.402 - ; AH_Cancel: the cancel flag: M=manually
20200910/051558.402 - ;
20200910/051558.402 - AH_Cancel=1
20200910/051558.402 - ;
20200910/051558.402 - ; AH_Category: WIN_EVENT: Category
20200910/051558.403 - ;
20200910/051558.403 - AH_Category=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_CheckCount: number of checks
20200910/051558.403 - ;
20200910/051558.403 - AH_CheckCount=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_ChildCnt: children count
20200910/051558.403 - ;
20200910/051558.403 - AH_ChildCnt=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_ChildCntFail: failed children successful restarted
20200910/051558.403 - ;
20200910/051558.403 - AH_ChildCntFail=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_ChildCntFailAll: failed children total
20200910/051558.403 - ;
20200910/051558.403 - AH_ChildCntFailAll=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_ChildCntRestart: restarted children
20200910/051558.403 - ;
20200910/051558.403 - AH_ChildCntRestart=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_CodeNameDst: codetable for filetransfer
20200910/051558.403 - ;
20200910/051558.403 - AH_CodeNameDst=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_CodeNameSrc: codetable for filetransfer (sender)
20200910/051558.403 - ;
20200910/051558.403 - AH_CodeNameSrc=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_Compress: Compress level
20200910/051558.403 - ;
20200910/051558.403 - AH_Compress=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_ContainerType: object type controlled by the container
20200910/051558.403 - ;
20200910/051558.403 - AH_ContainerType=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_Count: filetransfer: bytes transfered group: number of started activities
20200910/051558.403 - ;
20200910/051558.403 - AH_Count=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_CpuTime: used CPU time
20200910/051558.403 - ;
20200910/051558.403 - AH_CpuTime=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_DeleteFlag: the delete flag
20200910/051558.403 - ;
20200910/051558.403 - AH_DeleteFlag=0
20200910/051558.403 - ;
20200910/051558.403 - ; AH_Ert: Estimated Runtime
20200910/051558.403 - ;
20200910/051558.403 - AH_Ert=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_EventSubType: event sub type
20200910/051558.403 - ;
20200910/051558.403 - AH_EventSubType=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_EventType: TT time event(timer), TS time event(time of execution)
20200910/051558.403 - ;
20200910/051558.403 - AH_EventType=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_FileNameDst: filename for filetransfer
20200910/051558.403 - ;
20200910/051558.403 - AH_FileNameDst=1
20200910/051558.403 - ;
20200910/051558.403 - ; AH_FileNameSrc: filename for filetransfer (sender)
20200910/051558.403 - ;
20200910/051558.404 - AH_FileNameSrc=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_FileSize: bytes of the complete file
20200910/051558.404 - ;
20200910/051558.404 - AH_FileSize=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_HGDst: name of agentgroup (source)
20200910/051558.404 - ;
20200910/051558.404 - AH_HGDst=0
20200910/051558.404 - ;
20200910/051558.404 - ; AH_HGSrc: name of agentgroup
20200910/051558.404 - ;
20200910/051558.404 - AH_HGSrc=0
20200910/051558.404 - ;
20200910/051558.404 - ; AH_HostDst: name of the host or agentgroup
20200910/051558.404 - ;
20200910/051558.404 - AH_HostDst=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_HostSrc: name of host (sender)
20200910/051558.404 - ;
20200910/051558.404 - AH_HostSrc=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_Info: additional information like job number
20200910/051558.404 - ;
20200910/051558.404 - AH_Info=0
20200910/051558.404 - ;
20200910/051558.404 - ; AH_InfoText: text from Agent
20200910/051558.404 - ;
20200910/051558.404 - AH_InfoText=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_IntAccount: account
20200910/051558.404 - ;
20200910/051558.404 - AH_IntAccount=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_IOCount: count of I/Os
20200910/051558.404 - ;
20200910/051558.404 - AH_IOCount=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_KernelTime: used kernel time
20200910/051558.404 - ;
20200910/051558.404 - AH_KernelTime=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_LastRP: last processed restart point
20200910/051558.404 - ;
20200910/051558.404 - AH_LastRP=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_LoginDst: name of login object
20200910/051558.404 - ;
20200910/051558.404 - AH_LoginDst=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_LoginSrc: name of login object for sender file
20200910/051558.404 - ;
20200910/051558.404 - AH_LoginSrc=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_MaxParallelHG: agentgroup max parallel
20200910/051558.404 - ;
20200910/051558.404 - AH_MaxParallelHG=0
20200910/051558.404 - ;
20200910/051558.404 - ; AH_MaxRetCode: up to this retcode the activity is ENDED_OK
20200910/051558.404 - ;
20200910/051558.404 - AH_MaxRetCode=1
20200910/051558.404 - ;
20200910/051558.404 - ; AH_MsgNr: return code
20200910/051558.404 - ;
20200910/051558.405 - AH_MsgNr=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Name: name of the object
20200910/051558.405 - ;
20200910/051558.405 - AH_Name=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_OccurCount: number of occourred events
20200910/051558.405 - ;
20200910/051558.405 - AH_OccurCount=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Operator: G = Greater L = Less E = Equal N = NotEqual
20200910/051558.405 - ;
20200910/051558.405 - AH_Operator=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_ParentAct: AH_Idnr of activator parent
20200910/051558.405 - ;
20200910/051558.405 - AH_ParentAct=0
20200910/051558.405 - ;
20200910/051558.405 - ; AH_ParentPrc: AH_Idnr of processor parent
20200910/051558.405 - ;
20200910/051558.405 - AH_ParentPrc=0
20200910/051558.405 - ;
20200910/051558.405 - ; AH_ProcessId: TSN / process id
20200910/051558.405 - ;
20200910/051558.405 - AH_ProcessId=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Records: number of records
20200910/051558.405 - ;
20200910/051558.405 - AH_Records=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_RefNr: reference job number
20200910/051558.405 - ;
20200910/051558.405 - AH_RefNr=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_RepeatType: EV: R=repeated, S=single FT: include subdirectories R=yes S=no
20200910/051558.405 - ;
20200910/051558.405 - AH_RepeatType=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Rest: . additional attributes
20200910/051558.405 - ;
20200910/051558.405 - AH_Rest=0
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Restart: was this a restarted activation?
20200910/051558.405 - ;
20200910/051558.405 - AH_Restart=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_RestartPoint: restart point from where the task was restarted
20200910/051558.405 - ;
20200910/051558.405 - AH_RestartPoint=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_RetCode: return code
20200910/051558.405 - ;
20200910/051558.405 - AH_RetCode=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Reuseagentgroup: reuse agentgroup in processflow
20200910/051558.405 - ;
20200910/051558.405 - AH_Reuseagentgroup=0
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Source: WIN_EVENT: Source
20200910/051558.405 - ;
20200910/051558.405 - AH_Source=1
20200910/051558.405 - ;
20200910/051558.405 - ; AH_Status: state of the activity
20200910/051558.406 - ;
20200910/051558.406 - AH_Status=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TaskCount: number of AJPP
20200910/051558.406 - ;
20200910/051558.406 - AH_TaskCount=0
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TExecType: EV-TS: start after 'start time' E=Execute N=NoExecute EV-TT:S=start immediately FT: 1=filetransfer with wildcard characters
20200910/051558.406 - ;
20200910/051558.406 - AH_TExecType=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TimePeriod: period in minutes or HHMM depending on the event type
20200910/051558.406 - ;
20200910/051558.406 - AH_TimePeriod=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TimePeriodTZ: Timezone for time period (event) when HHMM is used
20200910/051558.406 - ;
20200910/051558.406 - AH_TimePeriodTZ=0
20200910/051558.406 - ;
20200910/051558.406 - ; AH_ReuseHostGroup: Re-using the agent group calculation in workflows.
20200910/051558.406 - ;
20200910/051558.406 - AH_ReuseHostGroup=0
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TimeStamp1: activation time
20200910/051558.406 - ;
20200910/051558.406 - AH_TimeStamp1=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TimeStamp2: start time
20200910/051558.406 - ;
20200910/051558.406 - AH_TimeStamp2=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TimeStamp4: end time
20200910/051558.406 - ;
20200910/051558.406 - AH_TimeStamp4=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_Transferred: Transferred bytes
20200910/051558.406 - ;
20200910/051558.406 - AH_Transferred=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_TZ: Timezone for object and script
20200910/051558.406 - ;
20200910/051558.406 - AH_TZ=0
20200910/051558.406 - ;
20200910/051558.406 - ; AH_Unit: unit of AH_Wert: 0=host specific, 1 = Byte, 2=KB, 3 = MB, 4=GB, 5=TB
20200910/051558.406 - ;
20200910/051558.406 - AH_Unit=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_UserTime: used user time
20200910/051558.406 - ;
20200910/051558.406 - AH_UserTime=1
20200910/051558.406 - ;
20200910/051558.406 - ; AH_Value: value to compare
20200910/051558.406 - ;
20200910/051558.406 - AH_Value=1
20200910/051558.406 - ----------------------------------------------------------------------------------------------------
20200910/051558.426 - U00003545 UCUDB: Opening database ...
20200910/051558.426 - U00029112 UCUDB - Length of the DB-History area: 100
20200910/051558.477 - U00029114 UCUDB - ALTER SESSION: NLS_LANGUAGE=AMERICAN
20200910/051558.478 - U00029114 UCUDB - ALTER SESSION: NLS_TERRITORY=AMERICA
20200910/051558.478 - U00029109 UCUDB: Local information from client environment
20200910/051558.478 - U00003535 DB INFO: 'OCI_NLS_LANGUAGE = AMERICAN'
20200910/051558.478 - U00003535 DB INFO: 'OCI_NLS_TERRITORY = AMERICA'
20200910/051558.478 - U00003535 DB INFO: 'OCI_NLS_CHARACTER_SET = WE8MSWIN1252'
20200910/051558.478 - U00029110 UCUDB - Session parameters:
20200910/051558.479 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
20200910/051558.479 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
20200910/051558.479 - U00003535 DB INFO: 'NLS_CURRENCY = $'
20200910/051558.479 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
20200910/051558.479 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
20200910/051558.479 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
20200910/051558.479 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
20200910/051558.479 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
20200910/051558.479 - U00003535 DB INFO: 'NLS_SORT = BINARY'
20200910/051558.479 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
20200910/051558.479 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
20200910/051558.479 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
20200910/051558.479 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
20200910/051558.479 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
20200910/051558.479 - U00003535 DB INFO: 'NLS_COMP = BINARY'
20200910/051558.479 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE'
20200910/051558.479 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
20200910/051558.479 - U00003535 DB INFO: 'SID = 596'
20200910/051558.480 - U00029111 UCUDB - Database parameters:
20200910/051558.481 - U00003535 DB INFO: 'NLS_RDBMS_VERSION = 12.1.0.2.0'
20200910/051558.481 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
20200910/051558.481 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE'
20200910/051558.481 - U00003535 DB INFO: 'NLS_COMP = BINARY'
20200910/051558.481 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
20200910/051558.481 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
20200910/051558.481 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
20200910/051558.481 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
20200910/051558.481 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
20200910/051558.481 - U00003535 DB INFO: 'NLS_SORT = BINARY'
20200910/051558.481 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
20200910/051558.481 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
20200910/051558.481 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
20200910/051558.481 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
20200910/051558.481 - U00003535 DB INFO: 'NLS_NCHAR_CHARACTERSET = AL16UTF16'
20200910/051558.481 - U00003535 DB INFO: 'NLS_CHARACTERSET = WE8MSWIN1252'
20200910/051558.481 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
20200910/051558.481 - U00003535 DB INFO: 'NLS_CURRENCY = $'
20200910/051558.481 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
20200910/051558.481 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
20200910/051558.482 - U00029115 UCUDB - OPEN Database handles DB-HENV: 2422ef0 DB-HDBC: 0
20200910/051558.482 - U00003535 DB INFO: 'DATABASE-NAME = ATMCDB'
20200910/051558.483 - U00003535 DB INFO: 'DBMS-NAME = Oracle Database 12c Enterprise Edition'
20200910/051558.483 - U00003535 DB INFO: 'DBMS-VER = 12.1.0.2.0 - 64bit Production'
20200910/051558.483 - U00003535 DB INFO: 'ODBC-VER = ODBC not used'
20200910/051558.483 - U00003535 DB INFO: 'DRIVER-NAME = Oracle Call Interface'
20200910/051558.483 - U00003535 DB INFO: 'DRIVER-ODBC-VER ='
20200910/051558.483 - U00003535 DB INFO: 'DRIVER-VER = Compiled Oct 18 2018'
20200910/051558.483 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE ='
20200910/051558.483 - U00003535 DB INFO: 'TXN-CAPABLE ='
20200910/051558.483 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION ='
20200910/051558.483 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION ='
20200910/051558.483 - U00003535 DB INFO: 'POS-OPERATIONS ='
20200910/051558.483 - U00003535 DB INFO: 'POSITIONED-STATEMENTS ='
20200910/051558.483 - U00003535 DB INFO: 'SCROLL-CONCURRENCY ='
20200910/051558.483 - U00003535 DB INFO: 'SCROLL-OPTIONS ='
20200910/051558.483 - U00003535 DB INFO: 'STATIC-SENSITIVITY ='
20200910/051558.483 - U00003535 DB INFO: 'LOCK-TYPES ='
20200910/051558.483 - U00003535 DB INFO: 'ODBC_TRACE = 0'
20200910/051558.484 - U00003532 UCUDB: Checking data source ...
20200910/051606.662 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '384071909'/'150 (1000/6.661745 s)'
20200910/051606.662 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470
20200910/051609.891 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '11:484.648.999'
20200910/051609.891 - U00003525 UCUDB: ===> ''
20200910/051609.892 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
20200910/051609.893 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
20200910/051609.905 - U00032203 Logon with user 'AUTOMIC/%'.
20200910/051609.906 - U00031221 Time zone 'TZ.AST' is used for this run.
20200910/051609.907 - U00032205 Logon with user 'AUTOMIC/%' was successful.
20200910/051610.158 - U00031113 Archiving in client '500' started.
20200910/051610.158 - Messages (MELD): read: '31' days ('2020.08.10 03:00:00') unread: '31' days ('2020.08.10 03:00:00')
20200910/051610.158 - Statistics (AH/RH): '31' days ('2020.08.10 03:00:00')
20200910/051610.158 - U00031203 Archive path: '/automic/Archived_data'
20200910/051610.158 - U00031205 Archive MB size: 650
20200910/051610.158 - U00031204 Date/Time format: 'Y.m.d H:M:S'
20200910/051610.158 - U00031145 Creating new archive folder: '/automic/Archived_data/0500/UC_ARCHIV_20200910_956/'
20200910/051610.308 - U00031120 Number of archived records in table 'OH':'74'
20200910/051614.815 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '4:493.875.000'
20200910/051614.815 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM Meld where Meld_ArchiveFlag = 0 and Meld_DeleteFlag = 0 and Meld_Client = ? and ((MELD_TimeStamp < ? AND MELD_Seen = 1) or (MELD_TimeStamp < ? AND MELD_Seen = 0))'
20200910/052132.024 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '2:168.162.000'
20200910/052132.024 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM Meld where Meld_ArchiveFlag = 0 and Meld_DeleteFlag = 0 and Meld_Client = ? and ((MELD_TimeStamp < ? AND MELD_Seen = 1) or (MELD_TimeStamp < ? AND MELD_Seen = 0))'
20200910/052228.866 - U00031120 Number of archived records in table 'MELD':'235916'
20200910/052230.529 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '1:650.748.000'
20200910/052230.529 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM AH where AH_ArchiveFlag = 0 and AH_DeleteFlag = 0 and AH_Client = ? and AH_TimeStamp4 < ?'
20200910/052232.483 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '1:953.475.999'
20200910/052232.483 - U00003525 UCUDB: ===> 'select AH_Idnr, AH_TimeStamp4 from AH where AH_ArchiveFlag = 0 and AH_DeleteFlag = 1 and AH_Client = ? union select AH_Idnr, AH_TimeStamp4 from AH where AH_ArchiveFlag = 0 and AH_DeleteFlag = 0 and AH_Client = ? and AH_TimeStamp4 < ? order by AH_TimeStamp4'
20200910/052858.215 - U00031120 Number of archived records in table 'AH':'127020'
20200910/052916.890 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '18:672.927.999'
20200910/052916.890 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM RH, AH where RH_AH_Idnr = AH_Idnr and AH_Client = ? and RH_ArchiveFlag = 0 and RH_DeleteFlag = 0 and AH_TimeStamp4 < ?'
20200910/052924.389 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '7:498.313.999'
20200910/052924.389 - U00003525 UCUDB: ===> 'select RH_AH_Idnr, AH_TimeStamp4, RH_Type from RH, AH where RH_AH_Idnr = AH_Idnr and RH_DeleteFlag = 1 and RH_ArchiveFlag = 0 and RH_Client = ? union select RH_AH_Idnr, AH_TimeStamp4, RH_Type from RH, AH where RH_AH_Idnr = AH_Idnr and AH_Client = ? and RH_ArchiveFlag = 0 and RH_DeleteFlag = 0 and AH_TimeStamp4 < ? order by AH_TimeStamp4'
20200910/053757.679 - U00031145 Creating new archive folder: '/automic/Archived_data/0500/UC_ARCHIV_20200910_957/'
20200910/054037.406 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:143.132.000'
20200910/054037.406 - U00003525 UCUDB: ===> 'select RH_AH_Idnr, AH_TimeStamp4, RH_Type from RH, AH where RH_AH_Idnr = AH_Idnr and RH_DeleteFlag = 1 and RH_ArchiveFlag = 0 and RH_Client = ? union select RH_AH_Idnr, AH_TimeStamp4, RH_Type from RH, AH where RH_AH_Idnr = AH_Idnr and AH_Client = ? and RH_ArchiveFlag = 0 and RH_DeleteFlag = 0 and AH_TimeStamp4 < ? order by AH_TimeStamp4'
20200910/054127.848 - U00031120 Number of archived records in table 'RH':'216268'
20200910/054127.861 - U00003523 UCUDB: Maximum time required for a DB call: '18:672.927.999'.
20200910/054127.861 - U00003522 UCUDB: Database closed. Total time for DB calls: '1380:532.729.994' seconds.
20200910/054127.861 - U00003549 UCUDB: ' 924972' 'OTHERS ' calls took '0:004.137.000' sec.
20200910/054127.861 - U00003549 UCUDB: ' 922699' 'SELECT ' calls took '563:299.039.000' sec.
20200910/054127.861 - U00003549 UCUDB: ' 579280' 'EXECUTE ' calls took '278:826.430.999' sec.
20200910/054127.861 - U00003549 UCUDB: ' 9' 'UPDATE ' calls took '0:007.750.000' sec.
20200910/054127.861 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
20200910/054127.861 - U00003549 UCUDB: ' 0' 'INSERT ' calls took '0:000.000.000' sec.
20200910/054127.861 - U00003549 UCUDB: ' 7694385' 'READ ' calls took '188:835.008.994' sec.
20200910/054127.861 - U00003549 UCUDB: ' 1505255' 'CLOSESTMT ' calls took '26:094.155.999' sec.
20200910/054127.861 - U00003549 UCUDB: ' 925253' 'TRANSACT ' calls took '323:466.208.000' sec.
Application return code = 0
***************************************************************************
** ucxjlx6m version 12.2.4+hf.3.build.1576940312637 changelist 1576751564 **
** JOB 0057482089 (ProcID:0000013173) ENDED AT 10.09.2020 / 05:41:27 **
** UTC TIME 10.09.2020 / 02:41:27 **
** TEXT=" Job ended " RETCODE=00 **
***************************************************************************