KI_RESET_CACHEID

Reset a table's cache ID

Synopsis:
CALL KI_RESET_CACHEID handle TO status
status = 'ki_reset_cacheid( handle )
ArgumentEnumerationPurpose
handleHandle
statusKDB_ERROR_ENUMReturn status
>KI_RESET_CACHEID

KI_RESET_CACHEID

This call will set a table's cache ID in the catalog to 0, which will prevent future version increments on table writes. Use this on tables you no longer wish to open in cached mode to reduce contention on the catalog. The handle must be opened in either X or U mode.

History
Introduced in KCML 7.16
See Also:
KI_CLOSE, KI_CLOSE_TABLE, KI_DB_NAME, KI_DROP_TABLE, KI_EXTEND, KI_GET_HANDLE, KI_GET_SERIAL, KI_INFO, KI_INITIALISE, KI_LOCK_ALL, KI_OPEN, KI_PREFETCH_ROWS, KI_REBUILD, KI_SET_DATESTAMP, KI_SET_SERIAL, KI_SET_TIMESTAMP, KI_SET_USERSTAMP, KI_UNLOCK_FILE, KI_VERIFY
KCML database status codes