MUPIP Command Summary

COMMAND	OBJECTS	MAIN QUALIFIER	GT.M version*	Standalone Access#
B[ACKUP]	region-list	-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
CRE[ATE]	-	-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
FR[EEZE]	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
HE[LP]	command-option	-		A
INTE[G]	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
INTR[PT]	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
RES[TORE]	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
SEM[APHORE]	sem-ids-list	A	A	A
SET	file-name or region-name	{-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
TR[IGGER]	-	-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.

PrevA	Up	A Next
A	Home	A

MUPIP Command SummaryChapterA 5.A General Database Management

MUPIP Command Summary

MUPIP Command Summary
ChapterA 5.A General Database Management