RESET IN

From Lianjapedia
Revision as of 12:45, 4 February 2013 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Disable journaling in a specified workarea

Syntax

RESET IN <workarea | alias>

See Also

BEGIN TRANSACTION, COMPLETED(), ISMARKED(), ROLLBACK, ROLLBACK(), SET ROLLBACK

Description

The RESET IN command is used to disable Before Image Journaling (BIJ) in the specified workarea. When BEGIN TRANSACTION is issued, all currently open tables and all tables opened between BEGIN and END TRANSACTION will have BIJ invoked automatically. If BIJ is not required on a particular table, then the RESET IN command should be issued for the relevant workarea.

Example

// Clear BIJ in workarea suppliers
reset in suppliers