Default partitioning scheme

The default partitioning scheme is predefined by FTM SWIFT and can be installed easily, see Setting up a partitioned message audit log. For this scheme, the message audit log is subdivided into 4 partitions. A single partition is continuously active from Monday to Sunday 0:00 UTC, when the next partition takes over the flow of data to log. After a complete cycle of 4 weeks the first partition is active again. This is indicated in Figure 1.

Figure 1. Four partitions with one partition per week. Days per partition = 7 and partitions per cycle = 4. The values of Pi can be interpreted as values of the partition indicator or as partition numbers.
Figure cannot be shown
The partition indicator for the default partitioning scheme is specified as follows:
  • Partition indicator type: "user"
  • Days per partition: 7
  • Partitions per cycle: 4
The definition from the DB2® side has the following characteristics:
  • The table space of the base table is subdivided into 4 partitions.
  • There are 8 auxiliary tables, because the 2 LOB columns need a separate table for each partition.
  • The partitioning index based on the partition indicator specifies in the PART clause the upper key limit value 1 for the first partition, value 2 for the second, and so on.