*************************************************************************** ** 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 ** ***************************************************************************