Skip to content

DSE Command Summary

DSE Command Summary

COMMANDQUALIFIERSCOMMENTS
AD[D]-B[LOCK]=block number-
--D[ATA]=stringIncompatible with -POINTER, -STAR
--K[EY]=keyIncompatible with -STAR
--O[FFSET]=offsetIncompatible with -RECORD, -STAR
--P[OINTER]=pointerIncompatible with -DATA
--R[ECORD]=record-numberIncompatible with -OFFSET, -STAR
--S[TAR]Incompatible with -DATA,-KEY, -OFFSET, -RECORD
AL[L]-A[LL]Meaningful only with -DUMP
--B[UFFER_FLUSH]Incompatible with -RENEW
--C[RITINIT]Incompatible with -RENEW, -RELEASE, -SEIZE
--D[UMP]Use with: -ALL
--[NO]F[REEZE]Incompatible with -RENEW
--O[VERRIDE]Meaningful only with -[NO]FREEZE
--REF[ERENCE]Incompatible with -RENEW
--REL[EASE]Incompatible with -CRITINIT, -RENEW,-SEIZE
--REN[EW]Use alone
--S[EIZE]Incompatible with -RENEW, -RELEASE, -CRITINIT
--W[CINIT]Incompatible with -RENEW
CA[CHE]-ALLUsed with -RECOVER, -SHOW, and -VERIFY
--RE[COVER]Use only with -ALL.
--SH[OW]Use only with -ALL.
--VE[RIFY]Use only with -ALL.
CH[ANGE]-BL[OCK]=block numberIncompatible with -FILEHEADER and qualifiers used with -FILEHEADER
--BS[IZ]=block-sizeUse only with -BLOCK, -LEVEL, -TN
--L[EVEL]=levelUse only with -BLOCK, -BSIZ, -TN
--TN [=transaction number]Use only with -BLOCK, -BSIZ, -LEVEL
--OF[FSET]=offsetUse only with -BLOCK, -CMPC, -RSIZ
--RE[CORD]=record numberUse only with -BLOCK, -CMPC, -RSIZ
--CM[PC]= compression countUse only with -BLOCK, -RECORD, -OFFSET, -RSIZ
--RS[IZ]=record sizeUse only with -CMPC -OFFSET, -RECORD, -BLOCK
--F[ILEHEADER]Incompatible with -BSIZ, -CMPC, -TN, -LEVEL, -OFFSET, -RECORD, -RSIZ
-AVG_BLKS_READ=Average blocks read-
-B_B[YTESTREAM]=transaction number-
--B_C[OMPREHENSIVE]=transaction numberUse only with -FILEHEADER; decimal
-B_D[ATABASE] = transaction numberUse only with -FILEHEADER; decimal
--B_I[NCREMENTAL] = transaction numberUse only with -FILEHEADER; decimal
--BLK[_SIZE]=block sizeUse only with -FILEHEADER; decimal
--BLO[CKS_FREE]=free blocksUse only with -FILEHEADER; decimal
--B_R[ECORD]=transaction numberUse only with -FILEHEADER; decimal
--CO[RRUPT_FILE]=valueUse only with -FILEHEADER
--CU[RRENT_TN]=transaction numberUse only with -FILEHEADER
--DATA[_RESERVED_BYTES]=data_reserved bytesUse only with -FILEHEADER;decimal
-DECL[OCATION]=valueUse only with -FILHEADER; decimal
-DEF[_COLLATION]=valueUse only with -FILEHEADER;
--ENCRYPTION_HASHUse only with -FILEHEADER
--FL[USH_TIME][=delta time]Use only with -FILEHEADER
--FR[EEZE]=valueUse only with -FILEHEADER
--FU[LLY_UPGRADED]=booleanUse only with -FILEHEADER
--GV[STATSRESET]Use only with -FILEHEADER
--HARD_SPIN_COUNT=Mutex hard spin countUse only with -FILEHEADER
-HEXL[OCATION]=valueUse only with -FILEHEADER;hexa
--INDEX[_RESERVED_BYTES]=index_reserved_bytesUse only with -FILEHEADER;decimal
--INT[ERRUPTED_RECOV]=boolean
--JNL_YIELD_LIMIT=journal yeild limit
--K[EY_MAX_SIZE]=key_max_sizeUse only with -FILEHEADER; decimal
--M[ACHINE_NAM]=value
--N[ULL_SUBSCRIPTS]=valueUse only with -FILEHEADER
--NO[CRIT]
--OV[ERRIDE]
--RC_SRV_COUNT
--RE_READ_TRIGGER=read trigger
--Q[UANTUM_INTERVAL] [=delta time]Use only with -FILEHEADER; decimal
--REC[ORD_MAX_SIZE]=maximum record sizeUse only with -FILEHEADER; decimal
--REF[ERENCE_COUNT]=reference countUse only with -FILEHEADER; decimal
--REG[_SEQNO]=sequence numberUse only with -FILEHEADER; hexa
--RESERVED_BYTES=reserved bytesUse only with -FILEHEADER;decimal
--[NO] RES[PONSE_INTERVAL] [=delta time]Use only with -FILEHEADER; decimal
--SLEEP_SPIN_COUNT=mutex sleep spin countUse only with -FILEHEADER;
--SPIN_SLEEP_TIME=mutex sleep time
--[NO]S[TALENESS_TIMER] [=delta time]Use only with -FILEHEADER; decimal
--TIC[K_INTERVAL] [=delta time]Use only with -FILEHEADER; decimal
--TIM[ERS_PENDING]=timers pendingUse only with -FILEHEADER; decimal
--TO[TAL_BLKS]=total_blocksUse only with -FILEHEADER
--TR[IGGER_FLUSH]=trigger flushUse only with -FILEHEADER
--W[RITES_PER_FLUSH]=writes per flushUse only with -FILEHEADER; decimal
--WAIT_DISK=wait disk-
--Zqgblmod_S[EQNO] = sequence numberUse only with -FILEHEADER;hexa
--Zqgblmod_TN=sequence_numberUse only with -FILEHEADER;hexa
CL[OSE]--
CR[ITICAL]-I[NIT]Use only with -RESET
--O[WNER]Use alone
--REL[EASE]Use alone
--REM[OVE]Use alone
--RES[ET]Use only with -INIT
--S[EIZE]Use alone
D[UMP]-B[LOCK]=block_numberIncompatible with -FILEHEADER
--C[OUNT]=countIncompatible with -FILEHEADER
--F[ILEHEADER]Use alone
--G[LO]Incompatible with -FILEHEADER, -HEADER
--G[VSTATS]Use only with -FILEHEADER
--[NO]H[EADER]Incompatible with -FILEHEADER, -GLO
--O[FFSET]=offsetIncompatible with -FILEHEADER, -RECORD
--R[ECORD]=record_numberIncompatible with -FILEHEADER, -OFFSET
EV[ALUATE]-D[ECIMAL]Incompatible with -HEXADECIMAL
--H[EXADECIMAL]Incompatible with -DECIMAL
--N[UMBER]=numberRequired
EX[IT]-
F[IND]-B[LOCK]=block_numberIncompatible with -KEY, -REGION
--E[XHAUSTIVE]Incompatible with -KEY, -REGION, -FREEBLOCK
--F[REEBLOCK]Required with -HINT; compatible with -BLOCK
--H[INT]=block_numberRequired with -FREEBLOCK
--K[EY]=keyUse alone
--R[EGION][=region]Use alone
--SI[BLINGS]Incompatible with -FREEBLOCK, -HINT, -KEY, -REGION
H[ELP][help topic]-
I[NTEGRIT]-B[LOCK]=block_number-
M[APS]-BL[OCK]=block_numberIncompatible with -RESTORE_ALL
--BU[SY]Compatible only with -BLOCK
--F[REE]-
--M[ASTER]-
--R[ESTORE_ALL]Use alone
OP[EN]-F[ILE]=file-
OV[ERWRITE]-B[LOCK]=block_number -D[ATA]=string-
--O[FFSET]=offset-
P[AGE]--
RA[NGE]-F[ROM]=block_number-
--T[O]=block_number-
--I[NDEX]=block_number -L[OST]=block_number -[NOT]BUSY=busy/free -S[TAR]=block_number -L[OWER]=key-
--U[PPER]=key-
REM[OVE]-B[LOCK]=block-number-
--C[OUNT]=countIncompatible with -VERSION
--O[FFSET]=offsetIncompatible with -VERSION, -RECORD
--R[ECORD]=record-numberIncompatible with -VERSION, -OFFSET
--V[ERSION]=version-numberUse only with -BLOCK; decimal
RES[TORE]-B[LOCK]=block-number-
--F[ROM]=block-number-
--R[EGION]=region-
--V[ERSION]=version-numberRequired; decimal
SA[VE]-B[LOCK]=block-number-
--C[OMMENT]=stringIncompatible with -LIST
--L[IST]Incompatible with -COMMENT
SH[IFT]-B[ACKWARD]=shiftIncompatible with -FORWARD
--F[ORWARD]=shiftIncompatible with -BACKWARD
--O[FFSET]=offset-
SP[AWN][CLI command]-
W[CINIT]--

* Use these qualifiers only with instructions from FIS.