Hi
in addition to Petes comment - pls check the logfiles of Db archive & DB reorg for consistency (settings) and errors.
I observed that "Application returncode = 0" is no guarantee that the archive/reorg job went well :-)
=> If you are unsure open a support Ticket and let them check for you.
regarding 2018- entries thats nit necessarily an error - example: You defined "... keep at least 10 Report-versions" on some AH and RH entries.
that means if you run a Job once a year - and the last 10 entries are kept - the oldest entry would be from 2008
... just as an example...
cheers,
Wolfgang
------------------------------
I know I do really know it!
------------------------------
Original Message:
Sent: 07-23-2019 10:59 AM
From: Vimalan
Subject: RT table contains last year entries
Dear Experts
we are running Automic 12.2 and we are performing some additional clean-ups in the system.
And we noticed that RT table contains entries from last year 2018. We installed the system and made it live from April 2018.
We are running DB reorg jobs on daily basis and we are not sure how to get rid of these 2018 entries. RT tables contains more than 1.5 billion entries now . Can you please help us in this situation ?
Thanks and Regards
Vimalan
OVW_OH_Client | (No column name) | OVW_OH_idnr | (No column name) | (No column name) |
1041 | UC_UTILITY_REORG | 1063205 | AH | TRUE 0020 TRUE 0010 |
1041 | UC_UTILITY_REORG | 1063205 | MELD | TRUE 0010 0010 |
1041 | UC_UTILITY_REORG | 1063205 | OBJECT_AUDIT | FALSE 0030 TRUE |
1041 | UC_UTILITY_REORG | 1063205 | RH | TRUE 0020 TRUE 0010 |
1041 | UC_UTILITY_REORG | 1063205 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
2101 | UC_UTILITY_REORG | 1231872 | AH | TRUE 0045 TRUE 0010 |
2101 | UC_UTILITY_REORG | 1231872 | MELD | TRUE 0045 0045 |
2101 | UC_UTILITY_REORG | 1231872 | RH | TRUE 0030 TRUE 0010 |
2101 | UC_UTILITY_REORG | 1231872 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1002 | UC_UTILITY_REORG | 1416001 | AH | TRUE 0045 TRUE 0010 |
1002 | UC_UTILITY_REORG | 1416001 | MELD | TRUE 0030 0030 |
1002 | UC_UTILITY_REORG | 1416001 | OBJECT_AUDIT | TRUE 0030 FALSE |
1002 | UC_UTILITY_REORG | 1416001 | RH | TRUE 0030 TRUE 0010 |
1002 | UC_UTILITY_REORG | 1416001 | VERSION_CONTROL | TRUE 0030 FALSE 0012 |
1067 | UC_UTILITY_REORG | 1417059 | AH | TRUE 0005 TRUE 0035 |
1067 | UC_UTILITY_REORG | 1417059 | MELD | TRUE 0010 0010 |
1067 | UC_UTILITY_REORG | 1417059 | OBJECT_AUDIT | FALSE 0030 TRUE |
1067 | UC_UTILITY_REORG | 1417059 | RH | TRUE 0005 TRUE 0035 |
1067 | UC_UTILITY_REORG | 1417059 | VERSION_CONTROL | TRUE 0010 TRUE 0015 |
1110 | UC_UTILITY_REORG | 1424023 | AH | TRUE 0005 TRUE 0005 |
1110 | UC_UTILITY_REORG | 1424023 | MELD | TRUE 0002 0002 |
1110 | UC_UTILITY_REORG | 1424023 | OBJECT_AUDIT | FALSE 0030 TRUE |
1110 | UC_UTILITY_REORG | 1424023 | RH | TRUE 0005 TRUE 0005 |
1110 | UC_UTILITY_REORG | 1424023 | VERSION_CONTROL | TRUE 0005 TRUE 0005 |
1200 | UC_UTILITY_REORG | 1428037 | AH | TRUE 0005 TRUE 0030 |
1200 | UC_UTILITY_REORG | 1428037 | MELD | TRUE 0010 0010 |
1200 | UC_UTILITY_REORG | 1428037 | OBJECT_AUDIT | FALSE 0030 TRUE |
1200 | UC_UTILITY_REORG | 1428037 | RH | TRUE 0005 TRUE 0030 |
1200 | UC_UTILITY_REORG | 1428037 | VERSION_CONTROL | TRUE 0005 TRUE 0015 |
1280 | UC_UTILITY_REORG | 1433012 | AH | TRUE 0005 TRUE 0035 |
1280 | UC_UTILITY_REORG | 1433012 | MELD | TRUE 0010 0010 |
1280 | UC_UTILITY_REORG | 1433012 | OBJECT_AUDIT | FALSE 0030 TRUE |
1280 | UC_UTILITY_REORG | 1433012 | RH | TRUE 0005 TRUE 0035 |
1280 | UC_UTILITY_REORG | 1433012 | VERSION_CONTROL | TRUE 0010 TRUE 0015 |
1290 | UC_UTILITY_REORG | 1436059 | AH | TRUE 0045 TRUE 0026 |
1290 | UC_UTILITY_REORG | 1436059 | MELD | TRUE 0045 0045 |
1290 | UC_UTILITY_REORG | 1436059 | OBJECT_AUDIT | FALSE 0030 TRUE |
1290 | UC_UTILITY_REORG | 1436059 | RH | TRUE 0030 TRUE 0010 |
1290 | UC_UTILITY_REORG | 1436059 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1294 | UC_UTILITY_REORG | 1447004 | AH | TRUE 0045 TRUE 0010 |
1294 | UC_UTILITY_REORG | 1447004 | MELD | TRUE 0045 0045 |
1294 | UC_UTILITY_REORG | 1447004 | RH | TRUE 0030 TRUE 0010 |
1294 | UC_UTILITY_REORG | 1447004 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1337 | UC_UTILITY_REORG | 1449175 | AH | TRUE 0045 TRUE 0010 |
1337 | UC_UTILITY_REORG | 1449175 | MELD | TRUE 0045 0045 |
1337 | UC_UTILITY_REORG | 1449175 | RH | TRUE 0030 TRUE 0010 |
1337 | UC_UTILITY_REORG | 1449175 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1500 | UC_UTILITY_REORG | 1452001 | AH | TRUE 0045 TRUE 0010 |
1500 | UC_UTILITY_REORG | 1452001 | MELD | TRUE 0045 0045 |
1500 | UC_UTILITY_REORG | 1452001 | RH | TRUE 0030 TRUE 0010 |
1500 | UC_UTILITY_REORG | 1452001 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |
1300 | UC_UTILITY_REORG | 1448028 | AH | TRUE 0030 TRUE 0007 |
1300 | UC_UTILITY_REORG | 1448028 | MELD | TRUE 0030 0030 |
1300 | UC_UTILITY_REORG | 1448028 | OBJECT_AUDIT | TRUE 0030 TRUE |
1300 | UC_UTILITY_REORG | 1448028 | RH | TRUE 0030 TRUE 0007 |
1300 | UC_UTILITY_REORG | 1448028 | VERSION_CONTROL | TRUE 0030 TRUE 0007 |
3001 | UC_UTILITY_REORG | 1455080 | AH | TRUE 0045 TRUE 0010 |
3001 | UC_UTILITY_REORG | 1455080 | MELD | TRUE 0045 0045 |
3001 | UC_UTILITY_REORG | 1455080 | RH | TRUE 0030 TRUE 0010 |
3001 | UC_UTILITY_REORG | 1455080 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1040 | UC_UTILITY_ARCHIVE | 1120106 | AH | TRUE 0045 |
1040 | UC_UTILITY_ARCHIVE | 1120106 | MELD | TRUE 0045 0045 |
0 | UC_UTILITY_ARCHIVE | 38 | AH | TRUE 0045 |
0 | UC_UTILITY_ARCHIVE | 38 | MELD | TRUE 0045 0045 |
1 | UC_UTILITY_ARCHIVE | 1543015 | AH | TRUE 0045 |
1 | UC_UTILITY_ARCHIVE | 1543015 | MELD | TRUE 0045 0045 |
1041 | UC_UTILITY_ARCHIVE | 1063204 | AH | TRUE 0045 |
1041 | UC_UTILITY_ARCHIVE | 1063204 | MELD | TRUE 0045 0045 |
1051 | UC_UTILITY_ARCHIVE | 1085071 | AH | TRUE 0045 |
1051 | UC_UTILITY_ARCHIVE | 1085071 | MELD | TRUE 0045 0045 |
1054 | UC_UTILITY_ARCHIVE | 1361075 | AH | TRUE 0045 |
1054 | UC_UTILITY_ARCHIVE | 1361075 | MELD | TRUE 0045 0045 |
1067 | UC_UTILITY_ARCHIVE | 1417087 | AH | TRUE 0045 |
1067 | UC_UTILITY_ARCHIVE | 1417087 | MELD | TRUE 0045 0045 |
1110 | UC_UTILITY_ARCHIVE | 1424011 | AH | TRUE 0007 |
1110 | UC_UTILITY_ARCHIVE | 1424011 | MELD | TRUE 0045 0045 |
1200 | UC_UTILITY_ARCHIVE | 1428036 | AH | TRUE 0045 |
1200 | UC_UTILITY_ARCHIVE | 1428036 | MELD | TRUE 0045 0045 |
1280 | UC_UTILITY_ARCHIVE | 1433014 | AH | TRUE 0045 |
1280 | UC_UTILITY_ARCHIVE | 1433014 | MELD | TRUE 0045 0045 |
1290 | UC_UTILITY_ARCHIVE | 1436061 | AH | TRUE 0045 |
1290 | UC_UTILITY_ARCHIVE | 1436061 | MELD | TRUE 0045 0045 |
1300 | UC_UTILITY_ARCHIVE | 1448031 | AH | TRUE 0030 |
1300 | UC_UTILITY_ARCHIVE | 1448031 | MELD | TRUE 0030 0030 |
1337 | UC_UTILITY_ARCHIVE | 1449177 | AH | TRUE 0045 |
1337 | UC_UTILITY_ARCHIVE | 1449177 | MELD | TRUE 0045 0045 |
2101 | UC_UTILITY_ARCHIVE | 1231871 | AH | TRUE 0045 |
2101 | UC_UTILITY_ARCHIVE | 1231871 | MELD | TRUE 0045 0045 |
3001 | UC_UTILITY_ARCHIVE | 1455082 | AH | TRUE 0045 |
3001 | UC_UTILITY_ARCHIVE | 1455082 | MELD | TRUE 0045 0045 |
0 | UC_UTILITY_REORG | 31 | AH | TRUE 0045 TRUE 0010 |
0 | UC_UTILITY_REORG | 31 | MELD | TRUE 0045 0045 |
0 | UC_UTILITY_REORG | 31 | OBJECT_AUDIT | TRUE 0030 TRUE |
0 | UC_UTILITY_REORG | 31 | RH | TRUE 0030 TRUE 0010 |
0 | UC_UTILITY_REORG | 31 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |
1294 | UC_UTILITY_ARCHIVE | 1447006 | AH | TRUE 0045 |
1294 | UC_UTILITY_ARCHIVE | 1447006 | MELD | TRUE 0045 0045 |
1044 | UC_UTILITY_ARCHIVE | 3168011 | AH | TRUE 0045 |
1044 | UC_UTILITY_ARCHIVE | 3168011 | MELD | TRUE 0045 0045 |
1044 | UC_UTILITY_REORG | 3168012 | AH | TRUE 0020 TRUE 0010 |
1044 | UC_UTILITY_REORG | 3168012 | MELD | TRUE 0010 0010 |
1044 | UC_UTILITY_REORG | 3168012 | OBJECT_AUDIT | FALSE 0030 TRUE |
1044 | UC_UTILITY_REORG | 3168012 | RH | TRUE 0020 TRUE 0010 |
1044 | UC_UTILITY_REORG | 3168012 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1127 | UC_UTILITY_ARCHIVE | 3198001 | AH | TRUE 0007 |
1127 | UC_UTILITY_ARCHIVE | 3198001 | MELD | TRUE 0045 0045 |
1127 | UC_UTILITY_REORG | 3199001 | AH | TRUE 0015 TRUE 0015 |
1127 | UC_UTILITY_REORG | 3199001 | MELD | TRUE 0002 0002 |
1127 | UC_UTILITY_REORG | 3199001 | OBJECT_AUDIT | FALSE 0015 TRUE |
1127 | UC_UTILITY_REORG | 3199001 | RH | TRUE 0015 TRUE 0010 |
1127 | UC_UTILITY_REORG | 3199001 | VERSION_CONTROL | TRUE 0100 TRUE 0010 |
1 | UC_UTILITY_REORG | 1543013 | AH | TRUE 0045 TRUE 0010 |
1 | UC_UTILITY_REORG | 1543013 | MELD | TRUE 0045 0045 |
1 | UC_UTILITY_REORG | 1543013 | OBJECT_AUDIT | FALSE 0045 TRUE |
1 | UC_UTILITY_REORG | 1543013 | RH | TRUE 0015 TRUE 0010 |
1 | UC_UTILITY_REORG | 1543013 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
1054 | UC_UTILITY_REORG | 1361079 | AH | TRUE 0020 TRUE 0010 |
1054 | UC_UTILITY_REORG | 1361079 | MELD | TRUE 0010 0010 |
1054 | UC_UTILITY_REORG | 1361079 | OBJECT_AUDIT | FALSE 0030 TRUE |
1054 | UC_UTILITY_REORG | 1361079 | RH | TRUE 0020 TRUE 0010 |
1054 | UC_UTILITY_REORG | 1361079 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1040 | UC_UTILITY_REORG | 1120036 | AH | TRUE 0020 TRUE 0010 |
1040 | UC_UTILITY_REORG | 1120036 | MELD | TRUE 0010 0010 |
1040 | UC_UTILITY_REORG | 1120036 | OBJECT_AUDIT | FALSE 0030 TRUE |
1040 | UC_UTILITY_REORG | 1120036 | RH | TRUE 0020 TRUE 0010 |
1040 | UC_UTILITY_REORG | 1120036 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1051 | UC_UTILITY_REORG | 1085354 | AH | TRUE 0020 TRUE 0010 |
1051 | UC_UTILITY_REORG | 1085354 | MELD | TRUE 0010 0010 |
1051 | UC_UTILITY_REORG | 1085354 | OBJECT_AUDIT | FALSE 0030 TRUE |
1051 | UC_UTILITY_REORG | 1085354 | RH | TRUE 0020 TRUE 0010 |
1051 | UC_UTILITY_REORG | 1085354 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1042 | UC_UTILITY_REORG | 1045280 | AH | TRUE 0020 TRUE 0010 |
1042 | UC_UTILITY_REORG | 1045280 | MELD | TRUE 0010 0010 |
1042 | UC_UTILITY_REORG | 1045280 | OBJECT_AUDIT | FALSE 0030 TRUE |
1042 | UC_UTILITY_REORG | 1045280 | RH | TRUE 0020 TRUE 0010 |
1042 | UC_UTILITY_REORG | 1045280 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1047 | UC_UTILITY_REORG | 1026020 | AH | TRUE 0005 TRUE 0035 |
1047 | UC_UTILITY_REORG | 1026020 | MELD | TRUE 0010 0010 |
1047 | UC_UTILITY_REORG | 1026020 | OBJECT_AUDIT | FALSE 0030 TRUE |
1047 | UC_UTILITY_REORG | 1026020 | RH | TRUE 0005 TRUE 0035 |
1047 | UC_UTILITY_REORG | 1026020 | VERSION_CONTROL | TRUE 0010 TRUE 0015 |
2103 | UC_UTILITY_REORG | 1790001 | AH | TRUE 0045 TRUE 0010 |
2103 | UC_UTILITY_REORG | 1790001 | MELD | TRUE 0045 0045 |
2103 | UC_UTILITY_REORG | 1790001 | RH | TRUE 0030 TRUE 0010 |
2103 | UC_UTILITY_REORG | 1790001 | VERSION_CONTROL | TRUE 0045 FALSE 0000 |
2103 | UC_UTILITY_ARCHIVE | 1789001 | AH | TRUE 0045 |
2103 | UC_UTILITY_ARCHIVE | 1789001 | MELD | TRUE 0045 0045 |
1602 | UC_UTILITY_ARCHIVE | 1662001 | AH | TRUE 0007 |
1602 | UC_UTILITY_ARCHIVE | 1662001 | MELD | TRUE 0045 0045 |
1002 | UC_UTILITY_ARCHIVE | 1663001 | AH | TRUE 0045 |
1002 | UC_UTILITY_ARCHIVE | 1663001 | MELD | TRUE 0045 0045 |
1052 | UC_UTILITY_ARCHIVE | 1317066 | AH | TRUE 0045 |
1052 | UC_UTILITY_ARCHIVE | 1317066 | MELD | TRUE 0045 0045 |
1047 | UC_UTILITY_ARCHIVE | 1026069 | AH | TRUE 0045 |
1047 | UC_UTILITY_ARCHIVE | 1026069 | MELD | TRUE 0045 0045 |
1052 | UC_UTILITY_REORG | 1317068 | AH | TRUE 0010 TRUE 0010 |
1052 | UC_UTILITY_REORG | 1317068 | MELD | TRUE 0010 0010 |
1052 | UC_UTILITY_REORG | 1317068 | OBJECT_AUDIT | FALSE 0030 TRUE |
1052 | UC_UTILITY_REORG | 1317068 | RH | TRUE 0010 TRUE 0010 |
1052 | UC_UTILITY_REORG | 1317068 | VERSION_CONTROL | TRUE 0010 TRUE 0010 |
1604 | UC_UTILITY_ARCHIVE | 1668001 | AH | TRUE 0045 |
1604 | UC_UTILITY_ARCHIVE | 1668001 | MELD | TRUE 0045 0045 |
1603 | UC_UTILITY_ARCHIVE | 1667001 | AH | TRUE 0045 |
1603 | UC_UTILITY_ARCHIVE | 1667001 | MELD | TRUE 0045 0045 |
1601 | UC_UTILITY_ARCHIVE | 1666001 | AH | TRUE 0045 |
1601 | UC_UTILITY_ARCHIVE | 1666001 | MELD | TRUE 0045 0045 |
1600 | UC_UTILITY_ARCHIVE | 1665001 | AH | TRUE 0045 |
1600 | UC_UTILITY_ARCHIVE | 1665001 | MELD | TRUE 0045 0045 |
1500 | UC_UTILITY_ARCHIVE | 1664001 | AH | TRUE 0045 |
1500 | UC_UTILITY_ARCHIVE | 1664001 | MELD | TRUE 0045 0045 |
1602 | UC_UTILITY_REORG | 1602001 | AH | TRUE 0010 TRUE 0040 |
1602 | UC_UTILITY_REORG | 1602001 | MELD | TRUE 0010 0010 |
1602 | UC_UTILITY_REORG | 1602001 | OBJECT_AUDIT | FALSE 0030 TRUE |
1602 | UC_UTILITY_REORG | 1602001 | RH | TRUE 0010 TRUE 0040 |
1602 | UC_UTILITY_REORG | 1602001 | VERSION_CONTROL | TRUE 0000 TRUE 0010 |
1042 | UC_UTILITY_ARCHIVE | 1045179 | AH | TRUE 0045 |
1042 | UC_UTILITY_ARCHIVE | 1045179 | MELD | TRUE 0045 0045 |
1604 | UC_UTILITY_REORG | 1604001 | AH | TRUE 0045 TRUE 0010 |
1604 | UC_UTILITY_REORG | 1604001 | MELD | TRUE 0045 0045 |
1604 | UC_UTILITY_REORG | 1604001 | RH | TRUE 0030 TRUE 0010 |
1604 | UC_UTILITY_REORG | 1604001 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |
1603 | UC_UTILITY_REORG | 1603001 | AH | TRUE 0045 TRUE 0010 |
1603 | UC_UTILITY_REORG | 1603001 | MELD | TRUE 0045 0045 |
1603 | UC_UTILITY_REORG | 1603001 | RH | TRUE 0030 TRUE 0010 |
1603 | UC_UTILITY_REORG | 1603001 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |
1601 | UC_UTILITY_REORG | 1601001 | AH | TRUE 0045 TRUE 0010 |
1601 | UC_UTILITY_REORG | 1601001 | MELD | TRUE 0045 0045 |
1601 | UC_UTILITY_REORG | 1601001 | RH | TRUE 0030 TRUE 0010 |
1601 | UC_UTILITY_REORG | 1601001 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |
1600 | UC_UTILITY_REORG | 1596001 | AH | TRUE 0045 TRUE 0010 |
1600 | UC_UTILITY_REORG | 1596001 | MELD | TRUE 0045 0045 |
1600 | UC_UTILITY_REORG | 1596001 | RH | TRUE 0030 TRUE 0010 |
1600 | UC_UTILITY_REORG | 1596001 | VERSION_CONTROL | TRUE 0045 FALSE 0003 |