Automic Workload Automation

Expand all | Collapse all

RT table contains last year entries

  • 1.  RT table contains last year entries

    Posted 28 days ago
    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


  • 2.  RE: RT table contains last year entries

    Posted 28 days ago
    Are you certain that your reorg jobs are configured to process all of your clients?

    Which client numbers are on the older RT data rows?

    ------------------------------
    Pete (AE V11.2)
    1st place Winner of the 2016 Automic Automation Hero award
    Humble too!
    ------------------------------



  • 3.  RE: RT table contains last year entries

    Posted 28 days ago
    Hi ,

    I'm not sure how to find out the client number to which the content exists in RT table. Below is the example I get when I try to select the top few rows from RT table

    /****** Script for SelectTopNRows command from SSMS ******/
    SELECT TOP (1000) [RT_AH_Idnr]
    ,[RT_Type]
    ,[RT_Lnr]
    ,[RT_TimeStamp]
    ,[RT_MsgNr]
    ,[RT_Content]
    ,[RT_MsgInsert]
    FROM [DEV].[dbo].[RT]

    RT_AH_Idnr RT_Type RT_Lnr RT_TimeStamp RT_MsgNr RT_Content RT_MsgInsert
    1594775 ACT 1 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS(1)|00001|020012|0001594775|&LOGIN#|OPOT.LOGIN.MUCXS113|RSET
    1594775 ACT 2 00:05.0 20206 NULL &LOGIN#|OPOT.LOGIN.MUCXS113|
    1594775 ACT 3 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS(1)|00010|020013|0001594775|&HOST#|mucxs113_os|RSET
    1594775 ACT 4 00:05.0 20206 NULL &HOST#|mucxs113_os|
    1594775 ACT 5 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS(1)|00011|020014|0001594775|&USER#|uc4opot|RSET
    1594775 ACT 6 00:05.0 20206 NULL &USER#|uc4opot|
    1594775 ACT 7 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS(1)|00012|020015|0001594775|&SHELL#|bash|RSET
    1594775 ACT 8 00:05.0 20206 NULL &SHELL#|bash|
    1594775 ACT 9 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS|00004|010107|0001594775|&MY_NAME#|OPOT.JOB.SQL_REFRESH_SNAPSHOTS|RSET
    1594775 ACT 10 00:05.0 20206 NULL &MY_NAME#|OPOT.JOB.SQL_REFRESH_SNAPSHOTS|
    1594775 ACT 11 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS|00005|010108|0001594775|&ORACLE_USERID|.OPOT_PROD|RSET
    1594775 ACT 12 00:05.0 20206 NULL &ORACLE_USERID|.OPOT_PROD|
    1594775 ACT 13 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS|00006|010109|0001594775|&LOG_PATH|$HOME/log/|RSET
    1594775 ACT 14 00:05.0 20206 NULL &LOG_PATH|$HOME/log/|
    1594775 ACT 15 00:05.0 20237 NULL OPOT.JOB.SQL_REFRESH_SNAPSHOTS|00007|010110|0001594775|&PARAMETER|"p_str_par1 => 'SG'","p_str_par2 => 'RG_OPOT_INBOUND_DATA'","p_str_par3 => 'OPOT_OWNER'"|RSET



  • 4.  RE: RT table contains last year entries

    Posted 28 days ago
    The RT table holds report details.  The RH table holds a header record for each report.  Column RH_Client will give you the client number.

    ------------------------------
    Pete (AE V11.2)
    1st place Winner of the 2016 Automic Automation Hero award
    Humble too!
    ------------------------------



  • 5.  RE: RT table contains last year entries

    Posted 28 days ago
    Yes Peter. You are correct.
    However I'm not sure how to query which client is holding such a huge RT values . I mean not sure how I can compare the RH and RT table.

    Do you have any SQL query handy ? 

    Thank you


  • 6.  RE: RT table contains last year entries

    Posted 27 days ago
    Hi

    you could try:

    select COUNT(*), RH_CLIENT from RH
    group by RH_CLIENT
    order by 1 desc

    cheers, Wolfgang

    ------------------------------
    I know I do really know it!
    ------------------------------



  • 7.  RE: RT table contains last year entries

    Posted 28 days ago
    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!
    ------------------------------



  • 8.  RE: RT table contains last year entries

    Posted 28 days ago
    ​fwiw, we did have an issue in the past where entries were not cleaned up at all, though that was AH, not RT. The entries were bugged and missing content in a certain DB field, so they were not matched by a query from the reorg utility.

    So if you're reasonably certain you got the config right, and those still don't get cleaned up, contact support. At the time I pre-formulated an SQL statement to clean up, and they validated it for me. I do not recommend writing to the DB without their blessing, with consideration to the support state.

    Hth,