Operation - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Product family
Assure MIMIX™ Software
Product name
Assure MIMIX
Assure MIMIX Administrator Reference
First publish date

When the APMNT policy is enabled, starting the database apply process for a data group that is configured for single-threading also starts an asynchronous access path maintenance job that remains active when the apply process is active. When the database apply process opens a physical file to apply a replicated transaction, the apply process also checks whether the file and any associated logical files affected by the transaction are eligible for access path maintenance optimization.

For eligible files, the apply process changes the access path maintenance (MAINT) attribute from *IMMED to *DLY and keeps track of the number of record changes to the physical file. When the record count exceeds 100 records and a predetermined threshold (five percent of the file records being applied), the apply process requests that access path maintenance job “catch up” on the delayed maintenance associated with that physical file. The access path maintenance job performs delayed maintenance on eligible files, using additional transient jobs if needed. The file’s MAINT attribute is changed back to *IMMED when the apply process closes the file or when the apply process ends.

Note: Any eligible files that were already set to *DLY before being opened by the apply process will remain set to *DLY after the apply process closes the files.

MIMIX tracks any failed attempts to change a file’s MAINT attribute back to *IMMED but does not report these as errors on the associated data group file entry while the data group is active.

When the database apply process ends, the last apply session to end notifies the access path maintenance job, then ends. The access path maintenance job uses additional jobs, if needed, to change the access path maintenance attribute to *IMMED on all files that MIMIX had previously changed to *DLY. Any failed requests to change the MAINT attribute are retried. Before the maintenance jobs end, any files that could not be changed to *IMMED are identified as having an access path maintenance failure on the associated data group file entry.