Automic Workload Automation

  • Private Community
 View Only

  • 1.  House keeping job is running but still old reports are available in the system

    Posted Jan 30, 2020 04:52 PM
    Edited by Maria Joseph Vimalan Jan 30, 2020 04:53 PM
    Dear Experts,

    We have configured UC_UTILITY_REORG as below

    AH TRUE 0005 TRUE 0005
    MELD TRUE 0045 0045
    OBJECT AUDIT FALSE 0045 TRUE
    RH TRUE 0005 TRUE 0005
    VERSION_CONTROL TRUE 0010 FALSE 0000

    As per the document, all reports should be removed from the database every 5 days. However , we are noticing the reports and stats available for a month.
    The reorg job is running without any errors. Any possible reason for it ?

    Attached is the content of the log file.

    UNLOAD LOG
    D:\Automic_Engine\Utility\bin>D:\Automic_Engine\Agents\Windows\bin\UCXJWX6M.EXE JNR=0171956604 MNR=0001 PNR=32335 IPA=172.28.146.89 TYP=S TXT=" Job started"
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' started
    UCMDJP: *********************************************************************
    UCMDJP: ** JOB 0171956604 (ProcID:0000001000) START AT 30.01.2020/22:00:23 **
    UCMDJP: ** UTC TIME 30.01.2020/21:00:23 **
    UCMDJP: ** --------------------------------------------------------------- **
    UCMDJP: ** USED: 0.000 CPU **
    UCMDJP: *********************************************************************
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' terminated normally

    D:\Automic_Engine\Utility\bin>ucybdbun -BREORG -S0001
    20200130/220023.670 - U00033125 Operating System: <UC4_ON_WIN64>
    20200130/220023.670 - U00038002 DLL 'ucybdbun', version '12.2.1+build.1539353944323'. Start parameter: '-BREORG -S0001 ', (changelist '1539338384').
    20200130/220023.670 - U00038259 Build Date: '2018-10-12', '16:23:16'
    20200130/220023.670 - ----------------------------------------------------------------------------------------------------
    20200130/220023.670 - ;
    20200130/220023.670 - ; Automic Configuration File for Utility DB Unload
    20200130/220023.686 - ;
    20200130/220023.686 -
    20200130/220023.686 - [GLOBAL]
    20200130/220023.686 - ;
    20200130/220023.686 - ; language: The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.
    20200130/220023.686 - ; if a message text is not available in the primary language the secondary language will be taken.
    20200130/220023.686 - ; E - english
    20200130/220023.686 - ; D - german
    20200130/220023.686 - ; F - french
    20200130/220023.686 - ;
    20200130/220023.686 - language=(E,D)
    20200130/220023.686 - ;
    20200130/220023.686 - ; logging: Full file name pattern for log file names
    20200130/220023.686 - ; $$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components
    20200130/220023.686 - ; * is replaced by the 3 digit number of a Worker Process.
    20200130/220023.686 - ; ## 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.
    20200130/220023.686 - ; z/OS components only:
    20200130/220023.686 - ; If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.
    20200130/220023.686 - ; The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):
    20200130/220023.686 - ; "recfm" = (all 27 z/OS plus * and A record formats are valid)
    20200130/220023.686 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    20200130/220023.686 - ; "blksize" = (0, each positive number up to 32760)
    20200130/220023.686 - ; "space" = ([CYL,TRK],(prim,sec,directory))
    20200130/220023.686 - ;
    20200130/220023.686 - logging=..\temp\ucybdbun_log_##.txt
    20200130/220023.686 - ;
    20200130/220023.686 - ; logCount: number of log files being kept on disk
    20200130/220023.686 - ;
    20200130/220023.686 - logCount=10
    20200130/220023.686 - ;
    20200130/220023.686 - ; helplib: name of the message text library
    20200130/220023.686 - ;
    20200130/220023.686 - helplib=uc.msl
    20200130/220023.686 - ;
    20200130/220023.686 - ; helpcache: Availability of the messages and language dependent strings.
    20200130/220023.686 - ; ALL - The complete message file is held in the RAM.
    20200130/220023.686 - ; NONE - Always read from the hard drive.
    20200130/220023.686 - ; 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).
    20200130/220023.686 - ;
    20200130/220023.686 - helpcache=ALL
    20200130/220023.686 - ;
    20200130/220023.686 - ; reorg_Commit_sleep: The waiting time in milliseconds after the data records have been deleted.
    20200130/220023.686 - ; This specification can be used to avoid that the database is permanently blocked. The number of data records is defined with CommitCount=.
    20200130/220023.686 - ;
    20200130/220023.686 - reorg_Commit_sleep=100
    20200130/220023.686 - ;
    20200130/220023.686 - ; output: The path and the name of the file that contains the unloaded data.
    20200130/220023.686 - ;
    20200130/220023.686 - output=..\db\uc_data.txt
    20200130/220023.686 - ;
    20200130/220023.686 - ; path: Start path for the component.
    20200130/220023.686 - ;
    20200130/220023.686 - path=.
    20200130/220023.686 - ;
    20200130/220023.686 - ; cmd: Command line call command for starting the component.
    20200130/220023.686 - ;
    20200130/220023.686 - cmd="javaw" -cp .;.\lookandfeel.jar -jar ucybdbun.jar
    20200130/220023.686 - ;
    20200130/220023.686 - ; title: String pattern of window title for end recognition
    20200130/220023.686 - ;
    20200130/220023.686 - title=UCYBDBUn
    20200130/220023.686 - ;
    20200130/220023.686 - ; CommitCount: The number of data records that should be deleted at once.
    20200130/220023.686 - ;
    20200130/220023.686 - CommitCount=100
    20200130/220023.686 - ;
    20200130/220023.686 - ; docu_path: The directory in which the help system is installed.
    20200130/220023.686 - ;
    20200130/220023.686 - docu_path=..\..\Documentation\uc4\webhelp
    20200130/220023.686 -
    20200130/220023.686 - [TRACE]
    20200130/220023.686 - ;
    20200130/220023.686 - ; file: The path and the file name of the trace file.
    20200130/220023.686 - ; Any file name for a text file with several place holders for current system information:
    20200130/220023.686 - ; $$ is replaced by server process type (WP or CP) in the context of a server process.
    20200130/220023.686 - ; * is replaced by the three-digit process number in the context of a server process.
    20200130/220023.686 - ; ## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.
    20200130/220023.686 - ; xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).
    20200130/220023.686 - ; z/OS components only:
    20200130/220023.686 - ; The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:
    20200130/220023.686 - ; "recfm" = (all 27 record formats of z/OS plus * and A are valid)
    20200130/220023.686 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    20200130/220023.686 - ; "blksize" = (0, each positive number up to 32760)
    20200130/220023.686 - ; "space" = ([CYL,TRK],(prim,sec,directory))
    20200130/220023.686 - ;
    20200130/220023.686 - file=..\temp\ucybdbun_trace_##.txt
    20200130/220023.686 - ;
    20200130/220023.686 - ; trccount: Number of stored trace files
    20200130/220023.686 - ;
    20200130/220023.686 - trccount=10
    20200130/220023.686 - ;
    20200130/220023.686 - ; database: traceflags
    20200130/220023.686 - ; 0 - no trace
    20200130/220023.686 - ; 1 - SQL
    20200130/220023.686 - ; 2 - OPC
    20200130/220023.686 - ; 3 - Bind parameters
    20200130/220023.686 - ; 4 - Data fields
    20200130/220023.686 - ;
    20200130/220023.686 - database=0
    20200130/220023.686 - ;
    20200130/220023.686 - ; level: traceflag
    20200130/220023.686 - ; 0 - no
    20200130/220023.686 - ; 1 - Basic trace
    20200130/220023.686 - ; 2 - Function level
    20200130/220023.686 - ; 3 - Section Level
    20200130/220023.686 - ; 4 - Everything
    20200130/220023.686 - ;
    20200130/220023.686 - level=4
    20200130/220023.686 -
    20200130/220023.686 - [ODBC]
    20200130/220023.686 - ;
    20200130/220023.686 - ; sqlDriverConnect: Connection String for the database.
    20200130/220023.686 - ; General format of the connection string is "OBDCVAR=<cmd>,<odbc-string>"
    20200130/220023.686 - ;
    20200130/220023.686 - ; <cmd> is an eight figure command field for controlling database accesses like follows
    20200130/220023.686 - ; 1. Position = N - Do not use server cursor.
    20200130/220023.686 - ; 1. Position = S - Use server cursor (MS SQL Server 2000).
    20200130/220023.686 - ; 2. Position = N - Do not reestablish database connection after 1000 commits.
    20200130/220023.686 - ; 2. Position = D - Disconnect database after 1000 commits (perhaps due to memory problems).
    20200130/220023.686 - ; 3. Position = N - Field names are compared case-sensitively (Oracle).
    20200130/220023.686 - ; 3. Position = J - Field names are compared case-insensitively (Oracle).
    20200130/220023.686 - ; 4. Position = N - Not used.
    20200130/220023.686 - ; 5. Position = N - Type of database connection: ODBC.
    20200130/220023.686 - ; 5. Position = I - Type of database connection: OCI/CLI.
    20200130/220023.686 - ; 6. Position = N - Database access without User ID.
    20200130/220023.686 - ; 6. Position = O - Database access with User ID.
    20200130/220023.686 - ; 7. Position = N - Compression is deactivated.
    20200130/220023.686 - ; 7. Position = R - Compression is activated.
    20200130/220023.686 - ; 8. Position = Type of SQL Syntax; N - MS SQL Server.
    20200130/220023.686 - ; 8. Position = Type of SQL Syntax; O - Oracle.
    20200130/220023.686 - ; 8. Position = Type of SQL Syntax; D - DB2.
    20200130/220023.686 - ;
    20200130/220023.686 - ; <odbc-string> contains standard and vendor related keywords and values
    20200130/220023.686 - ; DSN - Alias name of the database connection.
    20200130/220023.686 - ; UID - User ID for database access. Note that this parameter is case sensitive.
    20200130/220023.686 - ; PWD - Password for database access.
    20200130/220023.686 - ; ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes - Microsoft SQL Server with MARS
    20200130/220023.686 - ; ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2 - Microsoft SQL Server without MARS
    20200130/220023.686 - ; ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 - Oracle
    20200130/220023.686 - ;
    20200130/220023.686 - sqlDriverConnect=ODBCVAR=NNNNNNRN,DSN=DEV;UID=UM13_Admin;PWD=???;Mars_Connection=Yes
    20200130/220023.686 -
    20200130/220023.686 -
    20200130/220023.686 - [ENVIRONMENT]
    20200130/220023.686 - ;
    20200130/220023.686 - ; CLASSPATH: Path and file name of the Jar files in the UserInterface and Java functions library.
    20200130/220023.686 - ;
    20200130/220023.686 - CLASSPATH=.;.\lookandfeel.jar
    20200130/220023.686 -
    20200130/220023.686 - [REORG]
    20200130/220023.686 - ;
    20200130/220023.686 - ; max_Deadlock: The maximum number of deadlocks per operation
    20200130/220023.686 - ;
    20200130/220023.686 - max_Deadlock=100
    20200130/220023.686 - ;
    20200130/220023.686 - ; no_Archive_Check: Archiving check.
    20200130/220023.686 - ; 0 - Checks if data has been archived before.
    20200130/220023.686 - ; 1 - There is no such check.
    20200130/220023.686 - ;
    20200130/220023.686 - no_Archive_Check=1
    20200130/220023.686 - ;
    20200130/220023.686 - ; reorg_Chunk_Size: The number of data records of the relevant top table (such as "AH") that should be deleted per transaction including all its corresponding entries in sub-tables.
    20200130/220023.686 - ; 50..5000 -
    20200130/220023.686 - ;
    20200130/220023.686 - reorg_Chunk_Size=1000
    20200130/220023.686 - ;
    20200130/220023.686 - ; reorg_Sleep_Time: The waiting time in milliseconds that the system should wait after each deletion transaction.
    20200130/220023.686 - ; 0..10000 -
    20200130/220023.686 - ;
    20200130/220023.686 - reorg_Sleep_Time=0
    20200130/220023.686 -
    20200130/220023.686 - [TRANSPORT]
    20200130/220023.686 - ;
    20200130/220023.686 - ; all_Entities: The setting for the scope of the unloaded data in the Transport Case.
    20200130/220023.686 - ; This setting is important if the unloaded data is subsequently changed by using AE DB Change.
    20200130/220023.686 - ; 0 - Only object attributes that contain a value are exported.
    20200130/220023.686 - ; 1 - The utility exports all object attributes regardless of their contents.
    20200130/220023.686 - ;
    20200130/220023.686 - all_Entities=0
    20200130/220023.686 - ----------------------------------------------------------------------------------------------------
    20200130/220023.686 - U00003545 UCUDB: Opening database ...
    20200130/220023.686 - U00029112 UCUDB - Length of the DB-History area: 100
    20200130/220023.717 - U00003592 UCUDB - Status: '01000' Native error: '5701' Msg: 'Changed database context to 'DEV'.'
    20200130/220023.717 - U00003592 UCUDB - Status: '01000' Native error: '5703' Msg: 'Changed language setting to us_english.'
    20200130/220023.717 - U00029115 UCUDB - OPEN Database handles DB-HENV: 19b6160 DB-HDBC: 19b6240
    20200130/220023.717 - U00003535 DB INFO: 'DATABASE-NAME = DEV'
    20200130/220023.717 - U00003535 DB INFO: 'DBMS-NAME = Microsoft SQL Server'
    20200130/220023.717 - U00003535 DB INFO: 'DBMS-VER = 13.00.5598'
    20200130/220023.717 - U00003535 DB INFO: 'ODBC-VER = 03.80.0000'
    20200130/220023.717 - U00003535 DB INFO: 'DRIVER-NAME = msodbcsql13.dll'
    20200130/220023.717 - U00003535 DB INFO: 'DRIVER-ODBC-VER = 03.80'
    20200130/220023.717 - U00003535 DB INFO: 'DRIVER-VER = 13.00.0811'
    20200130/220023.717 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE = 2'
    20200130/220023.717 - U00003535 DB INFO: 'TXN-CAPABLE = 2'
    20200130/220023.717 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION = 2'
    20200130/220023.717 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION = 0000000000101111B ( 47)'
    20200130/220023.717 - U00003535 DB INFO: 'POS-OPERATIONS = 0000000000011111B ( 31)'
    20200130/220023.717 - U00003535 DB INFO: 'POSITIONED-STATEMENTS = 0000000000000111B ( 7)'
    20200130/220023.717 - U00003535 DB INFO: 'SCROLL-CONCURRENCY = 0000000000001111B ( 15)'
    20200130/220023.717 - U00003535 DB INFO: 'SCROLL-OPTIONS = 0000000000010111B ( 23)'
    20200130/220023.717 - U00003535 DB INFO: 'STATIC-SENSITIVITY = 0000000000000101B ( 5)'
    20200130/220023.717 - U00003535 DB INFO: 'LOCK-TYPES = 0000000000000001B ( 1)'
    20200130/220023.717 - U00003535 DB INFO: 'ODBC_TRACE = 0'
    20200130/220023.732 - U00003532 UCUDB: Checking data source ...
    20200130/220026.607 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '66223949'/'620 (1000/1.612034 s)'
    20200130/220026.607 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470
    20200130/220026.874 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '3:194.895.785'
    20200130/220026.874 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
    20200130/220027.078 - Module Version TimeStamp Size Base
    20200130/220027.078 - ------------------------------------------------ ---------------- ------------------- ----------- --------
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\ucybdbun.exe 12.2.1+build.15392018-11-05 16:03:58 83.928 a9f60000
    20200130/220027.078 - C:\Windows\SYSTEM32\ntdll.dll 10.0.14393.2430 2019-09-11 05:31:45 1.884.160 f8f70000
    20200130/220027.078 - C:\Windows\System32\KERNEL32.DLL 10.0.14393.2430 2019-05-04 06:20:46 701.352 f70b0000
    20200130/220027.078 - C:\Windows\System32\KERNELBASE.dll 10.0.14393.2430 2019-11-26 07:37:15 2.214.896 f55f0000
    20200130/220027.078 - C:\Windows\System32\ADVAPI32.dll 10.0.14393.0 2019-05-04 06:19:20 652.256 f73f0000
    20200130/220027.078 - C:\Windows\System32\msvcrt.dll 7.0.14393.2457 2018-08-23 05:24:05 635.336 f72f0000
    20200130/220027.078 - C:\Windows\SYSTEM32\NETAPI32.dll 10.0.14393.0 2016-07-16 14:18:38 81.184 ec2c0000
    20200130/220027.078 - C:\Windows\System32\sechost.dll 10.0.14393.0 2018-08-30 22:20:44 359.400 f7390000
    20200130/220027.078 - C:\Windows\System32\RPCRT4.dll 10.0.14393.0 2019-10-17 07:27:07 1.176.264 f6e80000
    20200130/220027.078 - C:\Windows\SYSTEM32\wkscli.dll 10.0.14393.0 2016-07-16 14:18:42 80.088 f1730000
    20200130/220027.078 - C:\Windows\System32\ucrtbase.dll 10.0.14393.2999 2019-05-21 05:08:19 994.176 f5980000
    20200130/220027.078 - C:\Windows\SYSTEM32\bcrypt.dll 10.0.14393.0 2019-05-04 06:18:20 168.536 f5320000
    20200130/220027.078 - C:\Windows\SYSTEM32\cscapi.dll 10.0.14393.0 2016-07-16 14:18:30 52.736 eab80000
    20200130/220027.078 - C:\Windows\SYSTEM32\SspiCli.dll 10.0.14393.2580 2018-10-10 09:30:28 173.176 f5040000
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\ucybdbun.dll 12.2.1+build.15392018-11-05 16:03:59 625.112 e7710000
    20200130/220027.078 - C:\Windows\System32\USER32.dll 10.0.14393.0 2020-01-03 02:09:59 1.461.096 f6d10000
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\UCUDB32.dll 12.2.1+build.15392018-11-05 16:03:59 656.344 e6d80000
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\ZU00132.dll 12.2.1+build.15392018-11-05 16:03:59 518.104 e6cf0000
    20200130/220027.078 - C:\Windows\SYSTEM32\VERSION.dll 10.0.14393.0 2016-07-16 14:18:47 30.504 eccc0000
    20200130/220027.078 - C:\Windows\System32\win32u.dll 10.0.14393.51 2016-11-21 01:42:42 114.192 f6200000
    20200130/220027.078 - C:\Windows\System32\GDI32.dll 10.0.14393.3321 2019-10-17 07:25:35 205.992 f7250000
    20200130/220027.078 - C:\Windows\System32\gdi32full.dll 10.0.14393.3442 2019-12-20 06:08:12 1.567.512 f5460000
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\UCDBUP.dll 12.2.1+build.15392018-11-05 16:03:59 5.670.360 e5690000
    20200130/220027.078 - D:\Automic_Engine\Utility\bin\UCUODBC.DLL 12.2.1+build.15392018-11-05 16:03:58 254.424 e98d0000
    20200130/220027.078 - C:\Windows\SYSTEM32\ODBC32.dll 10.0.14393.3383 2019-11-26 06:41:02 687.616 e5dd0000
    20200130/220027.078 - C:\Windows\SYSTEM32\DPAPI.dll 10.0.14393.0 2016-07-16 14:18:41 15.360 f45c0000
    20200130/220027.078 - C:\Windows\System32\bcryptprimitives.dll 10.0.14393.2969 2019-05-04 06:18:00 431.408 f5810000
    20200130/220027.078 - C:\Windows\system32\msodbcsql13.dll 13.0.811.168 2016-07-19 15:49:28 2.203.336 dfd70000
    20200130/220027.078 - C:\Windows\System32\OLEAUT32.dll 10.0.14393.3383 2019-11-26 07:35:59 776.216 f8c80000
    20200130/220027.078 - C:\Windows\System32\msvcp_win.dll 10.0.14393.2999 2019-05-21 05:01:57 633.120 f6160000
    20200130/220027.078 - C:\Windows\System32\combase.dll 10.0.14393.1198 2019-09-11 05:27:31 2.907.512 f74a0000
    20200130/220027.078 - C:\Windows\System32\COMDLG32.dll 10.0.14393.0 2019-02-17 02:55:07 991.232 f6500000
    20200130/220027.078 - C:\Windows\System32\shcore.dll 10.0.14393.0 2019-05-04 06:18:21 680.912 f58d0000
    20200130/220027.078 - C:\Windows\WinSxS\amd64_microsoft.windows.commo 10.0.14393.2457 2018-08-23 05:20:06 685.808 e74f0000
    20200130/220027.078 - C:\Windows\System32\SHLWAPI.dll 10.0.14393.0 2016-07-16 14:18:47 333.640 f7170000
    20200130/220027.078 - C:\Windows\System32\SHELL32.dll 10.0.14393.0 2019-10-17 07:23:45 22.207.856 f7770000
    20200130/220027.078 - C:\Windows\System32\cfgmgr32.dll 10.0.14393.0 2016-07-16 14:18:41 259.848 f5880000
    20200130/220027.078 - C:\Windows\System32\windows.storage.dll 10.0.14393.0 2019-09-11 05:28:17 7.217.528 f5a80000
    20200130/220027.093 - C:\Windows\System32\powrprof.dll 10.0.14393.0 2016-07-16 14:18:41 301.680 f53f0000
    20200130/220027.093 - C:\Windows\System32\kernel.appcore.dll 10.0.14393.2312 2018-06-08 07:37:24 48.608 f5440000
    20200130/220027.093 - C:\Windows\System32\profapi.dll 10.0.14393.0 2016-07-16 14:18:42 69.264 f53d0000
    20200130/220027.093 - C:\Windows\System32\WS2_32.dll 10.0.14393.0 2019-09-11 05:32:45 424.544 f71e0000
    20200130/220027.093 - C:\Windows\System32\CRYPT32.dll 10.0.14393.0 2019-12-20 06:10:27 1.855.688 f6330000
    20200130/220027.093 - C:\Windows\System32\MSASN1.dll 10.0.14393.0 2016-07-16 14:18:42 59.416 f5450000
    20200130/220027.093 - C:\Windows\system32\Secur32.dll 10.0.14393.2273 2018-04-28 06:50:00 28.160 f21e0000
    20200130/220027.093 - C:\Windows\system32\MSVCP120.dll 12.00.40660.0 2016-07-07 01:45:34 659.616 dfbd0000
    20200130/220027.093 - C:\Windows\system32\MSVCR120.dll 12.00.40660.0 2016-07-07 01:45:34 963.240 dfc80000
    20200130/220027.093 - C:\Windows\system32\1033\msodbcsqlr13.rll 2016-07-19 15:49:36 199.368 02100000
    20200130/220027.093 - C:\Windows\SYSTEM32\netbios.dll 10.0.14393.0 2016-07-16 14:18:20 18.944 e75a0000
    20200130/220027.093 - C:\Windows\system32\odbccp32.dll 10.0.14393.0 2016-07-16 14:18:36 124.416 e02a0000
    20200130/220027.093 - C:\Windows\SYSTEM32\CRYPTBASE.dll 10.0.14393.0 2016-07-16 14:18:43 31.080 f4e40000
    20200130/220027.093 - C:\Windows\system32\CLUSAPI.DLL 10.0.14393.0 2019-03-14 06:56:53 736.768 eadb0000
    20200130/220027.093 - C:\Windows\SYSTEM32\DNSAPI.dll 10.0.14393.0 2019-05-21 05:09:11 648.368 f4a10000
    20200130/220027.093 - C:\Windows\System32\NSI.dll 10.0.14393.3297 2019-10-01 22:25:31 23.696 f71d0000
    20200130/220027.093 - C:\Windows\SYSTEM32\IPHLPAPI.DLL 10.0.14393.0 2018-06-12 02:33:42 219.040 f49d0000
    20200130/220027.093 - C:\Windows\system32\RESUTILS.DLL 10.0.14393.0 2019-03-14 06:54:55 374.784 eb280000
    20200130/220027.093 - C:\Windows\system32\security.dll 10.0.14393.0 2016-07-16 14:18:54 5.120 01de0000
    20200130/220027.093 - C:\Windows\system32\schannel.DLL 10.0.14393.0 2019-09-29 23:49:26 468.480 f47a0000
    20200130/220027.093 - C:\Windows\system32\mswsock.dll 10.0.14393.0 2016-07-16 14:18:41 357.216 f4c90000
    20200130/220027.093 - C:\Windows\System32\rasadhlp.dll 10.0.14393.0 2016-07-16 14:18:20 16.896 f1350000
    20200130/220027.093 - C:\Windows\System32\fwpuclnt.dll 10.0.14393.0 2016-07-16 14:18:28 412.160 f2ca0000
    20200130/220027.093 - C:\Windows\SYSTEM32\mskeyprotect.dll 10.0.14393.0 2019-05-04 05:34:14 62.976 e7f10000
    20200130/220027.093 - C:\Windows\SYSTEM32\ncrypt.dll 10.0.14393.0 2019-05-04 06:18:03 142.728 f4f20000
    20200130/220027.093 - C:\Windows\SYSTEM32\NTASN1.dll 10.0.14393.0 2016-07-16 14:18:42 237.072 f4ee0000
    20200130/220027.093 - C:\Windows\system32\ncryptsslp.dll 10.0.14393.2969 2019-05-04 06:17:47 119.224 e80b0000
    20200130/220027.093 - C:\Windows\SYSTEM32\dbghelp.dll 10.0.14321.1024 2016-07-16 14:18:45 1.529.344 eaf50000
    20200130/220027.093 - U00021200 *********************************************ILM SETTINGS***********************************************
    20200130/220027.093 - U00021202 ILM installed N
    20200130/220027.093 - U00021203 ********************************************************************************************************
    20200130/220027.109 - U00037118 Starting with OFS cleanup for client ALL
    20200130/220027.109 - U00037119 Finished OFS cleanup with status: OK
    20200130/220027.109 - U00037027 No check for archive is performed within UNLOAD when the entries [REORG], NO_ARCHIVE_CHECK=1 are made in INI file .
    20200130/220027.109 - U00037029 According to [REORG], MAX_DEADLOCK='100' in the INI file, DEADLOCK situations will be restarted up to '100' times.
    20200130/220027.360 - U00037030 So far, the following reorg runs have been executed:
    20200130/220027.360 - U00037032 0000001 - 20190909 REORG ;OH,MELD,AH,RH,XAO
    20200130/220049.080 - U00037032 0004143 - 20200130 REORG ;OH,MELD,AH,RH,XAO
    20200130/220049.095 - U00037111 Starting reorganization for client: 'ALL'
    20200130/220049.126 - U00003523 UCUDB: Maximum time required for a DB call: '3:194.895.785'.
    20200130/220049.126 - U00003522 UCUDB: Database closed. Total time for DB calls: '25:354.460.863' seconds.
    20200130/220049.126 - U00003549 UCUDB: ' 2532' 'OTHERS ' calls took '3:385.760.259' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 13' 'SELECT ' calls took '0:018.109.911' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 4' 'EXECUTE ' calls took '0:023.913.862' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 1' 'INSERT ' calls took '0:000.597.869' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 4397' 'READ ' calls took '21:912.704.944' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 3532' 'CLOSESTMT ' calls took '0:005.100.766' sec.
    20200130/220049.126 - U00003549 UCUDB: ' 1019' 'TRANSACT ' calls took '0:008.273.251' sec.
    ========================================================
    Starting C++ batch mode loader...
    User account (user/domain) <UC4REORG/>
    Startup parameter <-BREORG -S0001 >
    Application name <ucybdbun>
    Launch from <.\>
    LoadLibrary <.\ucybdbun.dll>
    LoadLibrary pointer = <00007FFFE7710000>
    Application return code = 0

    D:\Automic_Engine\Utility\bin>D:\Automic_Engine\Agents\Windows\bin\UCXJWX6M.EXE JNR=0171956604 MNR=0001 PNR=32335 IPA=172.28.146.89 TYP=E RET=00000000 TXT=" Job ended"
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' started
    UCMDJP: *********************************************************************
    UCMDJP: ** JOB 0171956604 (ProcID:0000001000) ENDED AT 30.01.2020/22:00:49 **
    UCMDJP: ** UTC TIME 30.01.2020/21:00:49 **
    UCMDJP: ** --------------------------------------------------------------- **
    UCMDJP: ** USED: 0.000 CPU **
    UCMDJP: *********************************************************************
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' terminated normally

    D:\Automic_Engine\Utility\bin>GOTO JOBENDE

    REORG LOG


    D:\Automic_Engine\Utility\bin>D:\Automic_Engine\Agents\Windows\bin\UCXJWX6M.EXE JNR=0171956603 MNR=0001 PNR=32335 IPA=172.28.146.89 TYP=S TXT=" Job started"
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' started
    UCMDJP: *********************************************************************
    UCMDJP: ** JOB 0171956603 (ProcID:0000004000) START AT 30.01.2020/22:00:19 **
    UCMDJP: ** UTC TIME 30.01.2020/21:00:19 **
    UCMDJP: ** --------------------------------------------------------------- **
    UCMDJP: ** USED: 0.000 CPU **
    UCMDJP: *********************************************************************
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' terminated normally

    D:\Automic_Engine\Utility\bin>UCYBDBre -B -S0001
    20200130/220019.663 - U00033105 Program 'ucybdbre' version '12.2.1+build.1539353944310' started, start parameter: '-B -S0001 ', (changelist '1539338339').
    20200130/220019.663 - U00038259 Build Date: '2018-10-12', '16:29:01'
    20200130/220019.663 - ----------------------------------------------------------------------------------------------------
    20200130/220019.663 - ;
    20200130/220019.663 - ; Automic Configuration File for Utility DB Reorg
    20200130/220019.663 - ;
    20200130/220019.663 -
    20200130/220019.663 - [GLOBAL]
    20200130/220019.663 - ;
    20200130/220019.663 - ; language: The Language(s) in which the log messages are displayed.Always a pair of languages separated by comma enclosed in brackets.
    20200130/220019.663 - ; if a message text is not available in the primary language the secondary language will be taken.
    20200130/220019.663 - ; E - english
    20200130/220019.663 - ; D - german
    20200130/220019.663 - ; F - french
    20200130/220019.663 - ;
    20200130/220019.663 - language=(E,D)
    20200130/220019.663 - ;
    20200130/220019.663 - ; logging: Full file name pattern for log file names
    20200130/220019.663 - ; $$ is replaced by the purpose of a Process (CP or WP or JWP or DBSERVICE). No replacements in other components
    20200130/220019.663 - ; * is replaced by the 3 digit number of a Worker Process.
    20200130/220019.663 - ; ## 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.
    20200130/220019.663 - ; z/OS components only:
    20200130/220019.663 - ; If you comment this parameter, this log file is stored in JES. Also refer to the parameter logpurgeclass= which is described below.
    20200130/220019.663 - ; The following parameters can be added if the log is written to a dataset (after the dataset name and separated by semicolons):
    20200130/220019.663 - ; "recfm" = (all 27 z/OS plus * and A record formats are valid)
    20200130/220019.663 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    20200130/220019.663 - ; "blksize" = (0, each positive number up to 32760)
    20200130/220019.663 - ; "space" = ([CYL,TRK],(prim,sec,directory))
    20200130/220019.663 - ;
    20200130/220019.663 - logging=..\temp\ucybdbre_log_##.txt
    20200130/220019.663 - ;
    20200130/220019.663 - ; logCount: number of log files being kept on disk
    20200130/220019.663 - ;
    20200130/220019.663 - logCount=300
    20200130/220019.663 - ;
    20200130/220019.663 - ; helplib: name of the message text library
    20200130/220019.663 - ;
    20200130/220019.663 - helplib=uc.msl
    20200130/220019.663 - ;
    20200130/220019.663 - ; helpcache: Availability of the messages and language dependent strings.
    20200130/220019.663 - ; ALL - The complete message file is held in the RAM.
    20200130/220019.663 - ; NONE - Always read from the hard drive.
    20200130/220019.678 - ; 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).
    20200130/220019.678 - ;
    20200130/220019.678 - helpcache=ALL
    20200130/220019.678 - ;
    20200130/220019.678 - ; alloc_Size: The utility processes the data records block by block. This parameter specifies the block size (number of data records).
    20200130/220019.678 - ;
    20200130/220019.678 - alloc_Size=200000
    20200130/220019.678 - ;
    20200130/220019.678 - ; path: Start path for the component.
    20200130/220019.678 - ;
    20200130/220019.678 - path=.
    20200130/220019.678 - ;
    20200130/220019.678 - ; cmd: Command line call command for starting the component.
    20200130/220019.678 - ;
    20200130/220019.678 - cmd="javaw" -cp .;.\lookandfeel.jar -jar ucybdbre.jar
    20200130/220019.678 - ;
    20200130/220019.678 - ; title: String pattern of window title for end recognition
    20200130/220019.678 - ;
    20200130/220019.678 - title=DB
    20200130/220019.678 - ;
    20200130/220019.678 - ; docu_path: The directory in which the help system is installed.
    20200130/220019.678 - ;
    20200130/220019.678 - docu_path=..\..\Documentation\uc4\webhelp
    20200130/220019.678 -
    20200130/220019.678 - [TRACE]
    20200130/220019.678 - ;
    20200130/220019.678 - ; file: The path and the file name of the trace file.
    20200130/220019.678 - ; Any file name for a text file with several place holders for current system information:
    20200130/220019.678 - ; $$ is replaced by server process type (WP or CP) in the context of a server process.
    20200130/220019.678 - ; * is replaced by the three-digit process number in the context of a server process.
    20200130/220019.678 - ; ## is replaced by 00 after the available trace files' corresponding numbers have been raised by one during startup of a trace.
    20200130/220019.678 - ; xxx is replaced by the three-digit abbreviation of the respective unix version (unix agent only).
    20200130/220019.678 - ; z/OS components only:
    20200130/220019.678 - ; The following parameters can be added (after the dataset name and separated by semicolons) if the log is written to a dataset:
    20200130/220019.678 - ; "recfm" = (all 27 record formats of z/OS plus * and A are valid)
    20200130/220019.678 - ; "lrecl" = (0, each positive number up to 32760 and X for each reclen)
    20200130/220019.678 - ; "blksize" = (0, each positive number up to 32760)
    20200130/220019.678 - ; "space" = ([CYL,TRK],(prim,sec,directory))
    20200130/220019.678 - ;
    20200130/220019.678 - file=..\temp\ucybdbre_trace_##.txt
    20200130/220019.678 - ;
    20200130/220019.678 - ; trccount: Number of stored trace files
    20200130/220019.678 - ;
    20200130/220019.678 - trccount=10
    20200130/220019.678 - ;
    20200130/220019.678 - ; database: traceflags
    20200130/220019.678 - ; 0 - no trace
    20200130/220019.678 - ; 1 - SQL
    20200130/220019.678 - ; 2 - OPC
    20200130/220019.678 - ; 3 - Bind parameters
    20200130/220019.678 - ; 4 - Data fields
    20200130/220019.678 - ;
    20200130/220019.678 - database=0
    20200130/220019.678 -
    20200130/220019.678 - [ODBC]
    20200130/220019.678 - ;
    20200130/220019.678 - ; sqlDriverConnect: Connection String for the database.
    20200130/220019.678 - ; General format of the connection string is "OBDCVAR=<cmd>,<odbc-string>"
    20200130/220019.678 - ;
    20200130/220019.678 - ; <cmd> is an eight figure command field for controlling database accesses like follows
    20200130/220019.678 - ; 1. Position = N - Do not use server cursor.
    20200130/220019.678 - ; 1. Position = S - Use server cursor (MS SQL Server 2000).
    20200130/220019.678 - ; 2. Position = N - Do not reestablish database connection after 1000 commits.
    20200130/220019.678 - ; 2. Position = D - Disconnect database after 1000 commits (perhaps due to memory problems).
    20200130/220019.678 - ; 3. Position = N - Field names are compared case-sensitively (Oracle).
    20200130/220019.678 - ; 3. Position = J - Field names are compared case-insensitively (Oracle).
    20200130/220019.678 - ; 4. Position = N - Not used.
    20200130/220019.678 - ; 5. Position = N - Type of database connection: ODBC.
    20200130/220019.678 - ; 5. Position = I - Type of database connection: OCI/CLI.
    20200130/220019.678 - ; 6. Position = N - Database access without User ID.
    20200130/220019.678 - ; 6. Position = O - Database access with User ID.
    20200130/220019.678 - ; 7. Position = N - Compression is deactivated.
    20200130/220019.678 - ; 7. Position = R - Compression is activated.
    20200130/220019.678 - ; 8. Position = Type of SQL Syntax; N - MS SQL Server.
    20200130/220019.678 - ; 8. Position = Type of SQL Syntax; O - Oracle.
    20200130/220019.678 - ; 8. Position = Type of SQL Syntax; D - DB2.
    20200130/220019.678 - ;
    20200130/220019.678 - ; <odbc-string> contains standard and vendor related keywords and values
    20200130/220019.678 - ; DSN - Alias name of the database connection.
    20200130/220019.678 - ; UID - User ID for database access. Note that this parameter is case sensitive.
    20200130/220019.678 - ; PWD - Password for database access.
    20200130/220019.678 - ; ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;Mars_Connection=Yes - Microsoft SQL Server with MARS
    20200130/220019.678 - ; ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2 - Microsoft SQL Server without MARS
    20200130/220019.678 - ; ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 - Oracle
    20200130/220019.678 - ;
    20200130/220019.678 - ;sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=UC4;UID=uc4;PWD=???
    20200130/220019.678 - sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=DEV;UID=UM13_Admin;PWD=???;Mars_Connection=Yes
    20200130/220019.678 -
    20200130/220019.678 - [REORG]
    20200130/220019.678 - ;
    20200130/220019.678 - ; auto_Reorg: The maximum age of the data records in days.
    20200130/220019.678 - ; 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.
    20200130/220019.678 - ; 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.
    20200130/220019.678 - ; 0..32767 - age in days.
    20200130/220019.678 - ;
    20200130/220019.678 - auto_Reorg=90
    20200130/220019.678 - ;
    20200130/220019.678 - ; no_Archive_Check: Archiving check.
    20200130/220019.678 - ; 0 - Checks if data has been archived before.
    20200130/220019.678 - ; 1 - There is no such check.
    20200130/220019.678 - ; change from 0 to 1 according to old system TEMEL 2018/07/13
    20200130/220019.678 - no_Archive_Check=0
    20200130/220019.678 - ----------------------------------------------------------------------------------------------------
    20200130/220019.678 - U00003545 UCUDB: Opening database ...
    20200130/220019.678 - U00029112 UCUDB - Length of the DB-History area: 100
    20200130/220019.711 - U00003592 UCUDB - Status: '01000' Native error: '5701' Msg: 'Changed database context to 'DEV'.'
    20200130/220019.711 - U00003592 UCUDB - Status: '01000' Native error: '5703' Msg: 'Changed language setting to us_english.'
    20200130/220019.711 - U00029115 UCUDB - OPEN Database handles DB-HENV: 756160 DB-HDBC: 756240
    20200130/220019.711 - U00003535 DB INFO: 'DATABASE-NAME = DEV'
    20200130/220019.711 - U00003535 DB INFO: 'DBMS-NAME = Microsoft SQL Server'
    20200130/220019.711 - U00003535 DB INFO: 'DBMS-VER = 13.00.5598'
    20200130/220019.711 - U00003535 DB INFO: 'ODBC-VER = 03.80.0000'
    20200130/220019.711 - U00003535 DB INFO: 'DRIVER-NAME = msodbcsql13.dll'
    20200130/220019.711 - U00003535 DB INFO: 'DRIVER-ODBC-VER = 03.80'
    20200130/220019.711 - U00003535 DB INFO: 'DRIVER-VER = 13.00.0811'
    20200130/220019.711 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE = 2'
    20200130/220019.711 - U00003535 DB INFO: 'TXN-CAPABLE = 2'
    20200130/220019.711 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION = 2'
    20200130/220019.711 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION = 0000000000101111B ( 47)'
    20200130/220019.711 - U00003535 DB INFO: 'POS-OPERATIONS = 0000000000011111B ( 31)'
    20200130/220019.711 - U00003535 DB INFO: 'POSITIONED-STATEMENTS = 0000000000000111B ( 7)'
    20200130/220019.711 - U00003535 DB INFO: 'SCROLL-CONCURRENCY = 0000000000001111B ( 15)'
    20200130/220019.711 - U00003535 DB INFO: 'SCROLL-OPTIONS = 0000000000010111B ( 23)'
    20200130/220019.711 - U00003535 DB INFO: 'STATIC-SENSITIVITY = 0000000000000101B ( 5)'
    20200130/220019.711 - U00003535 DB INFO: 'LOCK-TYPES = 0000000000000001B ( 1)'
    20200130/220019.711 - U00003535 DB INFO: 'ODBC_TRACE = 0'
    20200130/220019.818 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
    20200130/220019.818 - Module Version TimeStamp Size Base
    20200130/220019.818 - ------------------------------------------------ ---------------- ------------------- ----------- --------
    20200130/220019.833 - D:\Automic_Engine\Utility\bin\ucybdbre.exe 12.2.1+build.15392018-11-05 16:03:58 83.928 70480000
    20200130/220019.833 - C:\Windows\SYSTEM32\ntdll.dll 10.0.14393.2430 2019-09-11 05:31:45 1.884.160 f8f70000
    20200130/220019.833 - C:\Windows\System32\KERNEL32.DLL 10.0.14393.2430 2019-05-04 06:20:46 701.352 f70b0000
    20200130/220019.833 - C:\Windows\System32\KERNELBASE.dll 10.0.14393.2430 2019-11-26 07:37:15 2.214.896 f55f0000
    20200130/220019.833 - C:\Windows\System32\ADVAPI32.dll 10.0.14393.0 2019-05-04 06:19:20 652.256 f73f0000
    20200130/220019.833 - C:\Windows\System32\msvcrt.dll 7.0.14393.2457 2018-08-23 05:24:05 635.336 f72f0000
    20200130/220019.833 - C:\Windows\SYSTEM32\NETAPI32.dll 10.0.14393.0 2016-07-16 14:18:38 81.184 ec2c0000
    20200130/220019.833 - C:\Windows\System32\sechost.dll 10.0.14393.0 2018-08-30 22:20:44 359.400 f7390000
    20200130/220019.833 - C:\Windows\System32\RPCRT4.dll 10.0.14393.0 2019-10-17 07:27:07 1.176.264 f6e80000
    20200130/220019.833 - C:\Windows\SYSTEM32\wkscli.dll 10.0.14393.0 2016-07-16 14:18:42 80.088 f1730000
    20200130/220019.833 - C:\Windows\System32\ucrtbase.dll 10.0.14393.2999 2019-05-21 05:08:19 994.176 f5980000
    20200130/220019.833 - C:\Windows\SYSTEM32\bcrypt.dll 10.0.14393.0 2019-05-04 06:18:20 168.536 f5320000
    20200130/220019.833 - C:\Windows\SYSTEM32\cscapi.dll 10.0.14393.0 2016-07-16 14:18:30 52.736 eab80000
    20200130/220019.833 - C:\Windows\SYSTEM32\SspiCli.dll 10.0.14393.2580 2018-10-10 09:30:28 173.176 f5040000
    20200130/220019.833 - D:\Automic_Engine\Utility\bin\ucydbreorg.dll 12.2.1+build.15392018-11-05 16:03:58 471.512 e7740000
    20200130/220019.833 - C:\Windows\System32\USER32.dll 10.0.14393.0 2020-01-03 02:09:59 1.461.096 f6d10000
    20200130/220019.833 - D:\Automic_Engine\Utility\bin\ZU00132.dll 12.2.1+build.15392018-11-05 16:03:59 518.104 e76b0000
    20200130/220019.833 - D:\Automic_Engine\Utility\bin\UCUDB32.dll 12.2.1+build.15392018-11-05 16:03:59 656.344 e6d80000
    20200130/220019.833 - C:\Windows\System32\win32u.dll 10.0.14393.51 2016-11-21 01:42:42 114.192 f6200000
    20200130/220019.833 - C:\Windows\SYSTEM32\VERSION.dll 10.0.14393.0 2016-07-16 14:18:47 30.504 eccc0000
    20200130/220019.833 - C:\Windows\System32\GDI32.dll 10.0.14393.3321 2019-10-17 07:25:35 205.992 f7250000
    20200130/220019.833 - C:\Windows\System32\gdi32full.dll 10.0.14393.3442 2019-12-20 06:08:12 1.567.512 f5460000
    20200130/220019.833 - D:\Automic_Engine\Utility\bin\UCUODBC.DLL 12.2.1+build.15392018-11-05 16:03:58 254.424 e98d0000
    20200130/220019.833 - C:\Windows\SYSTEM32\ODBC32.dll 10.0.14393.3383 2019-11-26 06:41:02 687.616 e5dd0000
    20200130/220019.833 - C:\Windows\SYSTEM32\DPAPI.dll 10.0.14393.0 2016-07-16 14:18:41 15.360 f45c0000
    20200130/220019.833 - C:\Windows\System32\bcryptprimitives.dll 10.0.14393.2969 2019-05-04 06:18:00 431.408 f5810000
    20200130/220019.833 - C:\Windows\system32\msodbcsql13.dll 13.0.811.168 2016-07-19 15:49:28 2.203.336 dfd70000
    20200130/220019.833 - C:\Windows\System32\OLEAUT32.dll 10.0.14393.3383 2019-11-26 07:35:59 776.216 f8c80000
    20200130/220019.833 - C:\Windows\System32\msvcp_win.dll 10.0.14393.2999 2019-05-21 05:01:57 633.120 f6160000
    20200130/220019.833 - C:\Windows\System32\combase.dll 10.0.14393.1198 2019-09-11 05:27:31 2.907.512 f74a0000
    20200130/220019.833 - C:\Windows\System32\COMDLG32.dll 10.0.14393.0 2019-02-17 02:55:07 991.232 f6500000
    20200130/220019.833 - C:\Windows\System32\shcore.dll 10.0.14393.0 2019-05-04 06:18:21 680.912 f58d0000
    20200130/220019.833 - C:\Windows\System32\SHLWAPI.dll 10.0.14393.0 2016-07-16 14:18:47 333.640 f7170000
    20200130/220019.833 - C:\Windows\WinSxS\amd64_microsoft.windows.commo 10.0.14393.2457 2018-08-23 05:20:06 685.808 e74f0000
    20200130/220019.833 - C:\Windows\System32\SHELL32.dll 10.0.14393.0 2019-10-17 07:23:45 22.207.856 f7770000
    20200130/220019.833 - C:\Windows\System32\cfgmgr32.dll 10.0.14393.0 2016-07-16 14:18:41 259.848 f5880000
    20200130/220019.833 - C:\Windows\System32\windows.storage.dll 10.0.14393.0 2019-09-11 05:28:17 7.217.528 f5a80000
    20200130/220019.833 - C:\Windows\System32\powrprof.dll 10.0.14393.0 2016-07-16 14:18:41 301.680 f53f0000
    20200130/220019.833 - C:\Windows\System32\kernel.appcore.dll 10.0.14393.2312 2018-06-08 07:37:24 48.608 f5440000
    20200130/220019.833 - C:\Windows\System32\profapi.dll 10.0.14393.0 2016-07-16 14:18:42 69.264 f53d0000
    20200130/220019.833 - C:\Windows\System32\WS2_32.dll 10.0.14393.0 2019-09-11 05:32:45 424.544 f71e0000
    20200130/220019.833 - C:\Windows\System32\CRYPT32.dll 10.0.14393.0 2019-12-20 06:10:27 1.855.688 f6330000
    20200130/220019.833 - C:\Windows\System32\MSASN1.dll 10.0.14393.0 2016-07-16 14:18:42 59.416 f5450000
    20200130/220019.833 - C:\Windows\system32\Secur32.dll 10.0.14393.2273 2018-04-28 06:50:00 28.160 f21e0000
    20200130/220019.833 - C:\Windows\system32\MSVCP120.dll 12.00.40660.0 2016-07-07 01:45:34 659.616 dfbd0000
    20200130/220019.833 - C:\Windows\system32\MSVCR120.dll 12.00.40660.0 2016-07-07 01:45:34 963.240 dfc80000
    20200130/220019.833 - C:\Windows\system32\1033\msodbcsqlr13.rll 2016-07-19 15:49:36 199.368 0aea0000
    20200130/220019.833 - C:\Windows\SYSTEM32\netbios.dll 10.0.14393.0 2016-07-16 14:18:20 18.944 e75a0000
    20200130/220019.849 - C:\Windows\system32\odbccp32.dll 10.0.14393.0 2016-07-16 14:18:36 124.416 e02a0000
    20200130/220019.849 - C:\Windows\SYSTEM32\CRYPTBASE.dll 10.0.14393.0 2016-07-16 14:18:43 31.080 f4e40000
    20200130/220019.849 - C:\Windows\system32\CLUSAPI.DLL 10.0.14393.0 2019-03-14 06:56:53 736.768 eadb0000
    20200130/220019.849 - C:\Windows\SYSTEM32\DNSAPI.dll 10.0.14393.0 2019-05-21 05:09:11 648.368 f4a10000
    20200130/220019.849 - C:\Windows\System32\NSI.dll 10.0.14393.3297 2019-10-01 22:25:31 23.696 f71d0000
    20200130/220019.849 - C:\Windows\SYSTEM32\IPHLPAPI.DLL 10.0.14393.0 2018-06-12 02:33:42 219.040 f49d0000
    20200130/220019.849 - C:\Windows\system32\RESUTILS.DLL 10.0.14393.0 2019-03-14 06:54:55 374.784 eb280000
    20200130/220019.849 - C:\Windows\system32\security.dll 10.0.14393.0 2016-07-16 14:18:54 5.120 0b020000
    20200130/220019.849 - C:\Windows\system32\schannel.DLL 10.0.14393.0 2019-09-29 23:49:26 468.480 f47a0000
    20200130/220019.849 - C:\Windows\system32\mswsock.dll 10.0.14393.0 2016-07-16 14:18:41 357.216 f4c90000
    20200130/220019.849 - C:\Windows\System32\rasadhlp.dll 10.0.14393.0 2016-07-16 14:18:20 16.896 f1350000
    20200130/220019.849 - C:\Windows\System32\fwpuclnt.dll 10.0.14393.0 2016-07-16 14:18:28 412.160 f2ca0000
    20200130/220019.849 - C:\Windows\SYSTEM32\mskeyprotect.dll 10.0.14393.0 2019-05-04 05:34:14 62.976 e7f10000
    20200130/220019.849 - C:\Windows\SYSTEM32\ncrypt.dll 10.0.14393.0 2019-05-04 06:18:03 142.728 f4f20000
    20200130/220019.849 - C:\Windows\SYSTEM32\NTASN1.dll 10.0.14393.0 2016-07-16 14:18:42 237.072 f4ee0000
    20200130/220019.849 - C:\Windows\system32\ncryptsslp.dll 10.0.14393.2969 2019-05-04 06:17:47 119.224 e80b0000
    20200130/220019.849 - C:\Windows\SYSTEM32\dbghelp.dll 10.0.14321.1024 2016-07-16 14:18:45 1.529.344 eaf50000
    20200130/220019.849 - U00003621 Version of Automation Engine database objects: '12.2.1+build.1540207229607'
    20200130/220019.849 - U00021200 *********************************************ILM SETTINGS***********************************************
    20200130/220019.849 - U00021202 ILM installed N
    20200130/220019.849 - U00021203 ********************************************************************************************************
    20200130/220019.849 - U00032203 Logon with user 'UC4REORG/%'.
    20200130/220019.849 - U00031221 Time zone 'TZ_CET' is used for this run.
    20200130/220019.849 - U00032205 Logon with user 'UC4REORG/%' was successful.
    20200130/220019.912 - U00032189 Reorganization started in client '1'.
    20200130/220019.912 - Messages (MELD): read: '45' days ('2019.12.16') unread: '45' days ('2019.12.16')
    20200130/220019.912 - Statistics (AH): '5' days ('2020.01.25') Keep last 5 Statistical records per object
    20200130/220019.912 - Reports (RH/RT): '5' days ('2020.01.25') Keep last 5 Reports per object
    20200130/220019.912 - Version Management: '10' days ('2020.01.20')
    20200130/220019.912 - U00032223 Collecting all running tasks for current client.
    20200130/220022.135 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLUC' time: '2:191.768.967'
    20200130/220022.135 - 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'
    20200130/220022.135 - U00032190 Number of deletion flags set in table 'MELD': '0'
    20200130/220022.213 - U00003523 UCUDB: Maximum time required for a DB call: '2:191.768.967'.
    20200130/220022.213 - U00003522 UCUDB: Database closed. Total time for DB calls: '2:510.746.279' seconds.
    20200130/220022.213 - U00003549 UCUDB: ' 284' 'OTHERS ' calls took '0:173.877.607' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 24' 'SELECT ' calls took '2:308.734.305' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 0' 'EXECUTE ' calls took '0:000.000.000' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 0' 'INSERT ' calls took '0:000.000.000' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 84' 'READ ' calls took '0:019.345.260' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 276' 'CLOSESTMT ' calls took '0:004.655.276' sec.
    20200130/220022.213 - U00003549 UCUDB: ' 18' 'TRANSACT ' calls took '0:004.133.829' sec.
    ========================================================
    Starting C++ batch mode loader...
    User account (user/domain) <UC4REORG>
    Startup parameter <-B -S0001 >
    Application name <UCYBDBre>
    Launch from <.\>
    LoadLibrary <.\ucydbreorg.dll>
    LoadLibrary pointer = <00007FFFE7740000>
    Application return code = 0

    D:\Automic_Engine\Utility\bin>D:\Automic_Engine\Agents\Windows\bin\UCXJWX6M.EXE JNR=0171956603 MNR=0001 PNR=32335 IPA=172.28.146.89 TYP=E RET=00000000 TXT=" Job ended"
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' started
    UCMDJP: *********************************************************************
    UCMDJP: ** JOB 0171956603 (ProcID:0000004000) ENDED AT 30.01.2020/22:00:22 **
    UCMDJP: ** UTC TIME 30.01.2020/21:00:22 **
    UCMDJP: ** --------------------------------------------------------------- **
    UCMDJP: ** USED: 0.000 CPU **
    UCMDJP: *********************************************************************
    Program 'UC4 Job Messenger' version '12.2.2+build.1549050306180' terminated normally

    D:\Automic_Engine\Utility\bin>GOTO JOBENDE


    Thanks and Regards
    Vimalan


  • 2.  RE: House keeping job is running but still old reports are available in the system

    Posted Jan 30, 2020 05:07 PM
    Where is your UC_UTILITY_REORG stored?  In our case, we've got a different version in each client.

    ------------------------------
    Pete
    ------------------------------

    Original Message


  • 3.  RE: House keeping job is running but still old reports are available in the system

    Posted Jan 30, 2020 06:08 PM
    The settings in UC_UTILITY_ARCHIVE are also in play here.

    ------------------------------
    Pete
    ------------------------------

    Original Message


  • 4.  RE: House keeping job is running but still old reports are available in the system

    Posted Jan 30, 2020 05:14 PM
    Based upon this configuration
    RH TRUE 0005 TRUE 0005
    and this output line
    "20200130/220019.912 - Reports (RH/RT): '5' days ('2020.01.25') Keep last 5 Reports per object" 

    you're keeping the at minimum the last five (5) reports of an object.  So if an object runs once a month, you'll have the oldest report dated five (5) months ago.
    Original Message


  • 5.  RE: House keeping job is running but still old reports are available in the system

    Posted Jan 31, 2020 07:47 AM
    As Timothy Yanosko said. You defined to Keep 5 runs at least. If it's running once per month, you have the statistics in this case for 5 month.

    If it important for you to have no older data, you could use the Parameter "auto_Reorg" in the configuration, to overrule this.
    Original Message


  • 6.  RE: House keeping job is running but still old reports are available in the system

    Posted Feb 12, 2020 09:25 AM
    Hi Timothy , Torsten,

    You are correct that if we run the job once every month , then we will have the last 5 executions. But here we are running the job every day at 10:00 PM .

    I'm wondering why can I see the report of the job which is 1 month old? 

    Below are the Utlity configuration

    for reorg

    AH TRUE 0005 TRUE 0005
    MELD TRUE 0045 0045
    OBJECT_AUDIT FALSE 0045 TRUE
    RH TRUE 0005 TRUE 0005
    VERSION_CONTROL TRUE 0010 FALSE 0000

    for archive

    AH - TRUE 0005
    MELD - TRUE 0005 0005


    Any suggestion please

    Thanks and Regards
    Vimalan
    Original Message


  • 7.  RE: House keeping job is running but still old reports are available in the system

    Posted Jan 31, 2020 07:47 AM
    Edited by Torsten Goehler Feb 03, 2020 01:58 AM
    -doppelpost-


  • 8.  RE: House keeping job is running but still old reports are available in the system

    Posted Feb 02, 2020 03:17 PM
    Thank you for response. 

    But We are running the house keeping job every day and still not sure why I'm able to see the logs of a month in the system even though the retention period is set only for 5 days. 

    Even UC_UTILITY_ARCHIVE for AH , has the value of 5 . 

    Any hints please ? 
     

    Original Message


  • 9.  RE: House keeping job is running but still old reports are available in the system
    Best Answer

    Posted Feb 03, 2020 03:13 AM
    Edited by Diane Craddock Feb 03, 2020 10:26 AM
    Hi Maria,

    It's not about the retention period, it's about the number of data sets that will be keep even if they are older than 5 days. And that value is obviously set to 5 in your UC_UTILITY_REORG (check my screen shot below with a value of 30).That means that at least 5 data sets per object are beeing keep in your DB, regardless how old they are. If you have a job that runs several times per day and reorg the DB every day, you'll have a couple of statistics but only for the last 5 days. And like the others already mentioned - you keep 5 data sets of your month end job - given that it already has 5 runs.

    Maybe it's worth explaning this strange DB Reorg process: in the very very old days there only was DB-Reorg and DB-Unload, no DB-Archive. Only reorg flags where to be set. The DB-Unload checked all data sets that had the reorg flag and unloaded them to a txt file (that was the default). So after a while there were a lot of unloaded data in form of txt-files. When someone wanted to see a report that was in - lets say - "unload-file-10-of-300" than all unload files had to reloaded to the DB starting with file-300, than file-299 and so on until finaly file-10 was reloaded. Only then the old reports were visible in the UserInterface. Of cource that was not very amusing for the customers. Than Automic/UC4 introduced the DB-Archive to make the old reports and statistics available without reloading all that stuff back into the DB and afterwards unloading it again. Now the files can be viewed with the Archive-Browser (ucybarbr) - which is PITA - or with a text editor that is capable of handling big txt files - like notepad++


    Hope this helps
    Cheers
    Christoph 


    Original Message