Chapter 5. General Database Management
 

In “-STATS ”, -STATS require it to be specified in full

In “CREATE”, Fix minimum acceptable chars for CREATE

In “FREEZE ”, fix minimum acceptable chars for FREEZE

In “INTEG ”, fix minimum acceptable chars for INTEG

In “RESTORE”, fix minimum acceptable chars for RESTORE

In “SET”, fix minimum acceptable form of SET

In “MUPIP Command Summary”, add summary table entry for mupip semaphore

In “-Mutex_slots”, specify that MUTEX_SLOTS works only on AIX

In “-INST_freeze_on_error”, GT.M creates StatsDB regions with INST_FREEZE_ON_ERROR disabled

In “-DMAXblocksize”, revise DMAXBLOCKSIZE description

In “-IMAXblocksize”, Revise IMAXBLOCKSIZE description

In “-Online ”, Remove V4 reference

In “DOWNGRADE”, Remove reference to V4

In “EXTEND”, specify maximum blocks for V6 and V7

In “FTOK ”, Add missing details

In “INTEG ”, document new -IMAXBLOCKSIZE and -DMAXBLOCKSIZE INTEG qualifiers

In “REORG ”, document -MIN_LEVEL qualifier

In “SET”, Added the new -INDEX_RESERVED_BYTES and -DATA_RESERVE_BYTES qualifiers

In “MUPIP Command Summary”, document -[NO]{SEND|RECV}BUFFSIZE, -MIN_LEVEL, -{I|D}MAXBLOCKSIZE, and -{INDEX|DATA}_RESERVED_BYTES qualifiers

In “-DATA_reserved_bytes”, document default data reserved bytes value

In “-INDEX_reserved_bytes”, document index reserved bytes default

In “-PROblksplit”, enhance description

In “-REServed_bytes”, document default reserved bytes value

In “-Version”, adjust format

In “-SLeep_spin_count ”, correct typo

In “-Spin_sleep_mask”, Fix typo

In “-Truncate”, TRUNCATE applies only to BG databases

In “-UPgrade”, add restriction on other concurrent REORGs

In “-PROblksplit”, specify that the default is 0 and other changes

In “-V6”, add information about -NOV6

In “DOWNGRADE”, DOWNGRADE command limitation

In “DUMPFHEAD”, update abbreviation

In “UPGRADE ”, MUPIP UPGRADE starts the upgrade of a DB to V7m

In “RCTLDUMP”, F135385 - added the "superseded" counter(the times an object has been replaced)

In “SIZE”, corrected syntax of MUPIP SIZE -SELECT.

In “STOP ”, MUPIP STOP three times within a minute shuts down GT.M process

In “MUPIP Command Summary”, DOWNGRADE options are no longer supported. REORG -UPGRADE requires standalone access

In “-Downgrade”, Note limitation onV7->V6

In “-UPgrade”, REORG -UPGRADE requires standalone access

In “-StatsDB_allocation ”, Clarify statsdb_allocation behavior

In “-Version”, Note V6->V7 limitation

In “-RETry ”, specify that -RETRY=count is the number of retry attempts.

In “-Region”, autodb

In “-V6”, MUPIP CREATE -V6 and the env var

In “CREATE”, add MUPIP CREATE -V6; Note about AutoDBs

In “-Truncate”, Update TRUNCATE notes for standalone

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.

In “BACKUP”, correct the syntax of -NOONLINE; specified that MUPIP BACKUP selects regions based on the user-specified order

In “-PROblksplit”, add new section

In “-Record”, added a note of the added timestamping functionality of -RECORD.

In “-RETry ”, add new section

In “-Lck_shares_db_crit”, add reference to the -[NO]L[OCK_CRIT] section.

In “BACKUP”, add -RETRY and -SHOWPROGRESS

In “-FLUSH”, add clarifications

In “SET”, added -STATSD[B_ALLOCATION] qualifier; corrected ordering of LCK_SHARES_DB_CRIT

In “MUPIP Command Summary”, The -STATSD[B_ALLOCATION] qualifier expects to get an integer.

In “-StatsDB_allocation ”, change the minimum statsdb_allocation value to 128.

In “MUPIP Command Summary”, removed -DBG as it is for internal FIS use.

In “-REServed_bytes”, Update maximum Reserved Bytes

In “FTOK ”, add new qualifiers and functionality.

In “SEMAPHORE”, add SEMAPHORE command

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]

In “RESTORE”, added an example and made content improvements.

In “SET”, add -FULLBLKWRT

In “SIZE”, correct and expand the subscript documentation.

In “MUPIP Command Summary”, add -FULLBLKWRT

In “GDE Command Qualifier Summary”, add -FULLBLKWRT

In “SIZE”, enhance the 2 sigma explanation

In “REORG ”, add -DOWNGRADE and -UPGRADE.

In “SIZE”, mupip size -subscript changes

In “MUPIP Command Summary”, add qualifiers for REORG; add -CORRUPTDB

In “REORG ”, Add -keep, -nocoalesce, -nosplit, -noswap

In “MUPIP Command Summary”, add entries for -GVPATFILE and -STOPRECEIVERFILTER.

In “-Read_only”, add a note on using -NOREAD_ONLY.

In “SET”, add information about the -[NO]ENCYRPTABLE and -ENCRYPTIONCOMPLETE qualifiers

In “BACKUP”, Add caution regarding NOPREVLINK option of -NEWJNLFILE qualifier

In “SET”, add -trigger_flush and writes_per_flush

In “MUPIP Command Summary”, add [NO] for LOSTTRANS and BROKENTRANS qualifiers

In “-Encrypt”, add a note about the FIS recommendation for rotating the encryption key of your database.

In “-Global_buffers”, The max global buffers is 2,097,151

In “-NETtimeout”, add RESTORE as a compatible MUPIP command.

In “-FOrmat”, improve the description of the GO format.

In “FREEZE ”, tweaks for clarity

In “-[NO]A[UTORELEASE”, fix typo

In “-ONLine”, correct typos

In “RESTORE”, change file-list to bytestrm-bkup-list, add -NETTIMEOUT syntax and reference, and improve the description.

In “SET”, remove -REPLICATION from the destination list,-STANDALONENOT and -PARTIAL_RECOV_BYPASS, and minor changes to the definition of MUPIP SET.

In “-ACcess_method ”, fix a typo.

In “-DEFER_Allocate ”, improve the description of DEFER_ALLOCATE.

In “-Epochtaper”, add more information about epoch tapering.

In “-REPlication”, remove -FILE and -REGION from the list of incompatible qualifiers.

In “-STATS ”, specify that a process disables itself from maintaining shared statistics when it fails to open a statsdb.

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.

In “Examples for MUPIP REORG”, add a simple REORG -ENCRYPT example to encrypt an unencrypted database.

In “-Null_iv”, correct qualifier format and add missing information.

In “-Select”, change prefix to suffix; add clarity about using suffixes; remove the point about supporting parenthetical list such as (a,B,C).

In “CREATE”, Max # of blocks is 992Mi

In “MUPIP Command Summary”, remove the entry for -updhelper

In “-Encrypt”, made minor refinements and add the requirement of an an encryption setup for -ENCRYPTABLE.

In “-Read_only”, note about semaphores

In “-STATS ”, Expand information on STATS

In “-STDnullcoll ”, change STATs to STDnullcoll and remove the duplicate STDnullcoll section

In “-Hard_spin_count”, improve the description.

In “BACKUP”, change -COMPREHENSIVE to -DATABASE

In “FREEZE ”, add information about DBFREEZEON and DBFREEZEOFF messages that MUPIP FREEZE sends to the system log.

In “Operations - Standalone and Concurrent Access”, remove redundant entry for MUPIP BACKUP

In “SET”, add entries for -Null_subscripts, -Stdnullcoll, and -Read_only qualifiers.

In “MUPIP Command Summary”, add a new GT.M Version column - maintainable since GT.M V5.4-002.

In “-Lock_space”, specify 262144 as the maximum LOCK_SPACE.

In “-Read_only”, add conflict handling explanation

In “-Spin_sleep_mask”, add new section.

In “SET”, correct abbreviations for -SLEEP_SPIN_COUNT and -SPIN_SLEEP_LIMIT.

In “-REPLInstance ”, admonished that the source server needs to be started at least once before taking a backup of the replication instance file.

In “Examples for MUPIP INTEG”, added the explanation of % Used

In “Examples for MUPIP REORG”, added an example for MUPIP REORG.

In “-FOrmat”, added changes for -null_iv qualifier.

In “-Null_iv”, tweaked wording

In “-Stats”, added STATS qualifier

In “-FOrmat”, added enhancements related to MUPIP LOAD -FORMAT.

In “-Onerror”, corrected the default and qualifier item description

In “-Stdin ”, added an Index entry

In “BACKUP”, removed d-DBG from MUPIP BACKUP qualifier list as it is for FIS internal use.

In “DOWNGRADE”, added information about the V63000A option and a note about performing MUPIP INTEG -ONLINE prior to downgrading a database file.

In “DUMPFHEAD”, added information about the MUPIP DUMPFHEAD command

In “FREEZE ”, added information about the [NO]ONLINE and [NO]AUTORELEASE qualifiers.

In “Operations - Standalone and Concurrent Access”, added a note about MUUSERLBK and MUUSERECOV errors.

In “REORG ”, -REGION= is a syntax error.

In “RUNDOWN”, added references to statistics database files

In “SET”, added the SPIN_SLEEP_LIMIT,SLEEP_SPIN_COUNT, ASYNCIO, LCK_SHARES_DB_CRIT, and STATS qualifiers.

In “SIZE”, added explanation for the 2 Sigma column of the report

In “TRIGGER”, added caution about relying on journaling of trigger -upgrade.

In “MUPIP Command Summary”, added FREEZE, DOWNGRADE, DUMPFHEAD commands and MUPIP INTEG and SET qualifiers for V6.3-001

In “GDE Command Qualifier Summary”, updated the table for V6.3-001.

In “-Encrypt”, added information about the -ENCRYPT qualifier; Added a note that reorg -encrypt does not support changing of encryption algorithms.

In “-DEFER_Allocate ”, removed references to HP-UX and Solaris.

In “-Epochtaper”, replaced "QDBRUNDOWN" with "-EPOCHTAPER"

In “-Qdbrundown”, added a note about the condition when the number of attached processes exceeds 32Ki.

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.

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.

In “Introduction”, added a note recommending against runing any GT.M component as root.

In “SET”, added the -Mutex_slots qualifier.

In “RUNDOWN”, added the -Override qualifier.

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.

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

Updated “TRIGGER” for V6.0-000.