To ensure that MIMIX will properly replicate temporal tables and their associated history files, the MIMIXOWN user profile must be an allowed user of the QIBM_DB_SECADM function on all systems within the MIMIX instance.
Other requirements are:
-
All systems in the data group must be running IBM i 7.3 or higher.
-
Both tables must be identified by data group object entries and file entries as required for the type of replication performed by the data group.
-
The data group must assign both tables to the same database apply session. This is controlled by value specified for the Apply session element of the File and tracking entry options (FEOPT) in the data group and in the specific data group entries.
If MIMIXOWN is not granted function usage authorization to QIBM_DB_SECADM on both source and target systems, MIMIX will not be able to properly apply journal entries for the temporal table and the history table.
If MIMIX attempts to replicate a temporal table and its history table when MIMIXOWN has not been granted function usage, one of the following will occur, depending on how you have configured the files for replication:
-
If replication processes include a user journal, the database apply process will place the tables on hold.
-
If replication processes use only the system journal, MIMIX will process a create for a file that does not exist on the target system and will process attribute-only and authority-only changes. Activity entries for subsequent changes to the created file will fail and be set to Failed Apply. Requests to synchronize file data (SYNCOBJ) will fail if the file already exist on the target system.