Features

The System Definition Table Rotation module allows you to define a new table rotation, a new table extension or modify an existing one.

Figure 1. Database Rotation
  • Name: auto-generated from table name
  • Duration: overall time parameter for function
  • Initialized: sets function as active (true) or inactive (false)
  • Rotations: number of tables to be created within Duration
  • Type: indicates Extension (archiving) or Rotation (deletion) functionality

When you define a new rotation, a schedule is created and new data is subsequently written to one of the tables in the rotation group. You'll notice the that the group includes the original table plus a number of additional tables. Be aware that deleting a rotation will delete the additional tables and all the data, therefore the rotation should not be deleted if the data is needed.

Implementation

See individual pages to implement either table rotation or table extension.