Chapter 6. GT.M Journaling

Revision History
Revision V6.0-001/1 22 March 1013
Revision V6.0-001 27 February 2013

In “-EXtract[=<file-name>|-stdout], added information about the gtm_extract_nocol environment variable.

Revision V6.0-000/1 21 November 2012

Updated SET -JOURNAL Options ” and the journaling limits for V6.0-000.

Revision V5.5-000/4 6 June 2012
Revision V5.5-000/3 2 May 2012

Added the definition of tid.

Revision V5.5-000/2 19 March 2012

Updated the Journal Extract Formats section for V5.5-000.

Revision 3 26 December 2011

Added the Journal Extract format for ZTRIG.

Revision 2 2 December 2011 Improved the description of -EXTRACT and corrected the heading levels of some sections under MUPIP JOURNAL.
Revision V5.4-002B 24 October 2011 Conversion to documentation revision history reflecting GT.M releases with revision history for each chapter.

Table of Contents

Introduction
Journal Files
Recovery from a Journal File
rolled_bak* files
Journal Files Access Authorization
Triggers in Journal Files
BEFORE_IMAGE Journaling
NOBEFORE_IMAGE Journaling
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE
Broken Transaction File
Lost Transaction File
Journaling Benefits
Backup Journal Files
Select database files for Journaling
Fencing Transactions
Deciding Whether to Use Fencing
VIEW Keywords
$VIEW() Keywords
SET
SET Object Identifying Qualifiers
SET Action Qualifiers
Examples for MUPIP SET
JOURNAL
Journal Action Qualifiers
Journal Direction Qualifiers
Journal Time Qualifiers
Journal Sequence Number Qualifiers
Journal Control Qualifiers
Journal Selection Qualifiers
Journal Extract Formats