Index

Index
Prev

Symbols

@ command

in GDE, @

A

Abandoned_kills qualifier

in DSE, CHANGE -FIleheader Qualifiers

Access_method qualifier

buffered global, memory mapped, Segment Qualifiers
changing, Segment Qualifiers
in GDE, Segment Qualifiers
with MUPIP SET, -Access_method

Action qualifiers, JOURNAL

Activate qualifier

with MUPIP REPLICATE, Activating a Passive Source Server

Active_processes show option, -SHow=show-option-list

Add command

example, -Segment
examples, Examples for ADD, Examples of ADD
in DSE, ADD
in GDE, Add

Adjacency qualifier

with MUPIP INTEG, -ADjacency

After qualifier

with MUPIP JOURNAL, Journal Time Qualifiers

Alignsize journal option, SET -JOURNAL Options

All command

in DSE, ALL

All qualifier

in DSE, Dump, Qualifiers of DUMP
in LKE, Clear, SHow

All show option, -SHow=show-option-list

Allocation journal option, SET -JOURNAL Options

Allocation qualifer

in GDE, Segment Qualifiers

Always fence option, Journal Control Qualifiers

Apply_after_image qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Autorollback qualifier

specifying , Starting the Receiver Server

AUTOSWITCHLIMIT

journal option in GDE, Region Qualifiers

Autoswitchlimit journal option, SET -JOURNAL Options

B

b*-tree, Database Structure

Global Variable Tree, Tree Organization

Backup command, BACKUP

examples, Examples for MUPIP BACKUP

Backward qualifier

in DSE, Shift, Qualifiers of SHIFT
with MUPIP JOURNAL, -RECover , Journal Direction Qualifiers

backward recovery, -RECover

definition, Backward Recovery

Before qualifier

with MUPIP JOURNAL, Journal Time Qualifiers

BEFORE_IMAGES

journal option in GDE, Region Qualifiers
journaling type of, definition, BEFORE_IMAGE Journaling

Before_images option, SET -JOURNAL Options

Begin qualifier

with MUPIP LOAD, -BEgin

BINARY, -FOrmat

bitmaps

local, Local Bitmaps
master, Master Bitmap

Bkupdbjnl qualifier

with MUPIP BACKUP, -BKupdbjnl

Blk_size qualifier

in DSE, CHANGE -FIleheader Qualifiers

Block qualifier

in DSE, Qualifiers of ADD, CHANGE -BLock Qualifiers
in DSE, Dump, Qualifiers of DUMP
in DSE, Find, Qualifiers of FIND
in DSE, Integrit, Qualifiers of Integrit
in DSE, Map, Qualifiers for MAP
in DSE, Overwrite, Qualifiers for OVERWRITE
in DSE, Remove, Qualifiers of REMOVE
in DSE, Restore, Qualifiers of RESTORE
in DSE, Save, Qualifiers of SAVE
with MUPIP INTEG, -Blocks, -BLock

Blocks_free qualifier

in DSE, CHANGE -FIleheader Qualifiers

BLock_size qualifer

in GDE, Segment Qualifiers

Brief qualifier

with MUPIP INTEG, -BRief

Broken Transaction file, -SHow=show-option-list

definition, Broken Transaction File

Brokentrans qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Broken_transaction show option, -SHow=show-option-list

Bsiz qualifier

in DSE, CHANGE -BLock Qualifiers

Buffer_flush command

in DSE, Buffer_flush

Buffer_flush qualifier

in DSE, Qualifiers

Buffer_size journal option, SET -JOURNAL Options

Buffsize qualifier

with MUPIP REPLICATE, Starting the Source Server

Busy qualifier

in DSE, Map, Qualifiers for MAP
in DSE, Range, Qualifiers of RANGE

Bypass qualifier

with Jnl_file qualfier, SET Object Identifying Qualifiers

Bytestream qualifier

in DSE, CHANGE -FIleheader Qualifiers
with MUPIP BACKUP, -Bytestream

C

Cache command

examples, Examples for CACHE
in DSE, CAche

Chain qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Change command

example, Change

examples

in DSE, Examples for CHANGE

in DSE, CHange

in GDE, Change

Change qualifier

with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Changelog qualifier

with MUPIP REPLICATE, Changing the Log File, Changing the Log File

Changing the Log File

log interval setting , Changing the Log File, Changing the Log File

Checkhealth qualifier

with MUPIP REPLICATE, Checking Server Health

Checktn qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Clear command

in LKE, Clear

Close command

in DSE, CLose

closing database, RUNDOWN

CMPC qualifier

in DSE, CHANGE -BLock Qualifiers

Cmplvl qualifier

with MUPIP REPLICATE, Starting the Source Server

Collation qualifier

in GDE, Gblname Qualifiers

Collation_default qualifier

in GDE, Region Qualifiers

Command qualifier

-File, SHow
example, SHow
rebuild Global Directory , SHow

Comment qualifier

in DSE, Save, Qualifiers of SAVE

Commitwait_spin_count qualifier

in DSE, CHANGE -FIleheader Qualifiers

Control qualifiers, JOURNAL

Corrupt_file qualifier

in DSE, CHANGE -FIleheader Qualifiers

Count qualifier

in DSE, Dump, Qualifiers of DUMP
in DSE, Remove, Qualifiers of REMOVE

Create command, CREATE

examples, Examples for MUPIP CREATE

Crit qualifier

in DSE, Qualifiers of DUMP
in DSE, Find, Qualifiers of FIND
in DSE, Range, Qualifiers of RANGE
in DSE, Save, Qualifiers of SAVE
in LKE, Clear, SHow

Critical command

in DSE, CRitical

Critical section

in DSE, CRitical

Critinit qualifier

in DSE, Qualifiers

Current_tn qualifier

in DSE, CHANGE -FIleheader Qualifiers

Cutover

definition, Cutover

D

Data qualifier

in DSE, Qualifiers of ADD
in DSE, Overwrite, Qualifiers for OVERWRITE

database crash

immediately after, Immediately after Catastrophic Events

database integrity, Verifying Database Integrity

preventive, Preventive Maintenance

database integrity check, INTEG

Database qualifier

in DSE, CHANGE -FIleheader Qualifiers
with MUPIP BACKUP, -Database

database repair, Database Repair

determining cause, Determining the Cause of the Problem
repair decision tree, Finding and Fixing Database Errors
safety guidelines, Safety in Repairs
with MUPIP, MUPIP Recovery

Db qualifier

with MUPIP FTOK, -DB

Dbfilename qualifier

with Jnl_file qualifier, SET Object Identifying Qualifiers

Deactive qualifier

with MUPIP REPLICATE, Deactivating an Active Source Server

deadlock

resolving, Exercise 2: Rectifying a deadlock situation

Decimal qualifier

in DSE, Qualifiers of Evaluate

Decimal to Hexadecimal

in DSE, Evaluate, EValuate

Declocation qualifier

in DSE, CHANGE -FIleheader Qualifiers

Delete command

example, Delete
in GDE, Delete

Detail qualifier

with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Direction qualifiers, JOURNAL

Disable journal option, SET -JOURNAL Options

Downgrade command, DOWNGRADE

examples, Examples for MUPIP DOWNGRADE

Downloadable Replication Examples

A->B, Startup
A->P, Startup

DSE, Database Structure Editor

Cache, CAche
changing, CHange
changing DSE region, Qualifiers of FIND
Command Summary, DSE Command Summary
Critical, CRitical
Dump, Dump
Evaluate, EValuate
Exit, EXit
Find, Find
Integrit, Integrit
invoke, Operating in DSE
Map, Maps
Open, OPen
Overwrite, OVerwrite
Page, Page
Range, RAnge
Remove, REMove
Restore, REStore
Save, SAve
Shift, SHift
Spawn, SPawn
syntax, DSE Commands and Qualifiers
Wcinit, Wcinit

Dump command

in DSE, Dump

Dynamic_segment qualifier

in GDE, Region Qualifiers

E

Editinstance qualifier

with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Enable journal option, SET -JOURNAL Options

Enabling/Disabling Detailed Logging

log interval setting , Enabling/Disabling Detailed Logging, Enabling/Disabling Detailed Logging

Encryption, Database Encryption

alternatives, Alternatives to Database Encryption

building libraries, Building Encryption Libraries

changing encryption keys, Changing Encryption Keys

changing hash, Changing the hash in the database file header

definitions, Definition of Terms

example, Examples of use

installing , Installation

master key, MUPIP CREATE

reference implementation, Tested Reference Implementations

architecture, Plugin Architecture & Interface
installing seperately, Installation
using with older releases, Using the V5.4-001 Reference Implementation with Older Releases

role of keys, Keys in the Process Address Space / Environment

Encryption qualifer

in GDE, Segment Qualifiers

Encryption_hash qualifier

in DSE, CHANGE -FIleheader Qualifiers

End qualifier

with MUPIP LOAD, -End

Endiancvt command

outdb qualifier, convert endian format, ENDIANCVT

Enviroment variables

EDITOR, Environment Variables
GTMCI, Environment Variables
gtmcompile, Environment Variables
gtmcrypt_config, Environment Variables
gtmcrypt_FIPS, Environment Variables
gtmgbldir, Environment Variables
gtmroutines, Environment Variables
gtmtls_passwd_<label>, Environment Variables
GTMXC_gpgagent, Environment Variables
gtm_badchar, Environment Variables
gtm_baktmpdir, Environment Variables
gtm_chset, Environment Variables
gtm_chset_locale, z/OS only, Environment Variables
gtm_collate_n, Environment Variables
gtm_crypt_plugin, Environment Variables
gtm_custom_errors, Environment Variables
gtm_dbkeys, Environment Variables
gtm_db_startup_max_wait, Environment Variables
gtm_dist, Environment Variables
gtm_env_translate, Environment Variables
gtm_extract_nocol, Environment Variables
gtm_fullblockwrites, Environment Variables
gtm_gdscert, Environment Variables
gtm_gvdupsetnoop, Environment Variables
gtm_icu_version, Environment Variables
gtm_ipv4_only, Environment Variables
gtm_jnl_release_timeout, Environment Variables
gtm_keep_obj, Environment Variables
gtm_lct_stdnull, Environment Variables
gtm_local_collate, Environment Variables
gtm_max_sockets, Environment Variables
gtm_memory_reserve, Environment Variables
gtm_nocenable, Environment Variables
gtm_non_blocked_write_retries, Environment Variables
gtm_noundef, Environment Variables
gtm_obfuscation_key, Environment Variables
gtm_passwd, Environment Variables
gtm_patnumeric, Environment Variables
gtm_pattern_file, Environment Variables
gtm_principal, Environment Variables
gtm_principal_editing, Environment Variables
gtm_procstuckexec, Environment Variables
gtm_prompt, Environment Variables
gtm_quiet_halt, Environment Variables
gtm_repl_instance, Environment Variables
gtm_repl_instsecondary, Environment Variables
gtm_retention, Environment Variables
gtm_side_effects, Environment Variables
gtm_snaptmpdir, Environment Variables
gtm_stdxkill, Environment Variables
gtm_sysid, Environment Variables
gtm_tprestart_log_delta, Environment Variables
gtm_tprestart_log_first, Environment Variables
gtm_trigger_etrap, Environment Variables
gtm_ver, Environment Variables
gtm_zdate_form, Environment Variables
gtm_zinterrupt, Environment Variables
gtm_zlib_cmp_level, Environment Variables
gtm_zmaxtptime, Environment Variables
gtm_zquit_anyway, Environment Variables
gtm_ztrap_form, Environment Variables
gtm_ztrap_new, Environment Variables
LC_ALL, Environment Variables
LC_CTYPE, Environment Variables
LD_LIBRARY_PATH, Environment Variables
old_gtmroutines, Environment Variables
old_gtm_dist, Environment Variables
summary, Environment Variables
tmp_gtm_tmp, Environment Variables
tmp_passw, Environment Variables
TZ, Environment Variables

Environment variables

gtm_etrap, Environment Variables
gtm_tpnotacidtime, Environment Variables
gtm_trace_gtm_name, Environment Variables

Epoch_interval option, SET -JOURNAL Options

Error_limit qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

estimate global variable size, SIZE

Evaluate command

examples, Examples for EVALUATE
in DSE, EValuate

Exact qualifier

in LKE, Clear

Exclude qualifier

with MUPIP REORG, -Exclude

Exhaustive qualifier

in DSE, Find, Qualifiers of FIND

Exit command

in DSE, EXit
in GDE, Exit
in LKE, Exit
with MUPIP, EXIT

Extend command, EXTEND

examples, Examples for MUPIP EXTEND

Extend qualifier

RESTORE, -Extend

Extension_count qualifer

in GDE, Segment Qualifiers

Extension_count qualifier

used by MUPIP RESTORE, -Extend
with MUPIP SET, -Extension_count

Extention journal option, SET -JOURNAL Options

Extention_count qualifier

used by MUPIP EXTEND, Commands and Qualifiers

Extract command, EXTRACT

examples, Examples for MUPIP EXTRACT

Extract formats

GLO, in DSE, Qualifiers of DUMP
ZWR, in DSE, Qualifiers of DUMP

Extract formats, BINARY, GO, ZWR, -FOrmat

Extract qualifier

with MUPIP JOURNAL, -EXtract[=<file-name>|-stdout]

F

Fast qualifier

with MUPIP INTEG, -FAst

Fence options

with MUPIP JOURNAL, Journal Control Qualifiers

Fences qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Fetchresync qualifier

example, Rolling Back the Database After System Failures
examples, Journal Sequence Number Qualifiers
specifying port number, Rolling Back the Database After System Failures
with MUPIP JOURNAL, Journal Sequence Number Qualifiers

file header, Database File Organization with GDS

changing attributes, CHANGE -FIleheader Qualifiers
elements, File Header Data Elements

File qualifier

in DSE, Open, Qualifiers for OPEN
with MUPIP INTEG, -FIle
with MUPIP RUNDOWN, -File
with MUPIP SET, -File, SET Object Identifying Qualifiers , Turning Replication On/Off

Fileheader qualifier

in DSE, CHANGE -FIleheader Qualifiers
in DSE, Dump, Qualifiers of DUMP

Filename journal option, SET -JOURNAL Options

File_name qualifer

default file name is, Segment Qualifiers
in GDE, Segment Qualifiers

Fill_factor qualifier

with MUPIP LOAD, -FIll_factor
with MUPIP REORG, -Fill_factor

Filter qualifier

with MUPIP REPLICATE, Starting the Source Server

Filters

change schema, Schema Change Filters
definition, Filters
example, Starting the Source Server
specifying, Starting the Source Server
stopping source , Stopping the Source Filter
stopping source filter, Stopping the Source Filter, Starting the Receiver Server

Find command

examples, Examples for FIND
in DSE, Find

Fixing damanged spanning node

example of, O5–Salvage of a damaged spanning node

Flush_time qualifier

in DSE, CHANGE -FIleheader Qualifiers
with MUPIP SET, -Flush_time

Format qualifier

with MUPIP EXTRACT, -FOrmat
with MUPIP LOAD, -FOrmat

Forward qualifier

in DSE, Shift, Qualifiers of SHIFT
with MUPIP JOURNAL, -RECover , Journal Direction Qualifiers

Forward Recovery

definition, Forward Recovery

forward recovery, -RECover

Free qualifier

in DSE, Map, Qualifiers for MAP

Freeblock qualifier

in DSE, Find, Qualifiers of FIND

Freeze command, FREEZE

examples, Examples for MUPIP FREEZE

Freeze qualifier

in DSE, Qualifiers, CHANGE -FIleheader Qualifiers
with MUPIP EXTRACT, -FReeze

From qualifier

in DSE, Range, Qualifiers of RANGE
in DSE, Restore, Qualifiers of RESTORE

FTOK

examining IPCs, Examining GT.M's IPC Resources

Ftok command, FTOK

examining IPCs, Examining GT.M's IPC Resources

Full qualifier

with MUPIP INTEG, -FUll
with MUPIP JOURNAL, Journal Control Qualifiers

Fully_upgraded qualifier

in DSE, CHANGE -FIleheader Qualifiers

G

Gblname qualifier

in GDE, Gblname Qualifiers

GDE

command syntax, Global Director Editor Commands

GDS, GT.M Database Structure(GDS)

blocks, GDS Blocks

compression count, Compression Count

keys, GDS Keys

characteristics, Characteristics of Keys
uses of, Use of Keys

records, GDS Records

spanning nodes, Using GDS records to hold spanning nodes

Glo qualifier

in DSE, Qualifiers of DUMP

Global Directory

Abbreviations, Global Directory Abbreviations

Command Summary, GDE Command Summary

creating, Creating a Default Global Directory

Customizing, Customizing a Global Directory

definition, Global Directory

examining, Examining the Default Global Directory

examples of mapping, Example of a Basic Mapping

How to customize

Add a Journaling Information Section, Adding a Journaling Information Section

Identify, Identifying the Current Global Directory

invoke GDE, Using GDE

mapping, Mapping Global Variables in a Global Directory

mapping guidelines, Guidelines for Mapping

overview, GDE Overview

Qualifier Summary, GDE Command Qualifier Summary

Global qualifier

examples, Journal Selection Qualifiers
with MUPIP JOURNAL, Journal Selection Qualifiers

Global_buffers_count qualifier

with MUPIP SET, -Global_buffers

Global_buffer_count qualifier

definition, Segment Qualifiers
in GDE, Segment Qualifiers

GO, -FOrmat

GT.M, About GT.M

configuring huge pages for GT.M on Linux, Configuring huge pages for GT.M x86[-64] on Linux
encrypting, Database Encryption
gdedefaults, gdedefaults
general database management, General Database Management
gtm, gtm
installation prerequisites, Before you begin
installing, Installing GT.M
installing with gtminstall, gtminstall script
installing with Unicode support, Configuring and operating GT.M with Unicode™ support (optional)
run, Starting GT.M
setting an environment for, GT.M Environment Setup
using gtmbase, gtmbase
using gtmprofile, gtmprofile
Utility, DSE, DSE
Utility, GDE, GDE
Utility, LKE, LKE
Utility, MUPIP, MUPIP

gtmroutines

libgtmutil.so, M mode and UTF-8 mode

gtmsecshr

considerations, Environment Variables
definition, gmtsecshr
gtm_secshr_log, Environment Variables
log files, Monitoring GT.M Messages
temporary files, Environment Variables

Gvstats qualifier

in DSE, Qualifiers of DUMP

Gvstatsreset qualifier

in DSE, CHANGE -FIleheader Qualifiers

H

Header qualifier

in DSE, Qualifiers of DUMP

Header show option, -SHow=show-option-list

Help command

in GDE, Help

Helper Processes

definition, Helper Processes
Reader, Helper Processes
Updproc, in DSE, Qualifiers of DUMP
with MUPIP REPLICATE , Starting the Update Process, Stopping the Update Process
Writer, Helper Processes

Hexadecimal qualifier

in DSE, Qualifiers of Evaluate

Hexadecimal to Decimal

in DSE, Evaluate, EValuate

Hexlocation qualifier

in DSE, CHANGE -FIleheader Qualifiers

Hint qualifier

in DSE, Find, Qualifiers of FIND

History records, Replication Instance File

huge pages

improving performance with, Configuring huge pages for GT.M x86[-64] on Linux

I

ICU

compiling, Compiling ICU
used by, Configuring and operating GT.M with Unicode™ support (optional)

Id qualifier

with MUPIP JOURNAL, Journal Selection Qualifiers

Index qualifier

in DSE, Range, Qualifiers of RANGE

Index_fill_factor qualifier

with MUPIP REORG, -Index_fill_factor

Init qualifier

in DSE, Qualifiers of CRITICAL

Initialize qualifier

with MUPIP REPLICATE , Starting the Receiver Server

Instance Freeze

definition, Instance Freeze
with GDE, Region Qualifiers
with MUPIP REPLICATE, Starting the Source Server
with MUPIP SET, -INST_freeze_on_error

Instance_create qualifier

with MUPIP REPLICATE, Creating the Replication Instance File

Instsecondary qualifier

with MUPIP REPLICATE, Starting the Source Server, Activating a Passive Source Server, Deactivating an Active Source Server, Checking Server Health, Changing the Log File, Stopping a Source Server

Inst_freeze_on_errort qualifier

with MUPIP SET, -INST_freeze_on_error

Integ command, INTEG

examples, Examples for MUPIP INTEG
fixing error, Immediately after Run-Time Database Errors

Integrit command

in DSE, Integrit

Interactive qualifier

in LKE, Clear
with MUPIP JOURNAL, Journal Control Qualifiers

interrupt process, INTRPT

Interrupt_recov qualifier

in DSE, CHANGE -FIleheader Qualifiers

Intrpt command, INTRPT

J

Jnlfile qualifier

with MUPIP SET, SET Object Identifying Qualifiers

Jnlpool qualifier

with MUPIP FTOK, -JNLPOOL
with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Journal command, JOURNAL

build a MUPIP JOURNAL command, JOURNAL

Journal Extract

format, Journal Extract Formats

Journal options, SET -JOURNAL Options

in general database management, -Journal

Journal Pool, Replication Architecture

selecting, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Journal qualifier

Allocation, Template
Allocation option, Region Qualifiers
Autoswitch option, Region Qualifiers
Before_image option, Region Qualifiers
Buffer_size option, Region Qualifiers
Extension option, Region Qualifiers
File_name, Region Qualifiers
File_name option, Region Qualifiers
in GDE, Region Qualifiers
in general database management, -Journal

Journaling, GT.M Journaling

autoswitch limit, Journal Files
backup strategy, Backup Journal Files
backward recovery, initiate, -RECover
BEFORE_IMAGE, BEFORE_IMAGE Journaling
benefits, Journaling Benefits
choosing between, Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE , Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
forward recovery, initiate, -RECover
Identify journaling actions, SET Action Qualifiers
identify journaling targets, SET Object Identifying Qualifiers
initialize database recovery, -RECover
initialize database recovery for replicated database, -ROLLBACK [{-ON[LINE]|-NOO[NLINE]}]
NOBEFORE_IMAGE, NOBEFORE_IMAGE Journaling
previous generation journal files, Journal Files , Journal Control Qualifiers
rollback to a common synchronization point, Journal Sequence Number Qualifiers
rolled_bak*, -RECover
specifying error limit, Journal Control Qualifiers
storing database update information, Journal Files

K

Key qualifier

in DSE, Qualifiers of ADD
in DSE, Find, Qualifiers of FIND

Keyrange qualifier

with MUPIP INTEG, -Keyranges

Key_max_size qualifier

in DSE, CHANGE -FIleheader Qualifiers

Key_size

example, Region Qualifiers

Key_size qualifier

in GDE, Region Qualifiers

Kill_in_prog qualifier

in DSE, CHANGE -FIleheader Qualifiers

L

Label qualifier

with MUPIP EXTRACT, -LAbel

Level qualifier

in DSE, CHANGE -BLock Qualifiers

libgtmutil.so, M mode and UTF-8 mode

installing, Installation Procedure

List qualifier

in DSE, Save, Qualifiers of SAVE

Listenport qualifier

specifying , Starting the Receiver Server

LKE, Introduction

CLEAR, Clear
Command Summary, Summary
EXIT, Exit
invoking, To Invoke and Exit LKE
M Lock space, MLOCK Space
SHOW, SHow
syntax, LKE Commands and Qualifiers

LMS

application architecture, Application Architecture
architecture, Replication Architecture
choosing between journaling type, Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
cutover, Cutover
message delivery application, Implement a Message Delivery System
transaction processing application, Implementing Replication and Recovery

Load command, LOAD

examples, Examples for MUPIP LOAD

load data from extract file, LOAD

Lock qualifier

in LKE, Clear, SHow

Lock usage, Exercise 1: Preventing concurrent updates using M Locks

LOCKs command

example, LOCks
in GDE, LOCks

Lock_space qualifier

in GDE, Segment Qualifiers
with MUPIP SET, -Lock_space

Log command

example, LOG
in GDE, LOG

Log qualifier

with MUPIP EXTRACT, -LOg
with MUPIP REPLICATE, Starting the Source Server

Log_interval qualifier

Starting the Receiver Server, Starting the Receiver Server
with Changelog (Receiver Server), Changing the Log File
with Changelog (Source Server), Changing the Log File
with MUPIP REPLICATE, Starting the Source Server
with Statslog (Receiver Server), Enabling/Disabling Detailed Logging
with Statslog (Source Server), Enabling/Disabling Detailed Logging

Lookback_limit options

with MUPIP JOURNAL, Journal Time Qualifiers

Lookback_limit qualifier

with MUPIP JOURNAL, Journal Time Qualifiers

Lost qualifier

in DSE, Range, Qualifiers of RANGE

Lost Transaction file

definition, Lost Transaction File
format, Lost Transaction File format
processing, Processing Lost Transactions File
processing after, Processing Lost Transactions File
specifying file , Journal Control Qualifiers

Lost transaction file

creating, Rolling Back the Database After System Failures

Losttncomplete qualifier

specifying , Processing Lost Transactions File

Losttrans qualifier

with -ROLLBACK, Rolling Back the Database After System Failures
with MUPIP JOURNAL, Journal Control Qualifiers

Lower qualifier

in DSE, Range, Qualifiers of RANGE

M

manage triggers, TRIGGER

Map command

in DSE, Maps

Map qualifier

with MUPIP INTEG, -MAP

Master qualifier

in DSE, Map, Qualifiers for MAP

Maxkeysize qualifier

with MUPIP INTEG, -MAXkeysize

Monitoring

messages and errors, Monitoring GT.M Messages

MUPIP

BACKUP, BACKUP

example, BACKUP

Commands Summary, MUPIP Command Summary

CREATE, CREATE

DOWNGRADE, DOWNGRADE

ENDIANCVT, ENDIANCVT

EXIT, EXIT

EXTEND, EXTEND

Extract, EXTRACT

FREEZE, FREEZE

FTOK, FTOK

INTEG, INTEG

INTRPT, INTRPT

JOURNAL, JOURNAL

LOAD, LOAD

REORG, REORG

REPLICATE, Commands and Qualifiers

RESTORE, RESTORE

RUNDOWN, RUNDOWN

SET, SET , SET

SIZE, SIZE

Standalone and concurrent, Operations - Standalone and Concurrent Access

STOP, STOP

TRIGGER, TRIGGER

UPGRADE, UPGRADE

Mutex_slots qualifier

in GDE, Segment Qualifiers
with MUPIP SET, -Mutex_slots

N

Name qualifier

example, Name Qualifiers
in GDE, Name Qualifiers
with MUPIP REPLICATE, Creating the Replication Instance File, Displaying/Changing the attributes of Replication Instance File and Journal Pool

needrestart qualifier, Processing Lost Transactions File

NETtimeout qualifier

with MUPIP BACKUP (bytestream), -NETtimeout

Newjnlfiles

with MUPIP BACKUP, -NEWJNLFILES

NOBEFORE_IMAGES

journaling type of, definition, NOBEFORE_IMAGE Journaling

None fence option, Journal Control Qualifiers

Noreplace qualifier

with MUPIP REPLICATE, Creating the Replication Instance File

Noresync qualifier

with MUPIP REPLICATE , Starting the Receiver Server

Null_subscripts qualifier, Region Qualifiers

in DSE, CHANGE -FIleheader Qualifiers

Number qualifier

in DSE, Qualifiers of Evaluate

O

Off qualifier

with MUPIP FREEZE, -OFf

OFF,ON journal options, SET -JOURNAL Options

Offset qualifier

in DSE, Qualifiers of ADD, CHANGE -BLock Qualifiers, Qualifiers of DUMP
in DSE, Map, Qualifiers for OVERWRITE
in DSE, Remove, Qualifiers of REMOVE
in DSE, Shift, Qualifiers of SHIFT
with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

On qualifier

with MUPIP FREEZE, -ON

Online qualifier

with MUPIP BACKUP, -Online
with MUPIP INTEG, -Online

Open command

in DSE, OPen

orderly terminate database process, STOP

originating instance

propagating, Starting the Source Server
update last known synchronization point, Starting the Receiver Server

Output qualifier

in LKE, Clear, SHow

override qualifier

with MUPIP ENDIANCVT, ENDIANCVT

Override qualifier

in DSE, Qualifiers, CHANGE -FIleheader Qualifiers
with MUPIP FREEZE, -OVerride
with MUPIP RUNDOWN, -Override

Overwrite command

in DSE, OVerwrite

Owner qualifier

in DSE, Qualifiers of CRITICAL

P

Page command

in DSE, Page

Partial_recov_bypass qualifier

with MUPIP SET, -PArtial_recov_bypass

Passive qualifier

with MUPIP REPLICATE, Starting the Source Server

perform journaling operations, JOURNAL

Pid qualifier

in LKE, Clear, SHow

Plaintextflassback qualifier

Starting the Source Server, Starting the Source Server

Pointer qualifier

in DSE, Qualifiers of ADD

Prevjnlfile journal option, SET -JOURNAL Options

Prevjnlfile qualifier

with Jnl_file qualfier, SET Object Identifying Qualifiers

PREVLINK

with Newjnlfiles, MUPIP BACKUP, -NEWJNLFILES

Process fence option, Journal Control Qualifiers

Processes show option, -SHow=show-option-list

Propagateprimary qualifier

with MUPIP REPLICATE, Starting the Source Server, Activating a Passive Source Server, Deactivating an Active Source Server

Q

Qdbrundown

in DSE, CHANGE -FIleheader Qualifiers

Qdbrundown qualifier

in DSE, CHANGE -FIleheader Qualifiers
in general database management, -Qdbrundown
with GDE, Region Qualifiers

Quit command

in GDE, Quit

R

Range command

in DSE, RAnge

Receiver qualifier

with MUPIP REPLICATE, Starting the Receiver Server

Receiver Server, Replication Architecture

add helpers, Starting the Update Process
automatic online rollback , Starting the Receiver Server
changing logs, Changing the Log File
checking progress, Reporting the Current Backlog of Journal Records
enable logging, disable logging, Enabling/Disabling Detailed Logging
specify port to listen, Starting the Receiver Server
specifying compression level, Starting the Source Server
starting, Starting the Receiver Server
update process, Starting the Update Process

Record qualifier

in DSE, Qualifiers of ADD, CHANGE -BLock Qualifiers, Qualifiers of DUMP
in DSE, Remove, Qualifiers of REMOVE
with MUPIP BACKUP, -Record
with MUPIP FREEZE, -Record

Record_max_size qualifier

in DSE, CHANGE -FIleheader Qualifiers

Record_size

in DSE, CHANGE -FIleheader Qualifiers
in GDE, Region Qualifiers

Recover qualifier

in DSE, Qualifiers of CACHE
with MUPIP JOURNAL, -RECover

Recovery, Approaches to Database Recovery

from backup files, Restore from Backup
from journal files, Recover from Journals

Recvpool qualifier

with MUPIP FTOK, -RECVPOOL

Redirect qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Reference qualifier

in DSE, Qualifiers

Reference_count

in DSE, CHANGE -FIleheader Qualifiers

Region qualifier

in DSE, Find, Qualifiers of FIND

in DSE, Restore, Qualifiers of RESTORE

in GDE, Region Qualifiers

in LKE, Clear, SHow

Journal qualifier

journal options summary, Region Qualifiers

with MUPIP CREATE, -Region

with MUPIP INTEG, -Region

with MUPIP REORG, -Region

with MUPIP RUNDOWN, -Region

with MUPIP SET, -Region, SET Object Identifying Qualifiers , Turning Replication On/Off

Region Qualifiers

with GDE, Region Qualifiers

Reg_seqno qualifier

in DSE, CHANGE -FIleheader Qualifiers

Release qualifier

in DSE, Qualifiers, Qualifiers of CRITICAL

Remove command

in DSE, REMove

Remove qualifier

in DSE, Qualifiers of CRITICAL

Rename command

example, Rename
in GDE, Rename

Renegotiate_interval qualifier

Starting the Source Server, Starting the Source Server

Renew qualifier

in DSE, Qualifiers

Reorg command, REORG

examples, Examples for MUPIP REORG

reorganize, defragment, optimize, reduce database size , REORG

REPLace qualifier

with MUPIP BACKUP, -REPLace

Replace qualifier

with MUPIP REPLICATE, Creating the Replication Instance File

Replicate command

examples, Starting the Source Server

Replicate qualifier

with MUPIP REPLICATE, Starting the Source Server

replicating instance

accepting SI stream, Starting the Receiver Server
identify, Starting the Source Server
if previously used, Starting the Receiver Server
initializing SI stream, Starting the Receiver Server

Replication

architecture, Replication Architecture

changing replication state, Turning Replication On/Off

Filters, Filters

implementation procedures, Procedures

LMS Group

SI Group, Introduction

Replication instance file, Replication Instance File

rolling upgrades, Procedures

specifying compression level, Starting the Source Server

Replication instance file

definition, Replication Instance File

Replication Instance file

display, change, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Replication qualifier

with MUPIP SET, SET Action Qualifiers , Turning Replication On/Off

Replication state options

Off, Turning Replication On/Off
On, Turning Replication On/Off
Was_on, Turning Replication On/Off

Replinstance qualifier, Replication Instance File

with MUPIP BACKUP, -REPLInstance

Repl_state qualifier

with Jnl_file qualifier, SET Object Identifying Qualifiers

Reserved_bytes qualifier

in GDE, Segment Qualifiers
with MUPIP SET, -REServed_bytes

Reset qualifier

in DSE, Qualifiers of CRITICAL

Restart Codes, R2–Structural Database Integrity Errors

Restore command, RESTORE

examples, Examples for MUPIP RESTORE
in DSE, REStore

Restore_all qualifier

in DSE, Map, Qualifiers for MAP

restoring incremental backup, RESTORE

Resume qualifier

with MUPIP REORG, -Resume
with MUPIP REPLICATE , Starting the Receiver Server

Resync qualifier

with MUPIP REPLICATE, Rolling Back the Database After System Failures

Resync_seqno qualifier

in DSE, CHANGE -FIleheader Qualifiers

Resync_strm qualifier

with -ROLLBACK, Rolling Back the Database After System Failures

Resync_tn qualifier

in DSE, CHANGE -FIleheader Qualifiers

Reuse qualifier

with MUPIP REPLICATE , Starting the Receiver Server

rollback

to a journal stream sequence number, Rolling Back the Database After System Failures

Rollback qualifier, Rolling Back the Database After System Failures

with MUPIP JOURNAL, -ROLLBACK [{-ON[LINE]|-NOO[NLINE]}]

rolled_bak* files, -RECover

definition, rolled_bak* files

Rootprimary, Root Primary Status Identification

example, Starting the Source Server
specifying, Starting the Source Server

Rootprimary qualifier

with MUPIP REPLICATE, Starting the Source Server, Activating a Passive Source Server, Deactivating an Active Source Server

Rundown command, RUNDOWN

S

Save command

in DSE, SAve

Secondary qualifier

with MUPIP REPLICATE, Starting the Source Server

Segement qualifier

in GDE, Segment Qualifiers

Seize qualifier

in DSE, Qualifiers of CRITICAL

Select qualifier

with MUPIP EXTRACT, global specification, -Select
with MUPIP REORG, -Select
with MUPIP TRIGGER, TRIGGER

Selection qualifiers, JOURNAL

Sequence Number qualifiers, JOURNAL

Set command, SET , SET

examples, Examples for MUPIP SET
in replication, Turning Replication On/Off
journaling examples, Examples for MUPIP SET

SEtgd command

example, SEtgd
in GDE, SEtgd

setting database characteristics, SET

setting journaling characteristics, SET

Shift command

in DSE, SHift

SHow command

-template

example, SHow

in GDE, SHow

Show command

in LKE, SHow

Show options

display journaling information, -SHow=show-option-list

Show qualifier

with MUPIP JOURNAL, -SHow=show-option-list
with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Showbacklog qualifier

with MUPIP REPLICATE, Reporting the Current Backlog of Journal Records

Shutdown qualifier

with MUPIP REPLICATE, Shutting down the Source Server

Sibling qualifier

in DSE, Find, Qualifiers of FIND

Sieze qualifier

in DSE, Qualifiers

Since qualifier

with MUPIP BACKUP, -Since
with MUPIP JOURNAL, Journal Time Qualifiers

Size qualifier, SIZE

with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Snapshot files

with MUPIP INTEG, -Online

Source qualifier

with MUPIP REPLICATE, Starting the Source Server

Source Server, Replication Architecture

changing logs, Changing the Log File

checking progress, Reporting the Current Backlog of Journal Records

deactivating, Deactivating an Active Source Server

enable logging, disable logging, Enabling/Disabling Detailed Logging

identify, Starting the Source Server

log interval setting , Starting the Source Server

logging, Starting the Source Server

Passive

activating, Activating a Passive Source Server, Checking Server Health

shut down, Shutting down the Source Server

specifying compression level, Starting the Source Server

specifying Journal Pool size, Starting the Source Server

start in passive mode, Starting the Source Server

starting, Starting the Source Server

starting, active mode, Starting the Source Server

stopping, Stopping a Source Server

timeout specifying, Shutting down the Source Server

Spanning Nodes

special subscript, Using GDS records to hold spanning nodes

Spawn

in LKE, SPawn

Spawn command

in DSE, SPawn

Star qualifier

in DSE, Qualifiers of ADD
in DSE, Range, Qualifiers of RANGE

Start qualifier

with MUPIP REPLICATE, Starting the Source Server

Starting the Receiver Server

setting the logging interval, Starting the Receiver Server

Starting the Source Server

enabling TLS/SSL replication, Starting the Source Server, Starting the Receiver Server

Statistics show option, -SHow=show-option-list

Statslog qualifier

with MUPIP REPLICATE, Enabling/Disabling Detailed Logging

Stdin qualifier

with MUPIP LOAD, -Stdin

Stdnullcoll qualifier, Region Qualifiers

Stdout qualifier

with MUPIP EXTRACT, redirect to stdout, -STdout

Stop qualifier, STOP

Stopsourcefilter qualifier

with MUPIP REPLICATE, Stopping the Source Filter, Starting the Receiver Server

Strm_num qualifier

in DSE, CHANGE -FIleheader Qualifiers

Strm_reg_seqno qualifier

in DSE, CHANGE -FIleheader Qualifiers

Subscript qualifier

with MUPIP INTEG, -Subscript

Supplementary qualifier

Instance_create qualifier, Creating the Replication Instance File
with MUPIP REPLICATE, Creating the Replication Instance File

SYNC_IO

with Newjnlfiles, MUPIP BACKUP, -NEWJNLFILES

Sync_io option, SET -JOURNAL Options

T

Template command

example, Template
maintains sets of region and segment , Template

Time qualifiers, JOURNAL

Timeout qualifier

with MUPIP REPLICATE, Stopping a Source Server
with MUPIP REPLICATE, shutdown qualifier, Shutting down the Source Server

Timers_pending qualifier

in DSE, CHANGE -FIleheader Qualifiers

TLS Replication

, TLS/SSL Replication

TLSID qualifier

Starting the Receiver Server, Starting the Source Server, Starting the Receiver Server

Tn qualifier

in DSE, CHANGE -BLock Qualifiers

Tn_reset qualifier

with MUPIP INTEG, -TN_reset

To qualifier

in DSE, Range, Qualifiers of RANGE

Total_blks qualifier

in DSE, CHANGE -FIleheader Qualifiers

Transaction qualifier

with MUPIP BACKUP -BYTESREAM, -Transaction
with MUPIP INTEG, -TRansaction
with MUPIP JOURNAL, Journal Selection Qualifiers

Trigger command, TRIGGER

examples, Examples for MUPIP TRIGGER

Triggerfile qualifier

with MUPIP TRIGGER, TRIGGER

Triggers

add, Examples for MUPIP TRIGGER
delete, Examples for MUPIP TRIGGER
modify, Examples for MUPIP TRIGGER

Trigger_flush qualifier

in DSE, CHANGE -FIleheader Qualifiers

Truncate qualifier

with MUPIP REORG, -Truncate

U

Update Process, Replication Architecture

starting, Starting the Update Process
stopping, Stopping the Update Process

Updateonly qualifier, Starting the Update Process

with MUPIP REPLICATE , Stopping the Update Process

Updateresync qualifier

with MUPIP REPLICATE , Starting the Receiver Server

Updnotok

specifying, Starting the Source Server

Updnotok qualifier

with MUPIP REPLICATE, Starting the Source Server

Updok

specifying, Starting the Source Server

Updok qualifier

with MUPIP REPLICATE, Starting the Source Server

Updproc qualifier

in DSE, Qualifiers of DUMP

Upgrade command, UPGRADE

examples, Example for MUPIP UPGRADE

Upper qualifier

in DSE, Range, Qualifiers of RANGE

User qualifier

with MUPIP JOURNAL, Journal Selection Qualifiers

V

V4 to V5 upgrade, UPGRADE

Value qualifier

with MUPIP REPLICATE, Displaying/Changing the attributes of Replication Instance File and Journal Pool

Verbose qualifier

with MUPIP JOURNAL, Journal Control Qualifiers

Verify command

in GDE, Verify

Verify qualifier

in DSE, Qualifiers of CACHE
with MUPIP JOURNAL, -[NO]Verify

Version qualifier

in DSE, Remove, Qualifiers of REMOVE
in DSE, Restore, Qualifiers of RESTORE
with MUPIP DOWNGRADE, -VERSION={V4|V5}
with MUPIP SET, -Version

W

Wait qualifier

in LKE, SHow

Wcinit command

in DSE, Wcinit

Wcinit qualifier

in DSE, Qualifiers

Writes_per_flush qualifier

in DSE, CHANGE -FIleheader Qualifiers

Y

Yield_limit journal option, SET -JOURNAL Options

Z

ZWR, -FOrmat

ZWR qualifier

in DSE, Qualifiers of DUMP

Prev
Glossary	Home