Documentation for TMP$STATE field in TMP$DATABASE table

投稿者:: Quinn Wildman

概要: The new TMP$STATE field is not documented in the InterBase 7.5 documentation. It is documented here.

TMP$STATE is a new CHAR(31) field for the TMP$DATABASE table introduced in InterBase 7.5.

TMP$STATE is used to initiate some maintenance operations on an ad hoc basis as follows:

UPDATE TMP$DATABASE SET TMP$STATE = {'FLUSH' | 'RECLAIM' | 'SWEEP'};
COMMIT;

The 'FLUSH' is a hook into the new feature to schedule commands to the OS buffer cache to write all database modifications to disk.

The 'RECLAIM' will trigger memory reclamation of stored procedures and triggers and a pass over the server's memory heaps to return reconstituted memory blocks to the OS.

'SWEEP' is the normal database sweep operation.


次からのサーバー応答:: ETNASC02