Skip to content

Utilities Command Reference

Type gde, mupip, lke, or dse

gde gde syntax gde add gde change gde delete gde exit gde locks gde log gde quit gde setgd gde setgd -file=<global_dir_file_name> gde setgd -quit gde show gde template gde verify gde add -name gde change -name gde delete -name gde add -region=<region_name> gde change -region=<region_name> gde delete -region=<region_name> gde template -region=<region_name> gde add -region=<region_name> -collation_sequence=0_to_255 gde change -region=<region_name> -collation_sequence=0_to_255 gde template -region=<region_name> -collation_sequence=0_to_255 gde add -region=<region_name> -dynamic_segment=<segment_name> gde change -region=<region_name> -dynamic_segment=<segment_name> gde template -region=<region_name> -dynamic_segment=<segment_name> gde add -region=<region_name> -key_size=3_to_1019 gde change -region=<region_name> -key_size=3_to_1019 gde template -region=<region_name> -key_size=3_to_1019 gde add -region=<region_name> -record_size=7_to_1048576 gde change -region=<region_name> -record_size=7_to_1048576 gde template -region=<region_name> -record_size=7_to_1048576 gde add -region=<region_name> -[no]n[ull_subscript]=[always|never|existing] gde change -region=<region_name> -[no]n[ull_subscript]=[always|never|existing] gde template -region=<region_name> -[no]n[ull_subscript]=[always|never|existing] gde add -region=<region_name> -[no]stdnullcoll gde change -region=<region_name> -[no]stdnullcoll gde template -region=<region_name> -[no]stdnullcoll gde add -region=<region_name> -[no]inst[_freeze_on_error] gde change -region=<region_name> -[no]inst[_freeze_on_error] gde template -region=<region_name> -[no]inst[_freeze_on_error] gde add -region=<region_name> -[no]q[dbrundown] gde change -region=<region_name> -[no]q[dbrundown] gde template -region=<region_name> -[no]q[dbrundown] gde add -region=<region_name> -[no]j[ournal][=journal-option-list] gde change -region=<region_name> -[no]j[ournal][=journal-option-list] gde template -region=<region_name> -[no]j[ournal][=journal-option-list] gde add -segment <segment_name> -file=<file_name> gde change -segment <segment_name> -file=<file_name> gde delete -segment <segment_name> gde template -segment <segment_name> -file=<file_name> gde add -segment <segment_name> -access_method=BG|MM gde change -segment <segment_name> -access_method=BG|MM gde template -segment <segment_name> -access_method=BG|MM gde add -segment <segment_name> -allocation=10_to_1040187392 gde change -segment <segment_name> -allocation=10_to_1040187392 gde template -segment <segment_name> -allocation=10_to_1040187392 gde add -segment <segment_name> -block_size=512_to_65024 gde change -segment <segment_name> -block_size=512_to_65024 gde template -segment <segment_name> -block_size=512_to_65024 gde add -segment <segment_name> -[no]encryption gde change -segment <segment_name> -[no]encryption gde template -segment <segment_name> -[no]encryption gde add -segment <segment_name> -extention_count=0_to_65535 gde change -segment <segment_name> -extention_count=0_to_65535 gde template -segment <segment_name> -extention_count=0_to_65535 gde add -segment <segment_name> -global_buffer_count=64_to_2147483647 gde change -segment <segment_name> -global_buffer_count=64_to_2147483647 gde template -segment <segment_name> -global_buffer_count=64_to_2147483647 gde add -segment <segment_name> -lock_space=10_to_65536 gde change -segment <segment_name> -lock_space=10_to_65536 gde template -segment <segment_name> -lock_space=10_to_65536 gde add -segment <segment_name> -reserved_bytes=0_to_block_size-block_header-record_size gde change -segment <segment_name> -reserved_bytes=0_to_block_size-block_header-record_size gde template -segment <segment_name> -reserved_bytes=0_to_block_size-block_header-record_size gde summary lke lke syntax lke clear lke clear -all lke clear -lock lke clear -[no]crit lke clear -[no]exact lke clear -[no]interactive lke clear -output=“file-name” lke clear -pid=<process_id> lke clear -region= lke show lke show -all lke show -lock lke show -[no]crit lke show -output=“file-name” lke show -pid=<process_id> lke show -region= lke show -wait lke exit lke spawn lke summary mupip mupip syntax mupip backup mupip backup -bkupdbjnl=disable|off mupip backup -bytestream mupip backup -comprehensive mupip backup -database mupip backup -increment mupip backup -nettimeout mupip backup -[no]newjnlfiles[=[no]prevlink],[no]s[ync_io]] mupip backup -online mupip backup -replinstance=<target_location> mupip backup -since=[database|bytestream|record] mupip backup -replace mupip backup -transaction=<hexa_transaction_number> mupip backup examples mupip create -region=<region_name> mupip endiancvt -outdb= -override mupip rctldump [dir1] mupip endiancvt examples mupip exit mupip extend -blocks= mupip extract mupip extract -format=binary|go|zwr mupip extract -freeze mupip extract -label= mupip extract -[no]log mupip extract -select= mupip extract examples mupip freeze mupip freeze -off mupip freeze -on mupip freeze -override mupip freeze -record mupip ftok mupip ftok -jnlpool mupip ftok -recvpool mupip ftok -db mupip integ mupip integ -adjacency= mupip integ -block=<block_number> mupip integ -brief mupip integ -fast mupip integ -file mupip integ -full mupip integ -[no]keyranges mupip integ -[no]map= mupip integ -[no]maxkeysize= mupip integ -online mupip integ -region mupip integ -subscript= mupip integ -tnreset mupip integ -[no]transaction= mupip integ examples mupip intrpt mupip load mupip load -format=go|binary|zwr mupip load -begin= mupip load -end= mupip load -fillfactor= mupip load -stdin mupip load -onerror mupip load examples mupip reorg mupip reorg -exclude= mupip reorg -fill_factor mupip reorg -index_fill_factor mupip reorg -resume mupip reorg -region mupip reorg -select= mupip reorg -truncate[=] mupip reorg examples mupip restore mupip restore -[no]extend mupip restore examples mupip rundown mupip rundown -region mupip rundown -file mupip rundown -override mupip rundown -relinkctl mupip set mupip trigger -triggerfile -[no]prompt mupip trigger -select][=name-list*][] mupip trigger -upgrade mupip set -access_method=bg|mm mupip set -partial_recov_bypass mupip set -region mupip set -file mupip set -extension_count= mupip set -flush_time=[[[hours:]minutes:]seconds:]centiseconds mupip set -global_buffers=64_to_2147483647 mupip set -lock_space=10_to_65536 mupip set -inst_freeze_on_error mupip set -[no]journal= mupip set -[no]qdbrundown mupip set -reserved_bytes=0_to_block_size-block_header-record_size mupip set -version=V4|V6 mupip downgrade -version=V4|V5 mupip journal <Action_Qualifiers> mupip journal -extract=<file_name>|stdout mupip journal -recover mupip journal -rollback -[no]online mupip journal -show=<all,active_processes,broken_transactions,header,processes,statistics> mupip journal -[no]verify mupip journal -[no]verify <Direction_Qualifiers> mupip journal <Action_Qualifiers> <Direction_Qualifiers> mupip journal -extract=<file_name>|stdout <Direction_Qualifiers> mupip journal -extract=<file_name>|stdout [-detail] <Direction_Qualifiers> mupip journal -recover <Direction_Qualifiers> mupip journal -rollback -[no]online <Direction_Qualifiers> mupip journal -show=<all,active_processes,broken_transactions,header,processes,statistics> <Direction_Qualifiers> mupip journal -[no]verify -after= mupip journal -[no]verify -before= mupip journal <Action_Qualifiers> <Direction_Qualifiers> [Time_Qualifiers] mupip journal -extract=<file_name>|stdout [-detail] <Direction_Qualifiers> -after= mupip journal -extract=<file_name>|stdout [-detail] <Direction_Qualifiers> -before= mupip journal -recover -forward -after= mupip journal -recover <Direction_Qualifiers> -before= mupip journal -rollback -[no]online <Direction_Qualifiers> mupip journal -rollback -[no]online -forward -after= mupip journal -show=<all,active_processes,broken_transactions,header,processes,statistics,[no]verify> <Direction_Qualifiers> mupip journal -rollback -[no]online <Direction_Qualifiers> <Journal_Sequence_Number> mupip journal -rollback -[no]online <Direction_Qualifiers> -fetchresync=<port_no> -losttrans=<extract_file> <file_list> mupip journal -rollback -[no]online <Direction_Qualifiers> -resync=<journal_sequence_number> mupip journal -rollback -[no]online <Direction_Qualifiers> <Journal_Sequence_Number> mupip journal -rollback -[no]online <Direction_Qualifiers> <Journal_Control> mupip journal -extract=<file_name>|stdout [-detail] -brokentrans=<extract_file> mupip journal -rollback -[no]online <Direction_Qualifiers> -brokentrans=<extract_file> mupip journal -recover <Direction_Qualifiers> -brokentrans=<extract_file> mupip journal -recover <Direction_Qualifiers> -losttrans=<extract_file> mupip journal -recover -forward -[no]chain mupip journal -recover -forward -[no]checktn mupip journal -[no]error_limit= mupip journal -recover -fences=none|always|process mupip journal -extract=<file_name>|stdout -full mupip journal -[no]error_limit= -[no]interactive mupip journal -recover -forward -redirect=<old-file-name=new-file-name> mupip journal -verbose mupip set -replication=on|off|was_on mupip replicate -instance_create mupip replicate -instance_create -name=<instance_name> mupip replicate -instance_create -name=<instance_name> -noreplace mupip replicate -instance_create -name=<instance_name> -noreplace -supplementary mupip replicate -editinstance <instance_file> -show -detail mupip replicate -editinstance <instance_file> mupip replicate -editinstance <instance_file> -change -offset= -size= -value= -name=<new_name> mupip replicate -editinstance <instance_file> -change -offset= -size= -value= -name=<new_name> mupip replicate -source -jnlpool -show -detail mupip replicate -source -showbacklog mupip replicate -source -start -secondary=hostname:port mupip replicate -source -start -passive mupip replicate -source -start -buffsize= mupip replicate -source -start -filter= mupip replicate -source -start -freeze=on|off -[no]comment="""" mupip replicate -source -start -connectparams=,,, , , mupip replicate -source -start -instsecondary= mupip replicate -source -start -log= -log_interval= mupip replicate -source -start -rootprimary mupip replicate -source -start -propagateprimary mupip replicate -source -start -tlsid mupip replicate -source -start -tlsid -renegotiate_interval mupip replicate -source -start -tlsid -renegotiate_interval -plaintextfallback mupip replicate -source -start -tlsid -renegotiate_interval -noplaintextfallback mupip replicate -source -start -updok mupip replicate -source -start -updnotok mupip replicate -source -start -cmplvl= mupip replicate -source -shutdown -timeout= mupip replicate -source -activate -secondary=hostname:port -instsecondary=<instance_name> mupip replicate -source -activate -secondary=hostname:port -connectparams=,,,,, mupip replicate -source -activate -secondary=hostname:port -instsecondary=<instance_name> -rootprimary mupip replicate -source -activate -secondary=hostname:port -instsecondary=<instance_name> -propagateprimary mupip replicate -source -deactivate -instsecondary=<instance_name> mupip replicate -source -deactivate -propagateprimary mupip replicate -source -stopsourcefilter mupip replicate -source -checkhealth mupip replicate -source -losttncomplete mupip replicate -source -needrestart mupip replicate -source -checkhealth -instsecondary=<instance_instance> -helpers mupip replicate -source -start -changelog -log= mupip replicate -source -activate -changelog -log= mupip replicate -source -changelog -log= -log_interval= -instsecondary=<instance_name> mupip replicate -source -statslog=ON|OFF -log_interval= mupip replicate -source -shutdown -instsecondary=<instance_name> -timeout= mupip replicate -receiver -start -listenport= -log= -log_interval="[integer1],[integer2]" mupip replicate -receiver -start -listenport= -log= -log_interval="[integer1],[integer2]" mupip replicate -receiver -start -listenport= -log= -autorollback=verbose mupip replicate -receiver -start -listenport= -log= -buffsize= mupip replicate -receiver -start -listenport= -log= -filter= mupip replicate -receiver -start -listenport= -log= -noresync mupip replicate -receiver -start -listenport= -log= -stopsourcefilter mupip replicate -receiver -start -listenport= -log= -updateresync= -resume=<strm_num> mupip replicate -receiver -start -listenport= -log= -updateresync= -reuse= mupip replicate -receiver -start -listenport= -log= -updateresync= -initialize mupip replicate -receiver -start -listenport= -log= -cmplvl=n mupip replicate -receiver -start -tlsid mupip replicate -receiver -start -tlsid -renegotiate_interval mupip replicate -receiver -start -tlsid -renegotiate_interval -plaintextfallback mupip replicate -receiver -start -tlsid -renegotiate_interval -noplaintextfallback mupip replicate -receiver -start -updateonly -helpers=m,n mupip replicate -receiver -shutdown -updateonly -timeout= mupip replicate -receiver -shutdown -helpers -timeout= mupip replicate -receiver -checkhealth mupip replicate -receiver -changelog -log= mupip replicate -receiver -changelog -log= -log_interval=“integer1,integer2” mupip replicate -receiver -statslog=ON|OFF mupip replicate -receiver -statslog=ON|OFF -log_interval=“integer1,integer2” mupip replicate -receiver -showbacklog dse dse syntax dse add dse add -block=block -offset= -key= -pointer= dse add -block=block -RECORD=record -key= -pointer= dse add -block=block -RECORD=record -star -pointer= dse add -block=block -RECORD=record -key= -data= dse all -buffer_flush dse all -critinit dse all -[no]freeze dse all -override dse all -reference dse all -release dse all -renew dse all -seize dse all -wcinit dse buffer_flush dse change -block=<block_num> dse change -block=<block_num> -bsiz=<block-size dse change -block=<block_num> -level=level dse change -block=<block_num> -tn=transaction-number dse change -block=<block_num> -offset=offset dse change -block=<block_num> -record=record-number dse change -block=<block_num> -cmpc=compression-count dse change -block=<block_num> -rsiz=record-size dse change -fileheader dse change -fileheader -avg_blks_read= dse change -fileheader -b_bytestream= dse change -fileheader -b_comprehensive= dse change -fileheader -b_database= dse change -fileheader -b_incremental= dse change -fileheader -b_record= dse change -fileheader -blk_size= dse change -fileheader -blocks_free= dse change -fileheader -current_tn= dse change -fileheader -commitwait_spin_count= dse change -fileheader -declocation= dse change -fileheader -def_collation= dse change -fileheader -encryption_hash dse change -fileheader -flush_time= dse change -fileheader -freeze= dse change -fileheader -fully_upgraded= dse change -fileheader -gvstatsreset dse change -fileheader -hard_spin_cpunt=mutex-hard-spin-sount> dse change -fileheader -hexlocation= dse change -fileheader -interrupted_recov= dse change -fileheader -jnl_yield_limit= dse change -fileheader -key_max_size= dse change -fileheader -machine_nam= dse change -fileheader -null_subscripts= dse change -fileheader -nocrit dse change -fileheader -override dse change -fileheader -qdbrundown dse change -fileheader -rc_srv_count dse change -fileheader -re_read_trigger= dse change -fileheader -record_max_size= dse change -fileheader -reference_count= dse change -fileheader -reg_seqno= dse change -fileheader -reserved_bytes= dse change -fileheader -sleep_spin_count= dse change -fileheader -spin_sleep_time= dse change -fileheader -timers_pending= dse change -fileheader -total_blks= dse change -fileheader -trigger_flush= dse change -fileheader -upd_reserved_area= dse change -fileheader -upd_writer_trigger_factor= dse change -fileheader -writes_per_flush= dse change -fileheader -wait_disk= dse change -fileheader -zqgblmod_seqno= dse change -fileheader -zqgblmod_trans= dse cache -recover -all dse cache -verify -all dse close dse critical -init -reset dse critical -owner dse critical -release dse critical -remove dse critical -sieze dse dump -all dse dump -block=<block_num> dse dump -count= dse dump -fileheader dse dump -glo dse dump -gvstats dse dump -[no]crit dse dump -[no]header dse dump -offset=offset dse dump -record=<record_number> dse dump -updproc dse dump -zwr dse evaluate -decimal -number= dse evaluate -hexadecimal -number= dse exit dse find -exhaustive -siblings dse find -block -freeblock -hint dse find -[no]crit -key= dse find -block -siblings dse find -region=<region_name> dse integrit -block=<block_num> dse integrit -block=<block_num> -[no]crit dse maps -block=<block_num> -busy dse maps -block=<block_num> -free dse maps -block=<block_num> -master dse maps -restore_all dse open -file=<output_file_name> dse overwrite -data= -offset= dse page dse range -from=<block_num> -to=<block_num> dse range -lower= -upper= -from=<block_num> -to=<block_num> dse range -lower= -upper= -index -star dse range -lost -lower= -upper= -star dse range -[no]crit dse range -[no]busy dse remove -block=<block_num> -count= dse remove -block=<block_num> -version=<version_num> dse remove -block=<block_num> -record=<record_num> dse remove -block=<block_num> -offset= -count= dse restore -block=<block_num> -version= dse restore -block=<block_num> -from=<block_num> dse restore -block=<block_num> -from=<block_num> -region=<region_name> dse save -block=<block_num> -comment= dse save -block=<block_num> -comment= -list dse save -block=<block_num> -comment= -[no]crit dse shift -backward=bytes_to_shift -offset= dse shift -forward=bytes_to_shift -offset= dse spawn dse wcinit