RMUDISPLAY72.HLB  —  Overview  Fields  Checkpoint Statistics screen, interval:_seconds_field
    This field displays the sum of the intervals between time in
    seconds checkpoints for all processes. For example, if Process
    1 checkpoints after 500 seconds, the time in seconds category is
    incremented by 500. If Process 2 checkpoints after 600 seconds,
    the time in seconds category is incremented by an additional 600.
    Statistics for the other two interval categories are displayed in
    the "interval: AIJ blks" and "interval: tx count" fields.

    If CHECKPOINT TIMED EVERY 600 SECONDS is specified with the
    SQL ALTER DATABASE statement, each process checkpoints every
    10 minutes.

    Keep in mind that checkpointing influences recovery time. The
    main reason to consult checkpoint statistics is to find the
    average interval per checkpoint. You can use the information in
    the total count column to compute this average. For each category
    of checkpoint reason, use the average interval per checkpoint to
    help you decide if a checkpointing interval should be adjusted,
    and by how much.

    If most of the checkpoints for a database are triggered by a
    particular checkpoint limit, that limit may be set too high,
    or the other two limits may be set too low. You can determine
    the average interval per checkpoint for each type of checkpoint
    limit. After you have this information, you can reset the limits
    so that each type of checkpoint limit triggers approximately the
    same number of checkpoints, which results in optimal performance.

    To compute the average time interval, divide the total count for
    seconds interval by the total number of checkpoints. If the total
    count for the seconds field is 59,300 and the total number of
    checkpoints is 100, the average number of seconds between each
    time-triggered checkpoint is 593.

          59,300 / 100 = 593

    The help for the "interval: AIJ blks" field explains how to
    determine the average interval for .aij file growth checkpoints.

    The help for the "interval: tx count" field explains how to
    determine the average interval for transaction checkpoints.
Close Help