|
COMMAND |
OBJECTS |
MAIN QUALIFIER |
GT.M version* |
Standalone Access# |
|---|---|---|---|---|
B[ACKUP] | region-name file-name | -BK[UPDBJNL]=DISABLE | OFF | A | A |
| A | A | -BY[TESTREAM] -NET[TIMEOUT]=seconds | A | A |
| A | A | -C[OMPREHENSIVE] | A | A |
| A | A | -DA[TABASE] -REPLA[CE] | A | A |
| A | A | -I[NCREMENTAL] | A | A |
| A | A | -[NO]J[OURNAL][=journal-options-list] | A | A |
| A | A | -NETTIMEOUT | A | A |
| A | A | -[NO]NEWJNLFILES[=[NO]PREVLINK],[NO]S[YNC_IO] | A | A |
| A | A | -O[NLINE] | A | A |
| A | A | -RECORD | A | A |
| A | A | -REPLI[NSTANCE]=OFF | ON | A | A |
| A | A | -S[INCE]={DATABASE|BYTESTREAM|RECORD} | A | A |
| A | A | -T[RANSACTION=hexa;transaction_number] | A | A |
|
CR[EATE] |
- |
-R[EGION]=region-name |
Y | |
DO[WNGRADE] | file-name | -V[ERSION]=V5 | -V7.0-000 | Y |
|
DU[MPFHEAD] |
File-name or region-list |
-FI[LE] | V6.3-001 | A |
|
-R[EGION] | V7.0-003 | A | ||
|
EN[DIANCVT] |
file-name |
-OUTDB=<outdb-file> | A | Y |
| A | A | -OV[ERRIDE] | A | Y |
EXI[T] | - | - | A | N/A |
EXTE[ND] | region-name | -B[LOCKS]=blocks | A | A |
|
EXTR[ACT] |
- |
-FO[RMAT]=GO|B[INARY]|Z[WR] | A | A |
| A | A | -FR[EEZE] | A | A |
| A | A | -NU[LL_IV] | V6.3-000 | A |
| A | A | -LA[BEL]=text | A | A |
| A | A | -[NO]L[OG] | A | A |
| A | A | -S[ELECT]=global-name-list | A | A |
| A | A | -O[CHSET]=character-set | A | A |
| A | A | -R[EGION=region-list | A | A |
|
F[REEZE] |
region-list | -OF[F] [-OV[ERRIDE]] | A | A |
| A | A | -ON [-[NO]ONL[INE] [-[NO]A[UTORELEASE]] [-R[ECORD]]] | A | A |
|
FT[OK] |
File-name |
-D[B] | A | A |
| A | A | -J[NLPOOL] | A | A |
| A | A | -R[ECVPOOL] | A | A |
|
H[ELP] |
command-option |
- | A | |
|
I[NTEG] |
File-name or region-list |
-A[DJACENCY]=integer] | A | A |
| A | A | -BL[OCK]=hexa;block-number] | A | A |
| A | A | -BR[IEF] | A | A |
| A | A | -DMAXBLOCKSIZE=integer | V7.1-002 | A |
| A | A | -FA[ST] | A | A |
| A | A | -FI[LE] | A | Y |
| A | A | -FU[LL] | A | A |
| A | A | -IMAXBLOCKSIZE=integer | V7.1-002 | A |
| A | A | -NO]K[EYRANGES | A | A |
| A | A | -[NO][MAP]=integer | A | A |
| A | A | -[NO]MAXK[EYSIZE]=integer | A | A |
| A | A | -R[EGION] | A | A |
| A | A | -[NO]ST[ATS] | A | A |
| A | A | -SU[BSCRIPT]=subscript | A | A |
| A | A | -TN[_RESET] | A | Y |
| A | A | -[NO]TR[ANSACTION][=integer] | A | A |
|
IN[TRPT] |
process id | A | N/A | |
|
J[OURNAL] |
file-name |
-EX[TRACT][=file-specification| | A | A |
| A | A | -stdout] | V5.5-000 | A |
| A | A | -REG[ION] | V6.2-000 | A |
| A | A | -REC[OVER] | -RO[LLBACK] | A | A |
| A | A | -SH[OW][=show-option-list] | A | A |
| A | A | -[NO]V[ERIFY] | A | A |
| A | A | -BA[CKWARD] | -FO[RWARD] | A | A |
| A | A | -CO[RRUPTDB] | V6.3-010 | A |
|
L[OAD] |
file-name |
-BE[GIN]=integer | A | A |
| A | A | -BLOCK_DENSITY | A | A |
| A | A | -E[ND]=integer | A | A |
| A | A | -FI[LLFACTOR]=integer | A | A |
| A | A | -FO[RMAT]=GO|B[INARY]|Z[WR] | A | A |
| A | A | -S[TDIN] | V5.5-000 | A |
| A | A | -O[NERROR] | A | A |
|
REO[RG] |
-D[OWNGRADE] | -V7.0-000 | A | |
| A | A | -ENCR[YPT]=key | V6.3-000 | A |
| A | A | -E[XCLUDE]=global-name-list | A | A |
| A | A | -FILL[_FACTOR]=integer | A | A |
| A | A | -FILE=file-name | A | A |
| A | A | -I[NDEX_FILL_FACTOR]=integer | A | A |
| A | A | -K[EEP]={pct%|blocks} | V6.3-009 | A |
| A | A | -MIN[_LEVEL]=integer | V7.1-002 | A |
| A | A | -NOCO[ALESCE] | V6.3-009 | A |
| A | A | -NOSP[LIT] | V6.3-009 | A |
| A | A | -NOSW[AP] | V6.3-009 | A |
| A | A | -R[ESUME] | A | A |
| A | A | -S[ELECT]=global-name-list | A | A |
| A | A | -T[RUNCATE][=percentage] | V5.5-000 | A |
| A | A | -UP[GRADE] | A | Y |
| A | A | -REG[ION] region-list | A | A |
|
REP[LICATE] |
file-name |
-E[DITINSTANCE] | A | A |
| A | A | -N[AME] | V5.5-000 | A |
| A | A | -I[NSTANCE_CREATE] | A | A |
| A | A | -R[ECEIVER | A | A |
| A | A | -S[OURCE] | A | A |
| A | A | -UPDA[TEPROC] | A | A |
|
RE[STORE] |
file-name or file-list |
-[NO]E[XTEND] | A | Y |
|
RU[NDOWN] |
file-name or region-name |
-F[ILE] | A | Y |
| A | A | -R[EGION] | A | A |
| A | A | -RELINKCTL [dir] | A | A |
| A | A | -OVERRIDE | A | A |
|
SE[T] |
file-name or region-name |
SE[T] {-FI[LE] file-name|-JN[LFILE] journal-file-name|-REG[ION] region-list|-REP[LICATION]={ON|OFF}} | A | A |
| A | A | -AC[CESS_METHOD]={BG|MM} | A | Y |
| A | A | -[NO]AS[YNCIO] | A | Y |
| A | A | -DATA_[RESERVED_BYTES]=integer | V7.1-002 | A |
| A | A | -[NO]DE[FER_TIME][=seconds] | A | |
| A | A | -[NO]DEFER_ALLOCATE | V6.2-002 | A |
| A | A | -[NO]EP[OCHTAPER] | V6.2-001 | A |
| A | A | -[NO]ENCRYPTABLE | V6.3-000 | Y |
| A | A | -E[XTENSION_COUNT]=integer(no of blocks) | A | A |
| A | A | -F[LUSH_TIME]=integer | A | A |
| A | A | -FU[LLBLKWRT]={0|1|2} | V6.3-012 | Y |
| A | A | -G[LOBAL_BUFFERS]=integer | A | Y |
| A | A | -H[ARD_SPIN_COUNT]=integer | V6.3-003 | A |
| A | A | -INDEX_[RESERVED_BYTES]=integer | V7.1-002 | A |
| A | A | -[NO]INST[_FREEZE_ON_ERROR] | V6.0-000 | A |
| A | A | -JN[LFILE] journal-file-name | A | Y |
| A | A | -K[EY_SIZE]=bytes | A | Y |
| A | A | -[NO]LCK_SHARES_DB_CRIT | A | Y |
| A | A | -L[OCK_SPACE]=integer | A | Y |
| A | A | -M[UTEX_SLOTS]=integer | V6.0-002 | Y |
| A | A | -N[ULL_SUBSCRIPTS]=value | V6.3-003 | Y |
| A | A | -PA[RTIAL_RECOV_BYPASS] | A | Y |
| A | A | -[NO]Q[DBRUNDOWN] | V6.0-000 | Y |
| A | A | -[NO]REA[D_ONLY] | V6.3-003 | Y |
| A | A | -REC[ORD_SIZE]=bytes | A | Y |
| A | A | -REG[ION] region-list | A | A |
| A | A | -REP[LICATION]={ON|OFF} | A | Y |
| A | A | -RES[ERVED_BYTES]=integer | A | A |
| A | A | -SLEE[P_SPIN_COUNT]=integer | A | A |
| A | A | -SPIN[_SLEEP_MASK]=hexa_mask | V6.3-003 | A |
| A | A | -STAN[DALONENOT] | A | Y |
| A | A | -[NO]STD[NULLCOLL] | V6.3-003 | Y |
| A | A | -[NO]STAT[S] | A | Y |
| A | A | -STATSD[B_ALLOCATION]=integer | V7.0-001 | Y |
| A | A | -V[ERSION]={V5|V6} | -V7.0-000 | A |
| A | A | -W[AIT_DISK]=integer | A | Y |
|
SI[ZE] |
global-name-list region-list |
-H[EURISTIC]=estimation_technique | V6.0-001 | A |
-S[ELECT]=global-name-list | V6.0-001 | A | ||
-R[EGION]=region-list | V6.0-001 | A | ||
|
ST[OP] |
process-id |
process-id | A | N/A |
|
TRIGGER |
- |
-TRIG[GERFILE]=<trigger_definitions_file> | V5.4-002 | A |
| A | A | -NOPR[OMPT] | V5.4-002 | A |
| A | A | -SELE[CT][=name-list|*][<select-output-file>] | V5.4-002 | A |
| A | A | -UPGRADE | V5.4-002 | A |
UP[GRADE] | File-name or region-list | -F[ILE] | V7.1-000 | Y |
-R[EGION] | A | Y |
The following table summarizes the qualifiers.
|
Main Qualifier |
MUPIP Command |
Options/Qualifiers |
GT.M Version* |
Standalone Access# |
|---|---|---|---|---|
-EDITINSTANCE | REPLICATE | -CHANGE | A | A |
| A | A | -DETAIL | A | A |
| A | A | -OFFSET=hexa | A | A |
| A | A | -VALUE=hexa | A | A |
| A | A | -SIZE=hexa | A | A |
| A | A | -VALUE=hexa | A | A |
| A | A | -[NO]QDBRUNDOWN | V6.3-000 | A |
|
-FENCES=<fence-options-list> |
JOURNAL-RECOVER-ROLLBACK |
ALWAYS | A | A |
| A | A | NONE | A | A |
| A | A | PROCESS | A | A |
|
-OFF |
FREEZE |
-OVERRIDE | A | A |
| A | A | -RECORD | A | A |
|
-ON |
FREEZE |
-[NO]ONLINE | A | A |
| A | A | -[NO]AUTORELEASE | A | A |
|
-INSTANCE_CREATE |
REPLICATE |
-NAME | A | A |
| A | A | -NOREPLACE | A | A |
| A | A | -SUPPLEMENTARY | V5.5-000 | A |
| A | A | -[NO]QDBRUNDOWN | V6.3-000 | A |
|
-JOURNAL=<journal-options-list> |
BACKUP SET |
ALIGNSIZE=integer | A | A |
| A | A | ALLOCATION=integer | A | A |
| A | A | AUTOSWITCHLIMIT=integer | A | A |
| A | A | BEFORE_IMAGES | A | A |
| A | A | BUFFER_SIZE=integer | A | A |
| A | A | DISABLE | A | A |
| A | A | ENABLE | A | A |
| A | A | EPOCH_INTERVAL=integer | A | A |
| A | A | EXTENSION=integer | A | A |
| A | A | FILENAME=file_name | A | A |
| A | A | OFF | A | A |
| A | A | ON | A | A |
| A | A | SYNC_IO | A | A |
| A | A | YIELD_LIMIT=integer | A | A |
|
-LOOKBACK_LIMIT=lookback-option-list |
-RECOVER -ROLLBACK |
TIME="time" | A | A |
| A | A | OPERATIONS=integer | A | A |
|
-RECEIVER |
REPLICATE |
-AUTOROLLBACK | V5.5-000 | A |
| A | A | -BUFFSIZE=integer | A | A |
| A | A | -CHANGELOG | A | A |
| A | A | -CHECKHEALTH | A | A |
| A | A | -CMPLVL=integer | A | A |
| A | A | -FILTER=filter_name | A | A |
| A | A | -he[lpers]=[m[,n]] | A | A |
| A | A | -INITIALIZE | V6.0-000 | A |
| A | A | -CMPLVL=n | A | A |
| A | A | -LISTENPORT=integer [ | A | A |
| A | A | -AUTOROLLBACK[=VERBOSE]] | V5.5-000 | A |
| A | A | -LOG=logfile | A | A |
| A | A | -LOG_INTERVAL=integer | A | A |
| A | A | -[NO]RECVBUFFSIZE[=integer] | A | A |
| A | A | -NORESYNC | V5.5-000 | A |
| A | A | -RESUME=strm_num | V5.5-000 | A |
| A | A | -REUSE=instname | V5.5-000 | A |
| A | A | -RSYNC_STRM=strm_num | V5.5-000 | A |
| A | A | -[NO]SENDBUFFSIZE[=integer] | A | A |
| A | A | -SHOWBACKLOG | A | A |
| A | A | -SHUTDOWN | A | A |
| A | A | -START | A | A |
| A | A | -STATSLOG=[ON|OFF] | A | A |
| A | A | -STOPRECEIVERFILTER | V6.3-009 | A |
| A | A | -STOPSOURCEFILTER | A | A |
| A | A | -TIMEOUT=seconds | A | A |
| A | A | -TLSID=label | V6.1-000 | A |
| A | A | -UPDATEONLY | A | A |
| A | A | -UPDOK | V5.5-000 | A |
| A | A | -UPDNOTOK | V5.5-000 | A |
| A | A | -UPDATERESYNC=/path/to/bkup-orig-inst | V5.5-000 | A |
|
-RECOVER |
JOURNAL |
-AFTER=time | A | A |
| A | A | -APPLY_AFTER_IMAGE | A | A |
| A | A | -BACKWARD | A | A |
| A | A | -BEFORE=time | A | A |
| A | A | -[NO]BROKENTRANS[=file] | A | A |
| A | A | -CHAIN | A | A |
| A | A | -CHECKTN | A | A |
| A | A | -[NO]ER[ROR_LIMIT][=integer] | A | A |
| A | A | -FENCES=fence-option-list | A | A |
| A | A | -FORWARD | A | A |
| A | A | -FULL | A | A |
| A | A | -GLOBAL=<global_list> | A | A |
| A | A | -ID=<pid_list> | A | A |
| A | A | -INTERACTIVE | A | A |
| A | A | -LOOKBACK_LIMIT=<lookback_limit_options> | A | A |
| A | A | -[NO]LOSTTRANS[=file] | A | A |
| A | A | -PARA[LLEL][=n] | V6.3-000 | A |
| A | A | -RED[IRECT]=file-pair-list | A | A |
| A | A | -SINCE=time | A | A |
| A | A | -VERBOSE | A | A |
| A | A | -VERIFY | A | A |
|
-EXTRACT |
JOURNAL |
-AFTER=time | A | A |
| A | A | -BEFORE=time | A | A |
| A | A | -[NO]BROKENTRANS[=file] | A | A |
| A | A | -CHAIN | A | A |
| A | A | -CHECKTN | A | A |
| A | A | -[NO]ER[ROR_LIMIT]=integer] | A | A |
| A | A | -FENCES=fence-option-list | A | A |
| A | A | -FULL | A | A |
| A | A | -GLOBAL=<global_list> | A | A |
| A | A | -GV[PATFILE]=/path/to/pattern-file | V6.3-009 | A |
| A | A | -ID=<pid_list> | A | A |
| A | A | -INTERACTIVE | A | A |
| A | A | -LOOKBACK_LIMIT=<lookback_limit_options> | A | A |
| A | A | -[NO]LOSTTRANS[=file] | A | A |
| A | A | -REGION | A | A |
| A | A | -SINCE=time | A | A |
| A | A | -VERBOSE | A | A |
| A | A | -VERIFY | A | A |
|
-ROLLBACK |
JOURNAL |
-APPLY_AFTER_IMAGE | A | A |
| A | A | -BACKWARD | A | A |
| A | A | -BEFORE=time | A | A |
| A | A | -[NO]BROKENTRANS[=file] | A | A |
| A | A | -[NO]ER[ROR_LIMIT][=integer] | A | A |
| A | A | -FENCES=fence-option-list | A | A |
| A | A | -FETCHRESYNC | A | A |
| A | A | -LOOKBACK_LIMIT=<lookback_limit_options> | A | A |
| A | A | -[NO]LOSTTRANS[=file] | A | A |
| A | A | -ONLINE | V5.5-000 | A |
| A | A | -PARA[LLEL][=n] | V6.3-000 | A |
| A | A | -RES[YNC]=hexa;journal_sequence_number | A | A |
| A | A | -VERBOSE | A | A |
| A | A | -VERIFY | A | A |
|
-SHOW=<show-option-list> |
JOURNAL |
-ACTIVE_PROCESSES | A | A |
| A | A | -ALL | A | A |
| A | A | -BROKEN_TRANSACTIONS | A | A |
| A | A | -HEADER | A | A |
| A | A | -PROCESSES | A | A |
| A | A | -STATISTICS | A | A |
| A | A | -AFTER=time | A | A |
| A | A | -USER=user-list | A | A |
| A | A | -TRANSACTION=[KILL|SET] | A | A |
| A | A | -INTERACTIVE | A | A |
| A | A | -GLOBAL=<global_list> | A | A |
| A | A | -ID=<pid_list> | A | A |
| A | A | -INTERACTIVE | A | A |
| A | A | -PARA[LLEL][=n] | V6.3-000 | A |
|
-SINCE |
BACKUP |
-BYTESTREAM | A | A |
| A | A | -COMPREHENSIVE | A | A |
| A | A | -DATABASE | A | A |
| A | A | -INCREMENTAL | A | A |
| A | A | -RECORD | A | A |
|
-SO[URCE] |
REPLICATE |
-ACTIVATE | A | A |
| A | A | -BUFFSIZE=integer | A | A |
| A | A | -CHANGELOG | A | A |
| A | A | -CHECKHEALTH | A | A |
| A | A | -CMPLVL=integer | A | A |
| A | A | -CONNECTPARAMS=connection_options | A | A |
| A | A | -DEACTIVATE | A | A |
| A | A | -DETAIL | A | A |
| A | A | -FILTER=filter_name | A | A |
| A | A | -FREEZE=on|off | V6.0-000 | A |
| A | A | -[NO]COMMENT=string | A | A |
| A | A | -INSTSECONDARY=secondary_instance name | A | A |
| A | A | -NOJNLFILEONLY | V6.2-001 | A |
| A | A | -JNLPOOL-LOG=log_file | A | A |
| A | A | -LOG_INTERVAL=integer | A | A |
| A | A | -LOSTTNCOMPLETE | A | A |
| A | A | -NEEDRESTART | A | A |
| A | A | -PASSIVE | A | A |
| A | A | -[NO]PLAINTEXTFALLBACK | V6.1-000 | A |
| A | A | -PROPAGATEPRIMARY | A | A |
| A | A | -[NO]RECVBUFFSIZE[=integer] | V7.1-002 | A |
| A | A | -RENEGOTIATE_INTERVAL=minutes | A | A |
| A | A | -ROOTPRIMARY | A | A |
| A | A | -SECONDARY=secondary_instance_name | A | A |
| A | A | -[NO]SENDBUFFSIZE[=integer] | V7.1-002 | A |
| A | A | -SHOWBACKLOG | A | A |
| A | A | -SHUTDOWN | A | A |
| A | A | -START | A | A |
| A | A | -STATSLOG | A | A |
| A | A | -STOPSOURCEFILTER | A | A |
| A | A | -TIMEOUT=seconds | A | A |
| A | A | -TLSID=label | V6.1-000 | A |
| A | A | -UPDOK | A | A |
| A | A | -UPDNOTOK | A | A |
| A | A | -ZEROBACKLOG | A | A |
|
-VERSION={V5|V6} |
DOWNGRADE UPGRADE |
file-name | -V7.0-000 | A |
* denotes the GT.M version in which the qualifier or command was first introduced. Versions that start with a minus sign, -, denote versions where the qualifier or command was removed. This column is maintained for qualifiers and command introduced in GT.M versions starting with GT.M V5.4-002.
# Additional information about Standalone Access:
Although MUPIP EXTRACT does not require standalone access, without the -FREEZE qualifier to prevent the database to prevent updates, it does not guarantee a consistent state. Therefore, from an application standpoint, you might plan for a standalone access during a MUPIP EXTRACT operation.
Although MUPIP LOAD does not require standalone access, you should always assess the significance of performing a MUPIP LOAD operation when an application is running because it may result in an inconsistent application state for the database.
MUPIP commands that need standalone access issue a MUUSERLBK error on a crashed replication-enabled database and MUUSERECOV error in case of a non-replicated-but-journaled database.
