Chapter 6. GT.M Journaling

Revision History
Revision V7.1-002 19 September 2023
Revision V7.1-000 04 April 2023
Revision V7.0-002 29 March 2022
  • In “JOURNAL ”, removed a reference to working with journal files on tape

Revision V7.0-001 24 November 2021
Revision V7.0-000 12 February 2021
Revision V6.3-013 30 June 2020
Revision V6.3-012 08 April 2020
Revision V6.3-010 31 October 2019
Revision V6.3-009 27 June 2019
Revision V6.3-007 04 February 2019
Revision V6.3-006 26 October 2018
Revision V6.3-004 23 March 2018
Revision V6.3-003 12 December 2017
Revision V6.3-002 22 August 2017
Revision V6.3-001 20 March 2017
Revision V6.2-001 27 February 2015

In Journal Extract Formats”, added information about the LGTRIG field.

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.

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
Epoch
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