/wla/Automic/Automation.Platform/ServiceManager_default/bin/../../Agents_default/unix/linux/bin/ucxj???m IPA=172.19.60.151 PNR=2300 MNR=0001 JNR=0153525908 TYP=S TXT=" Job started" TRC=0 + /wla/Automic/Automation.Platform/ServiceManager_default/bin/../../Agents_default/unix/linux/bin/ucxjlx6m IPA=172.19.60.151 PNR=2300 MNR=0001 JNR=0153525908 TYP=S 'TXT= Job started' TRC=0 ************************************************************************ ** ucxjlx6m version 12.0.2+build.1505 changelist 1495449448 ** ** JOB 153525908 (ProcID:0000022172) START AT 07.11.2019 / 12:16:01 ** ** UTC TIME 07.11.2019 / 20:16:01 ** ** TEXT=" Job started " ** ************************************************************************ . /wla/Automic/bin/Automic_env_bash + . /wla/Automic/bin/Automic_env_bash export PATH=/wla/Automic/Automation.Platform/Utility/bin:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/bin:.:/tools/jdk1.7.0_72/bin:/sbin:/usr/sbin:/usr/bin:/bin:/usr/X11R6/bin:/usr/java:/mis/XSJLINUX/bin:/usr/local/bin:/mis/XTREE/bin:/usr/ucb:/mis/XSJLINUX/etc:/wla/Automic/Automation.Platform/ServiceManager/bin ++ export PATH=/wla/Automic/Automation.Platform/Utility/bin:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/bin:.:/tools/jdk1.7.0_72/bin:/sbin:/usr/sbin:/usr/bin:/bin:/usr/X11R6/bin:/usr/java:/mis/XSJLINUX/bin:/usr/local/bin:/mis/XTREE/bin:/usr/ucb:/mis/XSJLINUX/etc:/wla/Automic/Automation.Platform/ServiceManager/bin ++ PATH=/wla/Automic/Automation.Platform/Utility/bin:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/bin:.:/tools/jdk1.7.0_72/bin:/sbin:/usr/sbin:/usr/bin:/bin:/usr/X11R6/bin:/usr/java:/mis/XSJLINUX/bin:/usr/local/bin:/mis/XTREE/bin:/usr/ucb:/mis/XSJLINUX/etc:/wla/Automic/Automation.Platform/ServiceManager/bin export LD_LIBRARY_PATH=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/lib:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ctx/lib:.:/wla/Automic/Automation.Platform/AutomationEngine/bin:/wla/Automic/Automation.Platform/ServiceManager/bin ++ export LD_LIBRARY_PATH=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/lib:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ctx/lib:.:/wla/Automic/Automation.Platform/AutomationEngine/bin:/wla/Automic/Automation.Platform/ServiceManager/bin ++ LD_LIBRARY_PATH=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/lib:/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ctx/lib:.:/wla/Automic/Automation.Platform/AutomationEngine/bin:/wla/Automic/Automation.Platform/ServiceManager/bin export ORACLE_HOME=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ ++ export ORACLE_HOME=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ ++ ORACLE_HOME=/mis/XSJLINUX/oracle/Linux2.6prod/11.2.0_64/ /wla/Automic/Automation.Platform/Utility/bin/ucybdbre -iucybdbre.ini -B -S0001 + /wla/Automic/Automation.Platform/Utility/bin/ucybdbre -iucybdbre.ini -B -S0001 ======================================================== Starting C++ batch mode loader... User account (user/domain) Startup parameter <-iucybdbre.ini -B -S0001 > Application name Launch from LoadLibrary pointer = <0x15fce20> 20191107/121601.342 - U00033105 Program 'ucybdbre' version '12.1.1+hf.3.build.390' started, start parameter: '-iucybdbre.ini -B -S0001 ', (changelist '1520334512'). 20191107/121601.342 - U00038259 Build Date: '2018-03-07', '10:46:16' 20191107/121601.343 - ---------------------------------------------------------------------------------------------------- 20191107/121601.343 - [GLOBAL] 20191107/121601.343 - LANGUAGE = (E) 20191107/121601.343 - LOGGING = ../temp/ucybdbre_log_##.txt 20191107/121601.343 - LOGCOUNT = 10 20191107/121601.343 - HELPLIB = uc.msl 20191107/121601.343 - HELPCACHE = ALL 20191107/121601.343 - DOCU_PATH = ../../Documentation/uc4/webhelp 20191107/121601.343 - 20191107/121601.343 - [REORG] 20191107/121601.343 - NO_ARCHIVE_CHECK = 0 20191107/121601.343 - AUTO_REORG = 600 20191107/121601.343 - 20191107/121601.343 - [TRACE] 20191107/121601.343 - FILE = ../temp/ucybdbre_trace_##.txt 20191107/121601.343 - TRCCOUNT = 10 20191107/121601.343 - DATABASE = 0 20191107/121601.343 - ; 0=no 20191107/121601.343 - ; 1=SQL 20191107/121601.343 - ; 2=OPC 20191107/121601.343 - ; 3=BindParam 20191107/121601.343 - ; 4=data fields 20191107/121601.343 - 20191107/121601.343 - [ODBC] 20191107/121601.343 - ; ODBCVAR xxxxxxxx 20191107/121601.343 - ; |||||||+ TYPE OF SQL-SYNTAX N=SQL-SERVER O=ORACLE D=DB2 Z=DB2/OS390 20191107/121601.343 - ; ||||||+- R=compress messages and local memory 20191107/121601.343 - ; |||||+-- O = with userid, N = without userid 20191107/121601.343 - ; ||||+--- I=OCI/CLI N=ODBC 20191107/121601.343 - ; |||+---- not used 20191107/121601.343 - ; ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!) 20191107/121601.343 - ; |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks) 20191107/121601.343 - ; +------- S = use Server-Cursor (SQL-SERVER) 20191107/121601.343 - ; 20191107/121601.343 - ; SNNNNNRN for SQL-Server either Standard-Client or Native-Client without using Mars_Connection 20191107/121601.343 - ; NNNNNNRN FOR SQL-SERVER UTILIZING NATIVE-CLIENT (MARS_CONNECTION=Yes is required) 20191107/121601.343 - ; NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface) 20191107/121601.343 - ; NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface) 20191107/121601.343 - ; 20191107/121601.343 - ; Oracle with OCI 20191107/121601.343 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=uc4prod;UID=uc4;PWD=???;SP=NLS_LENGTH_SEMANTICS=CHAR,NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 20191107/121601.343 - ; DB2 with CLI 20191107/121601.343 - ;SQLDRIVERCONNECT=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=??? 20191107/121601.343 - ---------------------------------------------------------------------------------------------------- 20191107/121601.371 - U00003545 UCUDB: Opening database ... 20191107/121601.371 - U00029112 UCUDB - Length of the DB-History area: 100 20191107/121601.676 - U00029114 UCUDB - ALTER SESSION: NLS_LENGTH_SEMANTICS=CHAR 20191107/121601.676 - U00029114 UCUDB - ALTER SESSION: NLS_LANGUAGE=AMERICAN 20191107/121601.677 - U00029114 UCUDB - ALTER SESSION: NLS_TERRITORY=AMERICA 20191107/121601.677 - U00029109 UCUDB: Local information from client environment 20191107/121601.677 - U00003535 DB INFO: 'OCI_NLS_LANGUAGE = AMERICAN' 20191107/121601.677 - U00003535 DB INFO: 'OCI_NLS_TERRITORY = AMERICA' 20191107/121601.677 - U00003535 DB INFO: 'OCI_NLS_CHARACTER_SET = WE8ISO8859P15' 20191107/121601.677 - U00029110 UCUDB - Session parameters: 20191107/121601.678 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN' 20191107/121601.678 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA' 20191107/121601.678 - U00003535 DB INFO: 'NLS_CURRENCY = $' 20191107/121601.678 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA' 20191107/121601.678 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,' 20191107/121601.678 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN' 20191107/121601.678 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR' 20191107/121601.678 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN' 20191107/121601.678 - U00003535 DB INFO: 'NLS_SORT = BINARY' 20191107/121601.678 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM' 20191107/121601.678 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM' 20191107/121601.678 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR' 20191107/121601.678 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR' 20191107/121601.678 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $' 20191107/121601.678 - U00003535 DB INFO: 'NLS_COMP = BINARY' 20191107/121601.678 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = CHAR' 20191107/121601.678 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE' 20191107/121601.678 - U00003535 DB INFO: 'SID = 52' 20191107/121601.678 - U00029111 UCUDB - Database parameters: 20191107/121601.679 - U00003535 DB INFO: 'NLS_LANGUAGE = AMERICAN' 20191107/121601.679 - U00003535 DB INFO: 'NLS_TERRITORY = AMERICA' 20191107/121601.679 - U00003535 DB INFO: 'NLS_CURRENCY = $' 20191107/121601.679 - U00003535 DB INFO: 'NLS_ISO_CURRENCY = AMERICA' 20191107/121601.679 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS = .,' 20191107/121601.679 - U00003535 DB INFO: 'NLS_CHARACTERSET = AL32UTF8' 20191107/121601.679 - U00003535 DB INFO: 'NLS_CALENDAR = GREGORIAN' 20191107/121601.679 - U00003535 DB INFO: 'NLS_DATE_FORMAT = DD-MON-RR' 20191107/121601.679 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE = AMERICAN' 20191107/121601.679 - U00003535 DB INFO: 'NLS_SORT = BINARY' 20191107/121601.679 - U00003535 DB INFO: 'NLS_TIME_FORMAT = HH.MI.SSXFF AM' 20191107/121601.679 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT = DD-MON-RR HH.MI.SSXFF AM' 20191107/121601.679 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT = HH.MI.SSXFF AM TZR' 20191107/121601.679 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH.MI.SSXFF AM TZR' 20191107/121601.679 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY = $' 20191107/121601.679 - U00003535 DB INFO: 'NLS_COMP = BINARY' 20191107/121601.679 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS = BYTE' 20191107/121601.679 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP = FALSE' 20191107/121601.679 - U00003535 DB INFO: 'NLS_NCHAR_CHARACTERSET = AL16UTF16' 20191107/121601.679 - U00003535 DB INFO: 'NLS_RDBMS_VERSION = 11.2.0.4.0' 20191107/121601.679 - U00029115 UCUDB - OPEN Database handles DB-HENV: 1b11d80 DB-HDBC: 0 20191107/121601.680 - U00003535 DB INFO: 'DATABASE-NAME = xibprd' 20191107/121601.680 - U00003535 DB INFO: 'DBMS-NAME = Oracle Database 11g Enterprise Edition' 20191107/121601.680 - U00003535 DB INFO: 'DBMS-VER = 11.2.0.4.0 - 64bit Production' 20191107/121601.680 - U00003535 DB INFO: 'ODBC-VER = ODBC not used' 20191107/121601.680 - U00003535 DB INFO: 'DRIVER-NAME = Oracle Call Interface' 20191107/121601.680 - U00003535 DB INFO: 'DRIVER-ODBC-VER =' 20191107/121601.680 - U00003535 DB INFO: 'DRIVER-VER = Compiled Mar 6 2018' 20191107/121601.680 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE =' 20191107/121601.680 - U00003535 DB INFO: 'TXN-CAPABLE =' 20191107/121601.680 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION =' 20191107/121601.680 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION =' 20191107/121601.680 - U00003535 DB INFO: 'POS-OPERATIONS =' 20191107/121601.680 - U00003535 DB INFO: 'POSITIONED-STATEMENTS =' 20191107/121601.680 - U00003535 DB INFO: 'SCROLL-CONCURRENCY =' 20191107/121601.680 - U00003535 DB INFO: 'SCROLL-OPTIONS =' 20191107/121601.680 - U00003535 DB INFO: 'STATIC-SENSITIVITY =' 20191107/121601.680 - U00003535 DB INFO: 'LOCK-TYPES =' 20191107/121601.680 - U00003535 DB INFO: 'ODBC_TRACE = 0' 20191107/121602.052 - U00003621 Version of Automation Engine database objects: '12.1.1+hf.3.build.1415' 20191107/121602.052 - U00003621 Version of Automation Engine database objects: '12.1.1+hf.3.build.1415' 20191107/121602.052 - U00021200 *********************************************ILM SETTINGS*********************************************** 20191107/121602.053 - U00021202 ILM installed N 20191107/121602.053 - U00021203 ******************************************************************************************************** 20191107/121602.053 - U00032203 Logon with user 'WLAADMIN/%'. 20191107/121602.056 - U00031221 Time zone 'XSJ.TZ' is used for this run. 20191107/121602.059 - U00032205 Logon with user 'WLAADMIN/%' was successful. 20191107/121602.188 - U00032189 Reorganization started in client '1'. 20191107/121602.188 - Messages (MELD): read: '30' days ('2019.10.07') unread: '30' days ('2019.10.07') 20191107/121602.188 - Statistics (AH): '500' days ('2018.06.24') 20191107/121602.188 - Reports (RH/RT): '70' days ('2019.08.28') 20191107/121602.188 - U00032211 VC: Disabled 20191107/121602.188 - U00032223 Collecting all running tasks for current client. 20191107/121619.987 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '17:752.679.000' 20191107/121619.988 - U00003525 UCUDB: ===> 'SELECT COUNT(*) DIVDB_INT4 FROM MELD WHERE MELD_Client = ? and MELD_Seen = 1 and Meld_DeleteFlag = 0 AND MELD_TimeStamp < ? and Meld_ArchiveFlag = 1' 20191107/121621.355 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '1:363.099.999' 20191107/121621.356 - U00003525 UCUDB: ===> 'Select Meld_Idnr from MELD WHERE MELD_Client = ? and Meld_DeleteFlag = 0 and MELD_Seen = 1 and MELD_TimeStamp < ? and Meld_ArchiveFlag = 1' 20191107/121630.966 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'READ' time: '9:036.509.000' 20191107/121646.134 - U00032190 Number of deletion flags set in table 'MELD': '43900' 20191107/121649.528 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:476.379.000' 20191107/121649.529 - 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 and AH_ArchiveFlag = 1 Order by AH_OH_Idnr, AH_TimeStamp4 DESC' 20191107/121721.118 - U00032190 Number of deletion flags set in table 'AH': '77260' 20191107/121722.572 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '1:453.524.000' 20191107/121722.572 - 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 < ? and RH_ArchiveFlag = 1' 20191107/121724.856 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2:283.389.999' 20191107/121724.856 - 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 and RH_ArchiveFlag = 1 ORDER BY AH_OH_Idnr, AH_TimeStamp4 DESC' 20191107/121813.445 - U00032190 Number of deletion flags set in table 'RH': '98692' 20191107/121813.451 - U00003523 UCUDB: Maximum time required for a DB call: '17:752.679.000'. 20191107/121813.451 - U00003522 UCUDB: Database closed. Total time for DB calls: '131:382.177.000' seconds. 20191107/121813.451 - U00003549 UCUDB: ' 290' 'OTHERS ' calls took '0:005.192.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 26' 'SELECT ' calls took '26:310.009.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 219855' 'EXECUTE ' calls took '93:809.481.999' sec. 20191107/121813.451 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 0' 'INSERT ' calls took '0:000.000.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 220533' 'READ ' calls took '10:607.743.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 220135' 'CLOSESTMT ' calls took '0:000.332.000' sec. 20191107/121813.451 - U00003549 UCUDB: ' 123' 'TRANSACT ' calls took '0:649.418.999' sec. Application return code = 0 /wla/Automic/Automation.Platform/ServiceManager_default/bin/../../Agents_default/unix/linux/bin/ucxj???m MNR=0001 IPA=172.19.60.151 JNR=0153525908 PNR=2300 TYP=E RET=$? TXT=" Job ended" TRC=0 + /wla/Automic/Automation.Platform/ServiceManager_default/bin/../../Agents_default/unix/linux/bin/ucxjlx6m MNR=0001 IPA=172.19.60.151 JNR=0153525908 PNR=2300 TYP=E RET=0 'TXT= Job ended' TRC=0 ************************************************************************ ** ucxjlx6m version 12.0.2+build.1505 changelist 1495449448 ** ** JOB 153525908 (ProcID:0000022172) ENDED AT 07.11.2019 / 12:18:13 ** ** UTC TIME 07.11.2019 / 20:18:13 ** ** TEXT=" Job ended " RETCODE=00 ** ************************************************************************