What tables are partitioned with ILM?

Products

• CA Automic Workload Automation - Automation Engine

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