***************************************************************************
** ucxjlx6m version 12.2.4+hf.3.build.1576940312637 changelist 1576751564 **
** JOB 0057483060 (ProcID:0000016425) START AT 10.09.2020 / 05:41:28 **
** UTC TIME 10.09.2020 / 02:41:28 **
** TEXT=" Job started " **
***************************************************************************
cd /automic/Utility_1221/bin
.bash_profile loaded
running ucybdbre -B -S0500
========================================================
Starting C++ batch mode loader...
User account (user/domain)
Startup parameter <-B -S0500 >
Application name
Launch from
LoadLibrary pointer = <0xf574a0>
20200910/054128.246 - U00033105 Program 'ucybdbre' version '12.2.1+build.1539353944310' started, start parameter: '-B -S0500 ', (changelist '1539338339').
20200910/054128.246 - U00038259 Build Date: '2018-10-12', '16:29:01'
20200910/054128.247 - ----------------------------------------------------------------------------------------------------
20200910/054128.247 - ;
20200910/054128.247 - ; Automic Configuration File for Utility DB Reorg
20200910/054128.247 - ;
20200910/054128.247 -
20200910/054128.247 - [GLOBAL]
20200910/054128.247 - ;
20200910/054128.247 - ; language: The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.
20200910/054128.247 - ; if a message text is not available in the primary language the secondary language will be taken.
20200910/054128.247 - ; E - english
20200910/054128.247 - ; D - german
20200910/054128.247 - ; F - french
20200910/054128.247 - ;
20200910/054128.247 - language=(E,D)
20200910/054128.247 - ;
20200910/054128.247 - ; logging: Full file name pattern for log file names
20200910/054128.247 - ; $$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components
20200910/054128.247 - ; * is replaced by the 3 digit number of a Worker Process.
20200910/054128.247 - ; ## 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/054128.247 - ; z/OS components only:
20200910/054128.247 - ; If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.
20200910/054128.247 - ; The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):
20200910/054128.247 - ; "recfm" = (all 27 z/OS plus * and A record formats are valid)
20200910/054128.247 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
20200910/054128.247 - ; "blksize" = (0, each positive number up to 32760)
20200910/054128.247 - ; "space" = ([CYL,TRK],(prim,sec,directory))
20200910/054128.247 - ;
20200910/054128.247 - logging=../temp/ucybdbre_log_##.txt
20200910/054128.247 - ;
20200910/054128.247 - ; logCount: number of log files being kept on disk
20200910/054128.247 - ;
20200910/054128.247 - logCount=10
20200910/054128.247 - ;
20200910/054128.247 - ; helplib: name of the message text library
20200910/054128.247 - ;
20200910/054128.247 - helplib=uc.msl
20200910/054128.247 - ;
20200910/054128.247 - ; helpcache: Availability of the messages and language dependent strings.
20200910/054128.247 - ; ALL - The complete message file is held in the RAM.
20200910/054128.247 - ; NONE - Always read from the hard drive.
20200910/054128.247 - ; 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/054128.247 - ;
20200910/054128.247 - helpcache=ALL
20200910/054128.247 - ;
20200910/054128.247 - ; alloc_Size: The utility processes the data records block by block. This parameter specifies the block size (number of data records).
20200910/054128.247 - ;
20200910/054128.247 - alloc_Size=200000
20200910/054128.247 - ;
20200910/054128.247 - ; path: Start path for the component.
20200910/054128.247 - ;
20200910/054128.247 - path=.
20200910/054128.247 - ;
20200910/054128.247 - ; cmd: Command line call command for starting the component.
20200910/054128.247 - ;
20200910/054128.247 - cmd="javaw" -cp .;./lookandfeel.jar -jar ucybdbre.jar
20200910/054128.247 - ;
20200910/054128.247 - ; title: String pattern of window title for end recognition
20200910/054128.247 - ;
20200910/054128.247 - title=DB
20200910/054128.247 - ;
20200910/054128.247 - ; docu_path: The directory in which the help system is installed.
20200910/054128.247 - ;
20200910/054128.247 - docu_path=../../Documentation/uc4/webhelp
20200910/054128.247 -
20200910/054128.247 - [TRACE]
20200910/054128.247 - ;
20200910/054128.247 - ; file: The path and the file name of the trace file.
20200910/054128.247 - ; Any file name for a text file with several place holders for current system information:
20200910/054128.247 - ; $$ is replaced by server process type (WP or CP) in the context of a server process.
20200910/054128.247 - ; * is replaced by the three-digit process number in the context of a server process.
20200910/054128.247 - ; ## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.
20200910/054128.247 - ; xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).
20200910/054128.247 - ; z/OS components only:
20200910/054128.247 - ; The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:
20200910/054128.247 - ; "recfm" = (all 27 record formats of z/OS plus * and A are valid)
20200910/054128.247 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
20200910/054128.247 - ; "blksize" = (0, each positive number up to 32760)
20200910/054128.247 - ; "space" = ([CYL,TRK],(prim,sec,directory))
20200910/054128.247 - ;
20200910/054128.247 - file=../temp/ucybdbre_trace_##.txt
20200910/054128.247 - ;
20200910/054128.247 - ; trccount: Number of stored trace files
20200910/054128.247 - ;
20200910/054128.247 - trccount=10
20200910/054128.247 - ;
20200910/054128.247 - ; database: traceflags
20200910/054128.247 - ; 0 - no trace
20200910/054128.247 - ; 1 - SQL
20200910/054128.247 - ; 2 - OPC
20200910/054128.247 - ; 3 - Bind parameters
20200910/054128.247 - ; 4 - Data fields
20200910/054128.247 - ;
20200910/054128.247 - database=0
20200910/054128.247 -
20200910/054128.247 - [ODBC]
20200910/054128.247 - ;
20200910/054128.247 - ; sqlDriverConnect: Connection String for the database.
20200910/054128.247 - ; General format of the connection string is "OBDCVAR=,"
20200910/054128.247 - ;
20200910/054128.247 - ; is an eight figure command field for controlling database accesses like follows
20200910/054128.247 - ; 1. Position = N - Do not use server cursor.
20200910/054128.248 - ; 1. Position = S - Use server cursor (MS SQL Server 2000).
20200910/054128.248 - ; 2. Position = N - Do not reestablish database connection after 1000 commits.
20200910/054128.248 - ; 2. Position = D - Disconnect database after 1000 commits (perhaps due to memory problems).
20200910/054128.248 - ; 3. Position = N - Field names are compared case-sensitively (Oracle).
20200910/054128.248 - ; 3. Position = J - Field names are compared case-insensitively (Oracle).
20200910/054128.248 - ; 4. Position = N - Not used.
20200910/054128.248 - ; 5. Position = N - Type of database connection: ODBC.
20200910/054128.248 - ; 5. Position = I - Type of database connection: OCI/CLI.
20200910/054128.248 - ; 6. Position = N - Database access without User ID.
20200910/054128.248 - ; 6. Position = O - Database access with User ID.
20200910/054128.248 - ; 7. Position = N - Compression is deactivated.
20200910/054128.248 - ; 7. Position = R - Compression is activated.
20200910/054128.248 - ; 8. Position = Type of SQL Syntax; N - MS SQL Server.
20200910/054128.248 - ; 8. Position = Type of SQL Syntax; O - Oracle.
20200910/054128.248 - ; 8. Position = Type of SQL Syntax; D - DB2.
20200910/054128.248 - ; 8. Position = Type of SQL Syntax; P - PostgreSQL.
20200910/054128.248 - ;
20200910/054128.248 - ; contains standard and vendor related keywords and values
20200910/054128.248 - ; DSN - Alias name of the database connection.
20200910/054128.248 - ; UID - User ID for database access. Note that this parameter is case sensitive.
20200910/054128.248 - ; PWD - Password for database access.
20200910/054128.248 - ; ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes - Microsoft SQL Server with MARS
20200910/054128.248 - ; ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2 - Microsoft SQL Server without MARS
20200910/054128.248 - ; ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 - Oracle
20200910/054128.248 - ; ODBCVAR=NNJNIORP,host=localhost port=5432 dbname=UC4 user=modified password= connect_timeout=10 - PostgreSQL
20200910/054128.248 - ;
20200910/054128.248 - ;sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=???
20200910/054128.248 - sqlDriverConnect=ODBCVAR=NNJNIORO,DSN=ATMCDB;UID=uc4;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,commit_write='BATCH,NOWAIT'
20200910/054128.248 - [REORG]
20200910/054128.248 - ;
20200910/054128.248 - ; auto_Reorg: The maximum age of the data records in days.
20200910/054128.248 - ; 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.
20200910/054128.248 - ; 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.
20200910/054128.248 - ; 0..32767 - age in days.
20200910/054128.248 - ;
20200910/054128.248 - auto_Reorg=32
20200910/054128.248 - ;
20200910/054128.248 - ; no_Archive_Check: Archiving check.
20200910/054128.248 - ; 0 - Checks if data has been archived before.
20200910/054128.248 - ; 1 - There is no such check.
20200910/054128.248 - ;
20200910/054128.248 - no_Archive_Check=1
20200910/054128.248 - ----------------------------------------------------------------------------------------------------
20200910/054128.268 - U00003545 UCUDB: Opening database ...
20200910/054128.268 - U00029112 UCUDB - Length of the DB-History area: 100
20200910/054128.319 - U00029114 UCUDB - ALTER SESSION: NLS_LANGUAGE=AMERICAN
20200910/054128.320 - U00029114 UCUDB - ALTER SESSION: NLS_TERRITORY=AMERICA
20200910/054128.320 - U00029109 UCUDB: Local information from client environment
20200910/054128.320 - U00003535 DB INFO: 'OCI_NLS_LANGUAGE = AMERICAN'
20200910/054128.320 - U00003535 DB INFO: 'OCI_NLS_TERRITORY = AMERICA'
20200910/054128.320 - U00003535 DB INFO: 'OCI_NLS_CHARACTER_SET = WE8MSWIN1252'
20200910/054128.320 - U00029110 UCUDB - Session parameters:
20200910/054128.321 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
20200910/054128.321 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
20200910/054128.321 - U00003535 DB INFO: 'NLS_CURRENCY = $'
20200910/054128.321 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
20200910/054128.321 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
20200910/054128.321 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
20200910/054128.321 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
20200910/054128.321 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
20200910/054128.321 - U00003535 DB INFO: 'NLS_SORT = BINARY'
20200910/054128.321 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
20200910/054128.321 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
20200910/054128.321 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
20200910/054128.321 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
20200910/054128.321 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
20200910/054128.321 - U00003535 DB INFO: 'NLS_COMP = BINARY'
20200910/054128.321 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE'
20200910/054128.321 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
20200910/054128.321 - U00003535 DB INFO: 'SID = 596'
20200910/054128.321 - U00029111 UCUDB - Database parameters:
20200910/054128.323 - U00003535 DB INFO: 'NLS_RDBMS_VERSION = 12.1.0.2.0'
20200910/054128.323 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE'
20200910/054128.323 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE'
20200910/054128.323 - U00003535 DB INFO: 'NLS_COMP = BINARY'
20200910/054128.323 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $'
20200910/054128.323 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR'
20200910/054128.323 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR'
20200910/054128.323 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM'
20200910/054128.323 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM'
20200910/054128.323 - U00003535 DB INFO: 'NLS_SORT = BINARY'
20200910/054128.323 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN'
20200910/054128.323 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR'
20200910/054128.323 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN'
20200910/054128.323 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,'
20200910/054128.323 - U00003535 DB INFO: 'NLS_NCHAR_CHARACTERSET = AL16UTF16'
20200910/054128.323 - U00003535 DB INFO: 'NLS_CHARACTERSET = WE8MSWIN1252'
20200910/054128.323 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA'
20200910/054128.323 - U00003535 DB INFO: 'NLS_CURRENCY = $'
20200910/054128.323 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA'
20200910/054128.323 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN'
20200910/054128.324 - U00029115 UCUDB - OPEN Database handles DB-HENV: 1473f70 DB-HDBC: 0
20200910/054128.325 - U00003535 DB INFO: 'DATABASE-NAME = ATMCDB'
20200910/054128.325 - U00003535 DB INFO: 'DBMS-NAME = Oracle Database 12c Enterprise Edition'
20200910/054128.326 - U00003535 DB INFO: 'DBMS-VER = 12.1.0.2.0 - 64bit Production'
20200910/054128.326 - U00003535 DB INFO: 'ODBC-VER = ODBC not used'
20200910/054128.326 - U00003535 DB INFO: 'DRIVER-NAME = Oracle Call Interface'
20200910/054128.326 - U00003535 DB INFO: 'DRIVER-ODBC-VER ='
20200910/054128.326 - U00003535 DB INFO: 'DRIVER-VER = Compiled Oct 18 2018'
20200910/054128.326 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE ='
20200910/054128.326 - U00003535 DB INFO: 'TXN-CAPABLE ='
20200910/054128.326 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION ='
20200910/054128.326 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION ='
20200910/054128.326 - U00003535 DB INFO: 'POS-OPERATIONS ='
20200910/054128.326 - U00003535 DB INFO: 'POSITIONED-STATEMENTS ='
20200910/054128.326 - U00003535 DB INFO: 'SCROLL-CONCURRENCY ='
20200910/054128.326 - U00003535 DB INFO: 'SCROLL-OPTIONS ='
20200910/054128.326 - U00003535 DB INFO: 'STATIC-SENSITIVITY ='
20200910/054128.326 - U00003535 DB INFO: 'LOCK-TYPES ='
20200910/054128.326 - U00003535 DB INFO: 'ODBC_TRACE = 0'
20200910/054133.457 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '5:208.832.000'
20200910/054133.457 - U00003525 UCUDB: ===> ''
20200910/054133.458 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
20200910/054133.459 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
20200910/054133.459 - U00021200 *********************************************ILM SETTINGS***********************************************
20200910/054133.460 - U00021202 ILM installed N
20200910/054133.460 - U00021203 ********************************************************************************************************
20200910/054133.460 - U00032203 Logon with user 'AUTOMIC/%'.
20200910/054133.461 - U00031221 Time zone 'TZ.AST' is used for this run.
20200910/054133.463 - U00032205 Logon with user 'AUTOMIC/%' was successful.
20200910/054133.505 - U00032189 Reorganization started in client '500'.
20200910/054133.505 - Messages (MELD): read: '31' days ('2020.08.10') unread: '31' days ('2020.08.10')
20200910/054133.505 - Statistics (AH): '31' days ('2020.08.10')
20200910/054133.505 - Reports (RH/RT): '31' days ('2020.08.10')
20200910/054133.505 - Version Management: '31' days ('2020.08.10') Keep last 10 VC per object
20200910/054133.505 - U00032223 Collecting all running tasks for current client.
20200910/054138.847 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '5:136.835.999'
20200910/054138.847 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM MELD WHERE MELD_Client = ? and MELD_Seen = 1 and Meld_DeleteFlag = 0 AND MELD_TimeStamp < ?'
20200910/054326.491 - U00032190 Number of deletion flags set in table 'MELD': '240183'
20200910/054341.952 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '15:461.674.000'
20200910/054341.952 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM AH WHERE AH_Client = ? and AH_Deleteflag = 0 and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ?'
20200910/054432.551 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '50:598.052.000'
20200910/054432.551 - U00003525 UCUDB: ===> 'SELECT AH_Client, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr, AH_TimeStamp4, AH_ArchiveFlag FROM AH WHERE AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and AH_DeleteFlag = 0 Order by AH_OH_Idnr, AH_TimeStamp4 DESC'
20200910/054558.539 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '1:953.649.000'
20200910/054558.539 - U00003525 UCUDB: ===> 'SELECT AH_Client, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr, AH_TimeStamp4, AH_ArchiveFlag FROM AH WHERE AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and AH_DeleteFlag = 0 Order by AH_OH_Idnr, AH_TimeStamp4 DESC'
20200910/054611.300 - U00032190 Number of deletion flags set in table 'AH': '231263'
20200910/054627.618 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '16:318.249.000'
20200910/054627.618 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM RH, AH WHERE AH_Client = ? and RH_AH_Idnr = AH_Idnr and RH_Deleteflag = 0 and AH_TimeStamp4 < ?'
20200910/054642.154 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '14:535.126.999'
20200910/054642.154 - U00003525 UCUDB: ===> 'SELECT RH_AH_Idnr,RH_Type, RH_TimeStamp4, RH_ArchiveFlag, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr,AH_TimeStamp4 FROM RH, AH WHERE RH_AH_Idnr = AH_Idnr AND AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and RH_DeleteFlag = 0 ORDER BY AH_OH_Idnr, AH_TimeStamp4 DESC'
20200910/054814.186 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:631.877.999'
20200910/054814.186 - U00003525 UCUDB: ===> 'SELECT RH_AH_Idnr,RH_Type, RH_TimeStamp4, RH_ArchiveFlag, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr,AH_TimeStamp4 FROM RH, AH WHERE RH_AH_Idnr = AH_Idnr AND AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and RH_DeleteFlag = 0 ORDER BY AH_OH_Idnr, AH_TimeStamp4 DESC'
20200910/054944.008 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:532.226.999'
20200910/054944.008 - U00003525 UCUDB: ===> 'SELECT RH_AH_Idnr,RH_Type, RH_TimeStamp4, RH_ArchiveFlag, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr,AH_TimeStamp4 FROM RH, AH WHERE RH_AH_Idnr = AH_Idnr AND AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and RH_DeleteFlag = 0 ORDER BY AH_OH_Idnr, AH_TimeStamp4 DESC'
20200910/054944.535 - U00032190 Number of deletion flags set in table 'RH': '401204'
20200910/054950.350 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '5:815.044.000'
20200910/054950.350 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM OH WHERE OH_Client = ? and OH_RefIdnr > 0 and OH_Deleteflag = 2 and OH_CrDate < ? and not exists (select XAO_OH_IdnrOld from XAO where xao_oh_idnrold = OH.oh_idnr and XAO_ArchiveFlag = 0)'
20200910/054951.216 - U00032190 Number of deletion flags set in table 'OH': '0'
20200910/054952.941 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '1:724.736.999'
20200910/054952.941 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM XAO WHERE XAO_Client = ? and XAO_DeleteFlag = 0'
20200910/054955.337 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:394.839.999'
20200910/054955.337 - U00003525 UCUDB: ===> 'SELECT XAO_Client, XAO_OType, XAO_Type, XAO_Idnr, XAO_OH_Idnr, XAO_TimeStamp1, XAO_ArchiveFlag FROM XAO WHERE XAO_Client = ? and XAO_TimeStamp1 IS NOT NULL and XAO_TimeStamp1 < ? and XAO_DeleteFlag = 0 Order by XAO_OH_Idnr, XAO_TimeStamp1 DESC'
20200910/055128.937 - U00032190 Number of deletion flags set in table 'XAO': '255703'
20200910/055128.941 - U00003523 UCUDB: Maximum time required for a DB call: '50:598.052.000'.
20200910/055128.941 - U00003522 UCUDB: Database closed. Total time for DB calls: '596:047.540.000' seconds.
20200910/055128.941 - U00003549 UCUDB: ' 300' 'OTHERS ' calls took '0:003.797.999' sec.
20200910/055128.941 - U00003549 UCUDB: ' 35' 'SELECT ' calls took '120:286.213.000' sec.
20200910/055128.941 - U00003549 UCUDB: ' 1128355' 'EXECUTE ' calls took '468:481.901.999' sec.
20200910/055128.941 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec.
20200910/055128.941 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
20200910/055128.941 - U00003549 UCUDB: ' 0' 'INSERT ' calls took '0:000.000.000' sec.
20200910/055128.941 - U00003549 UCUDB: ' 1175345' 'READ ' calls took '6:270.251.000' sec.
20200910/055128.941 - U00003549 UCUDB: ' 1128645' 'CLOSESTMT ' calls took '0:000.878.999' sec.
20200910/055128.941 - U00003549 UCUDB: ' 511' 'TRANSACT ' calls took '1:004.497.000' sec.
Application return code = 0
***************************************************************************
** ucxjlx6m version 12.2.4+hf.3.build.1576940312637 changelist 1576751564 **
** JOB 0057483060 (ProcID:0000016425) ENDED AT 10.09.2020 / 05:51:28 **
** UTC TIME 10.09.2020 / 02:51:28 **
** TEXT=" Job ended " RETCODE=00 **
***************************************************************************