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

    The transactions limit for checkpoints is determined by the
    setting of the RDM$BIND_CKPT_TRANS_INTERVAL logical name. If
    RDM$BIND_CKPT_TRANS_INTERVAL is defined as a system logical set
    to 10, each process will checkpoint after 10 transactions unless
    a user redefines the RDM$BIND_CKPT_TRANS_INTERVAL logical to a
    different value. That is, if a user defines RDM$BIND_CKPT_TRANS_
    INTERVAL as a process logical and sets a value of 5, that user
    will checkpoint after 5 transactions.

    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 transactions interval, divide the
    total count for transaction intervals by the total number of
    checkpoints. If the total count for transaction intervals is
    800 and the total number of checkpoints is 100, then the average
    number of transactions between checkpoints is 8.

          800 / 100 = 8

    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: seconds" field explains how to
    determine the average interval for time checkpoints.
Close Help