Chapter 5. General Database Management

Revision History
Revision V7.1-005 18 September 2024
Revision V7.1-004 27 June 2024
Revision V7.1-003 23 November 2023
Revision V7.1-002 19 September 2023
Revision V7.1-001 26 June 2023
Revision V7.1-000 04 April 2023
Revision V7.0-004 20 September 2022
Revision V7.0-003 24 June 2022
  • In “-Region”, specify that INTEG processes regions based on the order specified in the region-list

  • In “-REGION=region, specify that DUMPFHEAD selects regions based on the order specified in the region-list.

Revision V7.0-002 29 March 2022
  • In “BACKUP”, correct the syntax of -NOONLINE; specified that MUPIP BACKUP selects regions based on the user-specified order

  • In “-PROblksplit”, add new section

Revision V7.0-001 24 November 2021
Revision V7.0-000 12 February 2021
Revision V6.3-014 06 October 2020
Revision V6.3-013 30 June 2020
  • In “BACKUP”, Indicate that "-B" is not sufficient to indicate a "-BYTESTREAM" backup. It must be at least "-BY".

  • In “-[NO]A[UTORELEASE”, specify that GT.M does not honor MUPIP SET commands even when -AUTORELEASE is set.

  • In “Operations - Standalone and Concurrent Access, remove a redundant and add a reference to the MUPIP Command Summary table.

  • In “SET”, Remove a bullet point about standalone access.

  • In MUPIP Command Summary”, add a new Standalone Access column; correct note about EXTRACT; change -B[YTESTREAM] to -BY[TESTREAM]; change STD[NULLSUBS] to STD[NULLCOLL]; remove SPIN[_SLEEP_LIMIT]

Revision V6.3-012 08 April 2020
Revision V6.3-011 20 December 2019
Revision V6.3-010 31 October 2019
Revision V6.3-009 27 June 2019
Revision V6.3-008 24 April 2019
  • In “SET”, add information about the -[NO]ENCYRPTABLE and -ENCRYPTIONCOMPLETE qualifiers

Revision V6.3-007 04 February 2019
Revision V6.3-006 26 October 2018
Revision V6.3-005 03 July 2018
  • In “-Database”, remove reference to magnetic tape

  • In “BACKUP”, change "breaking a disk mirror" to "disk mirroring".

  • In “EXTRACT”, remove reference to magnetic tape, add -NULL_IV, and corrections for -SELECT.

Revision V6.3-004 23 March 2018
Revision V6.3-003 12 December 2017
Revision V6.3-002 22 August 2017
  • In “SET”, correct abbreviations for -SLEEP_SPIN_COUNT and -SPIN_SLEEP_LIMIT.

Revision V6.3-001 20 March 2017
Revision V6.2-002 17 June 2015
  • In “SET”, added the [NO]EPOCHTAPER and -[NO]DEFER_ALLOCATE qualifiers.

  • In “INTEG ”, added a recommendation against running ONLINE INTEG as the same time as MUPIP REORG.

  • In “RUNDOWN” and “FREEZE ”, specified that a successful rundown turns off any MUPIP FREEZE.

Revision V6.2-001 27 February 2015
  • In “LOAD”, added the new ONERROR qualifier and information about automatically detecting file format (BINARY/ZWR/GO).

  • In “EXTRACT”, added the REGION qualifier.

  • In “SIZE” and “INTEG ” , added information about adjacency reporting.

  • In In “TRIGGER”, added information about return status, LGTRIG journal records, and specified that MUPIP TRIGGER -SELECT works even if a multi-line XECUTE string does not terminate with a newline character.

  • In “TRIGGER”, added trigger expression source line limit, the UPGRADE qualifier, and a note about how MUPIP TRIGGER operates within a TP transaction.

  • In “Introduction”, specified that GT.M processes performing read operations can access databases on a filesystem mounted read-only.

  • Added the new “RCTLDUMP” command.

  • Added the new “-Relinkctl” qualifier for MUPIP RUNDOWN.

Revision V6.1-000 01 August 2014
  • In “Introduction”, added a note recommending against runing any GT.M component as root.

Revision V6.0-003 27 January 2014
Revision V6.0-001/2 10 April 1013

In “BACKUP”, added notes for "Before starting a MUPIP BACKUP".

Revision V6.0-001/1 22 March 1013

Improved the formatting of all command syntaxes.

Revision V6.0-001 27 February 2013
  • In “BACKUP”, added information about the BKUPRUNNING message and added information on the handling of KILLs in Progress and Abandoned Kills during a backup.

  • In “EXTRACT”, added the description of -STDOUT.

  • In MUPIP INTEG, specified the threshold limit of incorrectly marked busy errors in “-MAP” and added information on clearing KILLs in Progress and Adandoned Kills.

Revision V6.0-000/1 21 November 2012
Revision V6.0-000 19 October 2012

In MUPIP SET, added the description of “-INST_freeze_on_error”.

Table of Contents

Introduction
Operations - Standalone and Concurrent Access
MUPIP
Commands and Qualifiers
BACKUP
CREATE
DOWNGRADE
DUMPFHEAD
ENDIANCVT
EXIT
EXTEND
EXTRACT
FREEZE
FTOK
HASH
INTEG
INTRPT
JOURNAL
LOAD
RCTLDUMP
REORG
REPLICATE
RESTORE
RUNDOWN
SEMAPHORE
SET
SIZE
STOP
TRIGGER
UPGRADE
MUPIP Command Summary