The general format of DSE commands is:
command [-qualifier[...]] [object[,...]]
ADD [-B[LOCK]=[block] {-OFFSET=offset|-RECORD=record} -STAR -POINTER=block
ADD [-B[LOCK]=[block] {-OFFSET=offset|-RECORD=record} -KEY=key -POINTER=pointer
The format of the ADD command for level 0 blocks is:
ADD [-B[LOCK]=[block] {-OFFSET=offset|-RECORD=record} -KEY=key -DATA=string
Specifies the block to receive the new record.
Incompatible with: -STAR,-POINTER
Adds the new record at the next record boundary after the specified offset.
Incompatible with: -RECORD, -STAR
Specifies a record number of the new record.
DSE>add -block=6F -record=57 -key="^Capital(""Mongolia"")" -data="Ulan Bator"
DSE>add -star -bl=59A3 -pointer=2
DSE>add -block=3 -record=4 -key="^Fruits(4)" -data="Grapes"
Block 3 Size 4B Level 0 TN 4 V6 Rec:1 Blk 3 Off 10 Size 14 Cmpc 0 Key ^Fruits(1) 10 : | 14 0 0 0 46 72 75 69 74 73 0 BF 11 0 0 41 70 70 6C 65| | . . . . F r u i t s . . . . . A p p l e| Rec:2 Blk 3 Off 24 Size D Cmpc 8 Key ^Fruits(2) 24 : | D 0 8 0 21 0 0 42 61 6E 61 6E 61 | | . . . . ! . . B a n a n a | Rec:3 Blk 3 Off 31 Size D Cmpc 8 Key ^Fruits(3) 31 : | D 0 8 0 31 0 0 43 68 65 72 72 79 | | . . . . 1 . . C h e r r y | Rec:4 Blk 3 Off 3E Size D Cmpc 8 Key ^Fruits(4) 3E : | D 0 8 0 41 0 0 47 72 61 70 65 73 | | . . . . A . . G r a p e s |
$dse add -star -bl=1 -pointer=2
$ dse add -block=4 -key="^Vegetables" -pointer=7 -offset=10
This command creates a block with key ^Vegetables pointing to block 7.
DSE> add -record=2 -key="^foo" -data=\'\'
This example adds a new node (set ^foo="") as the second record of the current database block.
The format of the ALL command is:
AL[L] [ -B[UFFER_FLUSH] -C[RITINIT] -D[UMP] -A[LL] -[NO]F[REEZE] -O[VERRIDE]] -REF[ERENCE] -REL[EASE] -REN[EW] -S[EIZE] -W[CINIT] ]
Initializes critical sections for all regions of the current directory.
Incompatible with: -RENEW, -RELEASE, -SIEZE
![]() | Caution |
---|---|
Never use CRITINIT while concurrent updates are in progress as doing so may damage the database. |
Displays fileheader information.
Freezes or prevents updates all regions of the current global directory.
A frozen region may be unfrozen for updates in one of two ways: The process which froze the region may unfreeze it with the -NOFREEZE qualifier; or another process may override the freeze in conjunction with the -OVERRIDE qualifier.For more information on a preferred method of manipulating FREEZE, refer to a??FREEZE a??.
By default, the -NOFREEZE qualifier unfreezes only those GDS regions that were previously frozen by a process . Once a region is unfrozen, it may be updated by any process .To unfreeze all GDS regions of the Global Directory, use the -OVERRIDE qualifier.
DSE releases any FREEZE it holds when it exits, therefore, use the same DSE invocation or SPAWN to perform operations after executing the ALL -FREEZE command.
Incompatible with: -RENEW
Overrides the ALL -FREEZE or ALL -NOFREEZE operation.
Meaningful only with: [NO]FREEZE
Resets the reference count field to 1 for all regions of the current global directory.
Releases critical sections for all regions of the current global directory.
Incompatible with: -CRITINIT, -RENEW, -SEIZE
Incompatible with: -RENEW, -RELEASE, -CRITINIT
Reinitializes the buffers for all regions of the current global directory.
-WCINIT requires confirmation.
![]() | Caution |
---|---|
This operation is likely to cause database damage when used while concurrent updates are in progress. |
DSE> all flush -buffer_flush
This command flushes the file header and cache buffers to disk for all regions.
DSE> ALL -CRITINIT
This command initializes critical sections for all regions of the current directory.
DSE> ALL -FREEZE DSE> SPAWN "mumps -dir"
DSE> ALL -NOFREEZE -OVERRIDE
This command removes the FREEZE on all current region including the FREEZE placed by other users.
DSE> ALL -REFERENCE
This command sets the reference count field in the file header(s) to 1.
DSE> ALL -RELEASE
DSE> ALL -RENEW
DSE> ALL -SEIZE
This command seizes all critical sections for all regions of the current global directory.
DSE> ALL -WCINIT
This command reinitializes the buffers for all regions of the current global directory.
Flushes the file header and the current region's buffers to disk.
The format of the BUFFER_FLUSH command is:
B[UFFER_FLUSH]
The CHANGE command changes fields of a block, file, or record header.
The format of the CHANGE command is:
CH[ANGE]
-BL[OCK]=block-number and one or more of the following qualifiers:
-BS[IZ]=block-size -L[EVEL]=level -TN[=transaction-number] -OF[FSET]=offset -RE[CORD]=record-number -CM[PC]=compression-count -RS[IZ]=record-size
-F[ILEHEADER] and one or more of the following qualifiers:
-AB[ANDONED_KILLS]=value -AVG_BLKS_READ=Average-blocks-read -B_B[YTESTREAM]=transaction-number -B_C[OMPREHENSIVE]=transaction-number -B_D[ATABASE]=transaction-number -B_I[NCREMENTAL]=transaction-number -B_R[ECORD]=transaction-number -BLK_SIZE=block-size -BLO[CKS_FREE]=free-blocks -CU[RRENT_TN]=transaction-number -COM[MITWAIT_SPIN_COUNT]=boolean -DATA[_RESERVED_BYTES]=reserved-bytes -DEC[LOCATION]=value -DEF[_COLLATION]=value -ENCRYPTION_HASH -FL[USH_TIME][=delta-time] -FR[EEZE]=value -FU[LLY_UPGRADED]=boolean -GV[STATSRESET] -HA[RD_SPIN_COUNT]=Mutex-hard-spin-count -HE[XLOCATION]=value -INDEX[_RESERVED_BYTES]=reserved-bytes -INT[ERRUPTED_RECOV]=boolean -JNL_YIELD_LIMIT=journal-yeild-limit -KE[Y_MAX_SIZE]=key-max-size -KI[LL_IN_PROG]=value -M[ACHINE_NAM]=value -N[ULL_SUBSCRIPTS]=value -NO[CRIT] -OV[ERRIDE] -Q[DBRUNDOWN] -RC_SRV_COUNT -RE_READ_TRIGGER=read-trigger -REC[ORD_MAX_SIZE]=record-max-size -REF[ERENCE_COUNT]=reference-count -REG[_SEQNO]=sequence-number -RESERVED_BYTES=reserved-bytes -SLEE[P_SPIN_COUNT]=mutex-sleep-spin-count -SPIN[_SLEEP_MASK]=mutex-spin-sleep-mask -STRM_NUM=stream-number STRM_REG_SEQNO=hexa -TIM[ERS_PENDING]=integer -TO[TAL_BLKS]=total-blocks -TR[IGGER_FLUSH]=trigger-flus -UPD_RESERVED_AREA=reserved-area -UPD_WRITER_TRIGGER_FACTOR=trigger-factor -W[RITES_PER_FLUSH]=writes-per-flush -WAIT_DISK=wait-disk -Zqgblmod_S[EQNO]=sequence-number -Zqgblmod_TN=sequence-number
This section describes -BLOCK and all of its qualifiers.
Incompatible with: -FILEHEADER and qualifiers used with -FILEHEADER
The following qualifiers operate on a block header.
Changes the block size field of the specified block.
![]() | Note |
---|---|
The block size must always be less than or equal to the block size in the file header. |
Use only with: -BLOCK, -LEVEL, -TN
Changes the level field for the specified block.
![]() | Note |
---|---|
DSE lets you change the level of a bitmap block to -1 (the value of the level for a bitmap block) when the bitmap level gets corrupted and takes on an arbitrary value. Note that you should specify -1 in hexadecimal form, that is, FF. |
Use only with: -BLOCK, -BSIZ, -TN
DSE >change -level=FF
Changes the transaction number for the current block.
Use only with: -BLOCK, -BSIZ, -LEVEL
Use only with: -BLOCK, -CMPC, and -RSIZ.
-RE[CORD]=record_number
Specifies the record number of the target record.
Use only with: -BLOCK, -CMPC, and -RSIZ.
-CM[PC]=compression_count
Change the compression count field of the specified record.
The compression count specifies the number of bytes at the beginning of a key that are common to the previous key in the same block.
Because compression counts propagate from the "front" of the block, this can potentially change the keys of all records following it in the block. If the goal is to change only a single record, it may be preferable to add a new record and remove the old one.
Use only with: -BLOCK, -RECORD, -OFFSET, -RSIZE
-RS[IZ]=record_size
Changes the record size field of the specified record.
![]() | Caution |
---|---|
Changing -RSIZ impacts all records following it in the block. |
Use only with: -BLOCK, -RECORD, -CMPC, -OFFSET
Example:
DSE> change -record=3 -rsiz=3B -block=2
This command changes the record size of record 3 block 2 to 59 (Hex: 3B) bytes.
Modifies a file header element that you specify with an associated qualifier.
Incompatible with: -BSIZ, -CMPC, -TN, -LEVEL, -OFFSET, -RECORD, -RSIZ
Changes the decimal block size field of the current file.
Changes the hexadecimal free blocks field of the current file.
-B[YTESTREAM]=transaction_number
-D[ATABASE]=transaction_number
-B_R[ECORD]=transaction_number
%GTM-W-DBFLCORRP, /home/gtmnode1/mumps.dat Header indicates database file is corrupt
![]() | Caution |
---|---|
After a CHANGE -FILEHEADER -CORRUPT=TRUE, the file is unavailable to future GT.M access other than DSE. Under normal conditions, there should never be a need to change this flag manually. A MUPIP SET -PARTIAL_BYPASS_RECOV sets this flag to false. |
-COM[MITWAIT_SPIN_COUNT]=value
-CU[RRENT_TN]=transaction_number
Changes the hexadecimal current transaction number for the current region.
-DATA[_RESERVED_BYTES]=data_reserved_bytes
Sets data reserved bytes. GT.M will not utilize whatever space is reserved in performing updates on data blocks in the database.
Use only with: -FILEHEADER
Changes the hash of the password stored in the database file header if and when you change the hash library. For more information on key management and reference implementation, refer to ChapterA 12: a??Database Encryptiona??.
![]() | Caution |
---|---|
An incorrect hash renders the database useless. |
Use only with: -FILEHEADER
For more information, refer to a??Region Qualifiersa??.
Changes the flush_time default interval (in delta_time).
For information about a preferred method of manipulating FREEZE, refer to a??FREEZE a?? of the General Database Management chapter.
DSE releases -FREEZE when it EXITs. To hold the database(s), CHANGE -FILEHEADER -FREEZE=TRUE and then SPAWN to perform other operations.
-GV[STATSRESET]
Resets all the database file header global access statistics to 0. Note that this erases all statistics previously accumulated in the database file header.
Use only with: -FILEHEADER
-HEXLOCATION
Specifies a hexadecimal offset with the file header. If -VALUE is specified, GT.M puts it at that location.
Use only with: -FILEHEADER
-INDEX[_RESERVED_BYTES]=index_reserved_bytes
Sets index reserved bytes. GT.M will not utilize whatever space is reserved in performing updates on index blocks in the database.
Use only with: -FILEHEADER
-INT[ERRUPTED_RECOV]=boolean
Sets a flag that indicates whether or not a recovery with the MUPIP JOURNAL -RECOVER command was interrupted. The value is either T[RUE] or F[ALSE].
Use only with: -FILEHEADER
-K[EY_MAX_SIZE]=key_max_size
Changes the decimal value for the maximum allowable key size. Reducing KEY_MAX_SIZE can restrict access to existing data and cause GT.M to report errors. Do not create incompatible key and record sizes.
Before permanently changing the key size using DSE, use GDE to check that the appropriate Global Directory contains the same key size for the region. This prepares for future MUPIP CREATEs and performs a consistency check on the key and record size values. For more information on key and record sizes, refer to ChapterA 4: a??Global Directory Editora??.
Use only with: -FILEHEADER
Controls whether GT.M accepts null subscripts in database keys.
Releases or "steals" a FREEZE owned by another process.
For more information, refer to a??Region Qualifiersa??.
-REC[ORD_MAX_SIZE]=record_max_size
Before making a permanent change to the records size using DSE, use GDE to check that the appropriate Global Directory contains the same record size for the region. This prepares for future MUPIP CREATEs and performs a consistency check on the key and record size values. For more information on key and record sizes, refer to ChapterA 4: a??Global Directory Editora??.
-REF[ERENCE_COUNT]=reference_count
-REG[_SEQNO]=sequence-number
In an LMS environment, this sets the "Region Seqno" field. For more information, refer to ChapterA 7: a??Database Replicationa??.
-RESERVED_BYTES=reserved_bytes
Sets both data and index reserved bytes. GT.M will not utilize whatever space is reserved in a block.
Use only with: -FILEHEADER
-RESYNC_S[EQNO]=sequence-number
In an LMS environment, this sets the hexadecimal value of the "Resync Seqno" field. For more information, refer to ChapterA 7: a??Database Replicationa??.
In an LMS environment, this sets the hexadecimal value ofthe "Resync transaction" field. For more information, refer to ChapterA 7: a??Database Replicationa??.
-SPIN_SLEEP_MASK]=hexadecimal-mask
Changes the collation of empty string ("NULL") subscripts for the database file. Although it is not the default, STDNULLCOLL is required with certain other characteristics, and highly recommended in any case. If you change this when there are existing "NULL" subscripts the results may be problematic. FIS recommends you establish this characteristic with GDE and load data with a consistent setting.
Use only with: -FILEHEADER
-STRM_NUM=stream-number -STRM_R[EG_SEQNO]=str_num's_region_sequence_number
-TI[MERS_PENDING]=timers_pending
Use the CHANGE -TIMERS_PENDING qualifier only upon receiving instructions from FIS.
-TO[TAL_BLKS]=total_blocks
Changes the hexadecimal total blocks field of the current file. Use only with: -FILEHEADER
![]() | Caution |
---|---|
The total blocks field should always reflect the actual size of the database. Change this field only if it no longer reflects the database size. |
-TR[IGGER_FLUSH]=trigger_flush
Sets the decimal value for the triggering threshold, in buffers, for flushing the cache-modified queue.
Use the CHANGE -TRIGGER_FLUSH qualifier only upon receiving instructions from FIS, and only in conjunction with the -FILEHEADER qualifier.
-WR[ITES_PER_FLUSH]=writes_per_flush
Set the decimal number of block to write in each flush. The default value is 7.
Use only with -FILEHEADER
DSE> change -block=3 -bsiz=400
This command changes the size of block 3 to 1024 bytes.
DSE> change -block=4 -tn=10000
This command changes sets the transaction number to 65536 (Hex: 10000) for block 4.
DSE> change -block=2 -record=4 -CMPC=10 -key="^CUS(""Jones,Vic"")"
RECORD KEY | COMPRESSION COUNT | RESULTING KEY in Record |
---|---|---|
CUS(Jones,Tom) | 0 | CUS(Jones,Tom) |
CUS(Jones,Vic) | 10 | Vic) |
CUS(Jones,Sally) | 10 | Sally) |
CUS(Smith,John) | 4 | Smith,John) |
DSE> dump -fileheader
This command displays fields of the file header.
DSE> change -fileheader -blk_siz=2048
DSE> change -fileheader -blocks_free=5B
This command changes the blocks free fields of the file header to 91 (Hex: 5B). Example:
DSE> change -fileheader -b_record=FF
This command sets the RECORD backup transaction to FF.
DSE> change -fileheader corrupt_file=FALSE
This command sets the CORRUPT_FILE field to false.
DSE> change -fileheader -current_tn=1001D1BF817
DSE> change -fileheader -flush_time=00:00:02:00
This command changes the flush time field of the file header to 2 seconds.
DSE> change -fileheader -freeze=true
This command makes the default region unavailable for updates.
DSE> change -fileheader -key_max_size=20
This command changes the maximum key size to 20. Note that the default max key size is 64.
DSE> CHANGE -FILEHEADER -NULL_SUBSCRIPTS="EXISTING"
DSE> change -fileheader -record_max_size=496
This command sets the maximum record size as 496 for the default region.
DSE> change -fileheader -reference_count=5
This command sets the reference count field of the file header to 5.
DSE> change -fileheader -timers_pending=2
This command sets the timers pending field of the file header to 2.
DSE> change -fileheader -TOTAL_BLKS=64
This command sets the total size of the database to 100 (Hex: 64) blocks.
DSE> change -fileheader -trigger_flush=1000
DSE> change -fileheader -writes_per_flush=10
DSE> change -fileheader -zqgblmod_seqno=FF
This command changes the ZGBLMOD_SEQNO field to 255(Hex: FF).
Operates on the cache of a database having BG access method. The format of the CACHE command is:
CA[CHE] [ -ALL -RE[COVER] -SH[OW] -VE[RIFY] ]
Resets the cache of a database having BG access method to a "clean" state.
DSE> CACHE -VERIFY
DSE> CACHE -VERIFY -ALL Time 26-FEB-2011 14:31:30 : Region DEFAULT : Cache verification is clean Execute CACHE recover command if Cache verification is "NOT" clean.
This command reports the state of database cache for all regions.
DSE> CACHE -RECOVER
DSE> CACHE -SHOW File /home/jdoe/node1/areg.dat Region AREG Region AREG : Shared_memory = 0x00002B6845040000 Region AREG : node_local = 0x0000000000000000 Region AREG : critical = 0x0000000000010000 Region AREG : shmpool_buffer = 0x0000000000023000 Region AREG : lock_space = 0x0000000000125000 Region AREG : cache_queues_state = 0x000000000012A000 Region AREG : cache_que_header = 0x000000000012A030 : Numelems = 0x00000407 : Elemsize = 0x00000098 Region AREG : cache_record = 0x0000000000150458 : Numelems = 0x00000400 : Elemsize = 0x00000098 Region AREG : global_buffer = 0x0000000000177000 : Numelems = 0x00000400 : Elemsize = 0x00000400 Region AREG : db_file_header = 0x0000000000277000 Region AREG : bt_que_header = 0x00000000002B7000 : Numelems = 0x00000407 : Elemsize = 0x00000040 Region AREG : th_base = 0x00000000002C71D0 Region AREG : bt_record = 0x00000000002C7200 : Numelems = 0x00000400 : Elemsize = 0x00000040 Region AREG : shared_memory_size = 0x00000000002D8000 DSE>
CR[ITICAL] [ -A[LL] -I[NIT] -O[WNER] -REL[EASE] -REM[OVE] -RES[ET] -S[EIZE] ]
Reinitializes the critical section.
DSE> critical -OWNER Write critical section is currently unowned
Releases the critical section if the process running DSE owns the section.
![]() | Caution |
---|---|
Using CRITICAL -REMOVE when the write owner of a critical section is an active GT.M process may cause structural database damage. |
Displays the number of times the critical section has been through an online reinitialization.
Displays blocks, records, or file headers. DUMP is one of the primary DSE examination commands.
The format of the DUMP command is:
D[UMP] [ -A[LL] -B[LOCK]=block_number -C[OUNT]=count -F[ILEHEADER] -G[LO] -G[VSTATS] -[NO]C[RIT] -[NO]H[EADER] -O[FFSET]=offset -R[ECORD]=record-number -U[PDPROC] -Z[WR] ]
Meaningful only with: -FILEHEADER
Incompatible with: -ALL, -FILEHEADER and -UPDPROC.
Specifies the number of blocks, block headers, or records to DUMP.
Incompatible with: -ALL, -FILEHEADER and -UPDPROC.
Use only with -ALL or -UPDPROC
-G[LO]
Dumps the specified record or blocks into the current output file in Global Output (GO) format. FIS strongly suggests using -ZWR rather than -GLO as the ZWR format handles all possible content values, including some that are problematic with -GLO.[The GLO format is not supported for UTF-8 mode - use the ZWR format with UTF-8 mode.
Incompatible with: -ALL, -FILEHEADER, -UPDPROC and -ZWR.
-G[VSTATS]
Displays the access statistics for global variables and database file(s).
By default, DUMP displays all information in a block or record.
Incompatible with: -ALL, -FILEHEADER, -GLO, -UPDPROC and -ZWR.
Incompatible with: -ALL, -FILEHEADER, and -RECORD.
Incompatible with: -ALL, -FILEHEADER, and -OFFSET.
-U[PDPROC]
Displays the helper process parameters with the fileheader elements.
Use only with -FILEHEADER.
-Z[WR]
Dumps the specified record or blocks into the current output file in ZWRITE (ZWR) format.
Incompatible with: -ALL, -GLO, -HEADER and -FILEHEADER.
DSE> DUMP -FILEHEADER
This command displays an output like the following:
File /home/jdoe/.fis-gtm/V7.1-002_x86_64/g/gtm.dat Region DEFAULT File /home/jdoe/.fis-gtm/V7.1-002_x86_64/g/gtm.dat Region DEFAULT Date/Time 12-SEP-2023 17:31:20 [$H = 66729,63080] Access method BG Global Buffers 1024 Block size (in bytes) 4096 Maximum record size 256 Starting VBN 8193 Maximum key size 64 Total blocks 0x0000000000000065 Null subscripts NEVER Free blocks 0x0000000000000062 Standard Null Collation FALSE Free space 0x00000000 Last Record Backup 0x0000000000000001 Extension Count 100 Last Database Backup 0x0000000000000001 Number of local maps 1 Last Bytestream Backup 0x0000000000000001 Lock space 0x00000028 In critical section 0x00000000 Timers pending 0 Cache freeze id 0x00000000 Flush timer 00:00:01:00 Freeze match 0x00000000 Flush trigger 960 Freeze online FALSE Freeze online autorelease FALSE Current transaction 0x0000000000000001 No. of writes/flush 7 Maximum TN 0xFFFFFFF803FFFFFF Certified for Upgrade to V7 Maximum TN Warn 0xFFFFFFD813FFFFFF Desired DB Format V7 Master Bitmap Size 8176 Blocks to Upgrade 0x0000000000000000 Create in progress FALSE Modified cache blocks 0 Reference count 1 Wait Disk 0 Journal State [inactive] ON Journal Before imaging TRUE Journal Allocation 2048 Journal Extension 2048 Journal Buffer Size 2312 Journal Alignsize 4096 Journal AutoSwitchLimit 8386560 Journal Epoch Interval 300 Journal Yield Limit 8 Journal Sync IO FALSE Journal File: /home/jdoe/.fis-gtm/V7.0-002_x86_64/g/gtm.mjl Mutex Hard Spin Count 128 Mutex Sleep Spin Count 128 Mutex Queue Slots 1024 KILLs in progress 0 Replication State OFF Region Seqno 0x0000000000000001 Zqgblmod Seqno 0x0000000000000000 Zqgblmod Trans 0x0000000000000000 Endian Format LITTLE Commit Wait Spin Count 16 Database file encrypted FALSE Inst Freeze on Error FALSE Spanning Node Absent TRUE Maximum Key Size Assured TRUE Defer allocation TRUE Spin sleep time mask 0x00000000 Async IO OFF WIP queue cache blocks 0 DB is auto-created FALSE DB shares gvstats TRUE LOCK shares DB critical section FALSE Read Only OFF Recover interrupted FALSE Full Block Write 0 StatsDB Allocation 2050 Data Reserved Bytes 0 Index Reserved Bytes 0
$ dse dump -fileheader -updproc
This command displays the fileheader elements along with the following helper process parameters:
Upd reserved area [% global buffers] 50 Avg blks read per 100 records 200 Pre read trigger factor [% upd rsrvd] 50 Upd writer trigger [%flshTrgr] 33
For more information, refer to the fileheader elements section in a??GT.M Database Structure(GDS)a??.
Translates a hexadecimal number to decimal, and vice versa.
The format of the EVALUATE command is:
EV[ALUATE] [ -D[ECIMAL] -H[EXADECIMAL] -N[UMBER]=number ]
Specifies that the input number has a decimal base.
Incompatible with: -HEXADECIMAL .
Locates a given block or region. The format of the FIND command is:
F[IND] [ -B[LOCK]=block-number -E[XHAUSTIVE] -F[REEBLOCK] -H[INT] -K[EY]=key -[NO]C[RIT] -R[EGION][=region] -SI[BLINGS] -ST[ATS] ]
Incompatible with: -KEY, -REGION
Searches the entire index structure for the desired path or siblings.
![]() | Note |
---|---|
A doubly allocated block may cause inappropriate mingling of data. As long as no KILLs occur, double allocation may not cause permanent loss of additional data. However, it may cause the application programs to generate errors and/or inappropriate results. When a block is doubly allocated, a KILL may remove data outside its proper scope. See "Maintaining Database Integrity Chapter" for more information on repairing doubly allocated blocks. |
Incompatible with: -KEY, -REGION, -FREEBLOCK
Required with -HINT; compatible with -BLOCK and [NO]CRIT.
Designates the starting point of a -FREEBLOCK search.
Required with: -FREEBLOCK; compatible with -BLOCK and [NO]CRIT.
Compatible only with [NO]CRIT.
Allows FIND to work even if another process is holding a critical section.
Switches to the named Global Directory region.
-REGION without a specified region, or -REGION="*", displays all existing regions in the database.
Displays the block number of the specified block and its logical siblings in hexadecimal format.
Incompatible with: -FREEBLOCK, -HINT, -KEY, -REGION
Switches to the named Global Directory shadow for the region's shared gvstats.
DSE> find -exhaustive -block=180 Directory path Path--blk:off 1:10 2:1E Global paths Path--blk:off 6:51 1A4:249 180
DSE> find -free -hint=180 Next free block is D8F.
This command locates the "closest" free block to block 180.
DSE>find -key="^biggbl(1)"
This command locates the key ^biggbl(1) in the database.
DSE> find -freeblock -hint=232
This commands starts to search for free block after block 232.
DSE> FIND -FREEBLOCK -HINT=232 -NOCRIT
DSE> find -sibling -block=10
Left sibling Current block Right sibling 0x0000000F 0x00000010 0x00000011
The format of the INTEGRIT command is:
I[NTEGRIT] -B[LOCK]=block-number
![]() | Note |
---|---|
Unlike MUPIP INTEG, this command only detects errors internal to a block and cannot detect errors such as indices incorrectly pointing to another block. For information on the utility that checks multiple blocks, refer to the a??INTEG a?? of the General Database Management chapter. |
Examines or updates bitmaps. The format of the MAPS command is:
M[APS] [ -BL[OCK]=block-number -BU[SY] -F[REE] -M[ASTER] -R[ESTORE_ALL] ]
By default, MAPS shows the status of the bitmap for the specified block.
Incompatible with: -RESTORE_ALL
Sets all local bitmaps and the master bitmap to reflect the blocks used in the database file.
![]() | Caution |
---|---|
The -RESTORE_ALL qualifier rebuilds all maps and should be used with a great deal of caution as it can destroy important information. |
DSE> MAPS -BLOCK=20 -FREE
This command flags block 20 as free. A sample DSE DUMP output block 0 is as follows:
Block 0 Size 90 Level -1 TN 10B76A V7 Master Status: Free Space Low order High order Block 0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 20: | :XXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 40: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 60: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 80: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block A0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block C0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block E0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 100: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 120: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 140: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 160: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 180: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 1A0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 1C0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | Block 1E0: | XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX | 'X' == BUSY '.' == FREE ':' == REUSABLE '?' == CORRUPT
DSE> maps -block=20 -busy
This command marks block 20 as busy. A sample DSE DUMP output of block 0 is as follows:
Block 0 Size 90 Level -1 TN 1 V7 Master Status: Free Space Low order High order Block 0: | XXX..... ........ ........ ........ | Block 20: | X....... ........ ........ ........ | Block 40: | ........ ........ ........ ........ | Block 60: | ........ ........ ........ ........ | Block 80: | ........ ........ ........ ........ | Block A0: | ........ ........ ........ ........ | Block C0: | ........ ........ ........ ........ | Block E0: | ........ ........ ........ ........ | Block 100: | ........ ........ ........ ........ | Block 120: | ........ ........ ........ ........ | Block 140: | ........ ........ ........ ........ | Block 160: | ........ ........ ........ ........ | Block 180: | ........ ........ ........ ........ | Block 1A0: | ........ ........ ........ ........ | Block 1C0: | ........ ........ ........ ........ | Block 1E0: | ........ ........ ........ ........ | 'X' == BUSY '.' == FREE ':' == REUSABLE '?' == CORRUPT
The format of the OVERWRITE command is:
OV[ERWRITE] [ -D[ATA]=string -O[FFSET]=offset ]
The format of the RANGE command is:
RA[NGE] [ -F[ROM]=block-number -T[O]=block-number -I[NDEX] -LOS[T] -[NO]C[RIT] -[NO]BU[SY] -S[TAR] -LOW[ER]=key -U[PPER]=key ]
By default, RANGE starts processing at the beginning of the file.
Restricts a search to index blocks.
Restricts a search to blocks not found by a FIND -BLOCK.
Specifies the lower bound for the key range.
Restricts a search to either BUSY or FREE blocks.
DSE> range -lower="^abcdefgh" -upper="^abcdefghi" -from=A -to=CC
DSE> range -lower="^abcdefgh" -upper="^abcdefghi" -from=A -to=CC -noindex
This command searches only data blocks for the specified keys between block 10 and block 204.
DSE> range -lower="^abcdefgh" -upper="^abcdefghi" -from=A -to=CC -index
This command searches only index blocks for the specified keys between block 10 and block 204.
DSE> range -lower="^abcdefgh" -upper="^abcdefghi" -lost
DSE> range -lower="^Fruits(15)" -upper="^Fruits(877)" -from=A -to=F Blocks in the specified key range: Block: 0000000A Level: 0 Block: 0000000B Level: 0 Block: 0000000C Level: 0 Block: 0000000D Level: 0 Block: 0000000E Level: 0 Block: 0000000F Level: 0 Found 6 blocks
This command search for keys between ^Fruits(15) and ^Fruits(877).
Removes one or more records or a save buffer.
The format of the REMOVE command is:
REM[OVE] [ -B[LOCK]=block-number -C[OUNT]=count -O[FFSET]=offset -R[ECORD]=record-number -V[ERSION]=version-number ]
The RESTORE command restores saved versions of blocks.
RES[TORE] [ -B[LOCK]=block-number -F[ROM]=from -R[EGION]=region -V[ERSION]=version-number ]
The version number is specified in decimal.
Specifies the block to restore.
Specifies the block number of the SAVE buffer to restore.
By default, RESTORE uses the target block number as the -FROM block number.
Specifies the region of the saved buffer to restore.
By default, RESTORE uses SAVE buffers from the current region.
Specifies the decimal version number of the block to restore. The version number is required.
The format of the SAVE command is:
SA[VE] [ -B[LOCK]=block-number -C[OMMENT]=string -L[IST] -[NO]C[RIT] ]
SH[IFT] [ -B[ACKWARD]=b_shift -BL[OCK]=block_number -F[ORWARD]=f_shift -O[FFSET]=offset ]
The format of the SPAWN command is:
SP[AWN] [shell-command]
The SPAWN command has no qualifiers.
DSE SPAWN works with an argument. If the argument contains spaces, enclose it with quotes.
![]() | Caution |
---|---|
A WCINIT command issued while normal database operations are in progress can cause catastrophic damage to the database. |
The format of the WCINIT command is:
W[CINIT]