Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

ITIM_RETRY_LIMIT

ITIM_RETRY_LIMIT <# of retries before returning ITIM_ERR>

In a multi-user environment, it is possible that an index may become out of sync with the data temporarily while another user is performing an update operation. Typically, error ITIM_ERR (160) is returned under these circumstances. It may be practical in some situations to retry the operation as the index is eventually updated. To accomplish this, the ITIM_ERR retry limit is configurable.

In addition, SNAPSHOT output now contains the value of the limit and the number of failed retry loops. Before this change, only the number of retries was reported by the SNAPSHOT.

Default: Typically 10 or 20

See Also

ITIM_RETRY_DEFER

TOCIndex