Partition indicator column
The partition indicator column is used to implement the partitioning scheme used by a partitioned message audit log. Its domain is made up of a finite number of positive integer values (pi). FTM SWIFT derives them from a GMT timestamp.
You can customize the rule for how this is done for each OU through attributes of the CO DniMsgAudit by setting the attributes described in Table 1.
| CT attribute | Description |
|---|---|
| DniTimeAdjustPartMsgAudit | Time Adjustment: The number of hours, which (like a Db2® time zone) is added to the GMT timestamp before the partition indicator is derived by FTM SWIFT. The number specified determines the hour of the day when the partition indicator jumps to the next value. If this parameter is not specified, the partition indicator switches to a new value at 0:00 (midnight) GMT on the last day of the interval determined by the value of the DniPartIndTypePartMsgAudit attribute. If this time is inappropriate, use the DniTimeAdjustPartMsgAudit parameter to adjust this time. Use and example: The partition indicator is stored in column AM_PARTITION_IND of the base table of a partitioned message audit log. This column is to be included into the partitioning index. To cause FTM SWIFT to switch partitions at 21:00 GMT, specify -3 (to switch 3 hours before midnight) or 21 (to switch 21 hours after midnight). Default: A value of 0 is assumed if the attribute value is not specified. |
| DniPartIndTypePartMsgAudit | Partition Indicator Type: A value specified for this attribute indicates (1) that a partitioned message audit log is used, and (2) the type of partition indicator that is to be recorded for each entry in the message audit log. The partition indicator is stored as a SMALLINT in column AM_PARTITION_IND of the base table of the audit log. Value domain:
|
| DniUserDaysPerPartPartMsgAudit | Days per partition: If the partition indicator type user is specified, this attribute specifies the number of days in succession during which the same partition indicator value is generated. For example, a value of 7 indicates that the value which is generated for the partition indicator changes every seven days. It is the purpose of this attribute to specify for how many days the same logical partition of the message audit log is used. On the Db2 side, the physical partitions must be created accordingly if this attribute is to have this meaning. For more information, see User-defined partition indicator types. Default: A value of 7 is assumed if the attribute value is not specified. |
| DniUserPartsPerCycPartMsgAudit | Partitions per cycle: If the partition indicator type user is specified, this attribute specifies the number of distinct values that make up the domain of the partition indicator. For example, a value of 4 specifies that the domain of the partition indicator consists of four values which are 1, 2, 3, and 4. The value of this parameter matches to the number of logical partitions of the message audit log. Therefore, the value of this attribute also indicates the number of logical partitions that are successively used during one use cycle. For more information, see User-defined partition indicator types. Default: A value of 4 is assumed if the attribute value is not specified. |
- The values have a temporal meaning in the sense that any point in time is uniquely related to a positive integer value pi.
- The partition indicator starts with the value pi = 1.
- The value pi increases over time in steps by 1, until a maximum value is reached, after which, with the next change, the value reverts to 1.
- For type month the maximum value is 12, for type dow (day-of-week) it is 7, for type dom (day-of-month) it depends on the current month and for type user the maximum value can be specified explicitly.