Example 2

The following example uses the SYNC option to ensure that a sync point is forced every four hours if any transactions are committed within that interval.

Building on the previous example, AuditTimer forces an audit file close between 5:00 p.m. and 7:00 p.m. each weekday evening. On the weekend (Saturday, Sunday, and up to Monday at 5:00 PM), however, the audit file can be up to three days old. AuditTimer ensures that a sync point will occur within four hours of any transaction.

MONDAY 5 PM 2 HOURS

MONDAY 7:10 PM 24 HOURS

TUESDAY 5 PM 2 HOURS

TUESAY 7:10 PM 24 HOURS

WEDNESDAY 5 PM 2 HOURS

WEDNESDAY 7:10 PM 24 HOURS

THURSDAY 5 PM 2 HOURS

THURSDAY 7:10 PM 24 HOURS

FRIDAY 5 PM 2 HOURS

FRIDAY 7:10 PM 24 HOURS

SATURDAY 8 AM 3 DAYS SYNC 4 HOURS