What tables are partitioned with ILM?

book

Article ID: 192490

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

What tables are included in ILM partitioning (and partition drops) with Automic Workload Automation?

Environment

This is based on the Automic Automation 12.3 DB Schema found here: https://docs.automic.com/documentation/webhelp/english/AA/12.3/AE/12.3/DB%20Schema/db/_structure/HTML/index.htm

Resolution

The following tables are included in ILM partitioning by default:

Statistical records (table A*)

    • ABLOB
    • ACA
    • ACLNT
    • ACMT
    • ACTEX
    • ACV
    • AFC
    • AH
    • AHG
    • AHGH
    • AJPCV
    • AJPFV
    • AJPOP
    • AJPOV
    • AJPP
    • AJPPA
    • AJPPC
    • AJPPF
    • AJPPO
    • AJPPV
    • AJPVA
    • APD
    • APD
    • APPF
    • APUD
    • APUDA
    • ARB
    • AUSR
    • AV
    • AWS

Reports (table R*)

    • RH
    • RT

Miscellaneous (such as messages and audit trails)

    • MELD
    • XAO
    • XRO

Some information on ILM can also be found in the documentation under Storing Groups of Partitions in Separate Containers and Managing ILM Partitions