Try OpenEdge Now
skip to main content
User Guide
Reference : Utilities and OpenEdge Replication
 

Utilities and OpenEdge Replication

Many of the OpenEdge database utilities are used to change a database. The table that follows lists the utilities and indicates whether they are allowed to operate on a source or target database.
Table 34. Utility support for OpenEdge Replication
Utility
Qualifier
Source database
Target database
DBTOOL
Yes
No
PROBKUP
Online
Yes
Yes
Incremental
Yes
Yes
Normal
Yes
Yes
PROCOPY
Yes
Yes
PRODB
Yes
Yes
PRODEL
Yes
Yes
PROLOG
Yes
Yes
PROMON
Yes
Yes
PROREST
No
No
PROSTRCT
Add
Yes
Yes
Addonline
Yes
Yes
Builddb
Yes
Yes
Cluster Clear
Yes
Yes
Create
NA
NA
List
Yes
Yes
Remove
Yes
No
Repair
Yes
Yes
Statistics
Yes
Yes
Unlock
No
No
PROUTIL                                                  
2phase begin 
No
No
 2phase commit 
No
No
2phase end 
No
No
2phase modify
No
No
 2phase recover
No
No
auditarchive
Yes
No
auditload
Yes
No
auditreconfig
Yes
No
bigrow
Yes
No
busy
Yes
Yes
bulkload
No
No
chanalys
Yes
Yes
codepage-compiler
Yes
Yes
conv1011
NA
NA
convchar
Yes
No
convfile
No
No
dbanalys online
Yes
Yes
dbanalys offline
Yes
Yes
datamove
Yes
No
dbauthkey
No
No
dbipcs
Yes
Yes
dbrestrict
Yes
No
describe
Yes
Yes
deallocate
Yes
No
disableauditing
No
No
disableB2
Yes
No
disableencryption
Yes
No
disableJTA
Yes
No
disablekeyevents
Yes
No
disablemtidxbld
Yes
No
disablemultitenancy
Yes
No
disablenewvsttables
Yes
No
disablereadonlypartitions
Yes
No
disabletablepartitioning
Yes
No
disabletpidxbld
Yes
No
disptosscreatelimits
Yes
Yes
dump
Yes
Yes
dumpspecified online
Yes
Yes
dumpspecified offline
Yes
Yes
enableauditing
No
No
enableB2
Yes
No
enableencryption
Yes
No
enableJTA
Yes
No
enablekeyevents
Yes
No
enablelargefiles
Yes
Yes
enablelargekeys
Yes
No
enablemtidxbld
Yes
No
enablemultitenancy
Yes
No (enabled automatically on an online source or as part of a restored backup)
enablenewvsttables
Yes
No
enablereadonlypartitions
Yes
No
enableseq64
Yes
No
enablesitereplication
Yes
Yes
enablestoredproc
No
No
enabletablepartitioning
Yes
No
enabletpidxbld
Yes
No
epolicy
Yes
Yes
disablesitereplication
Yes
holder
Yes
Yes
idxactivate
Yes
No
idxanalys online
Yes
Yes
idxanalys offline
Yes
Yes
idxbuild
No
No
idxcheck
Yes
Yes
idxcompact online
Yes
No
idxcompact offline
No
No
idxdeactivate
Yes
No
idxfix online
Yes
No
idxfix offline
No
No
idxmove online
Yes
No
idxmove offline
No
No
increaseto
Yes
No
iostats online
Yes
Yes
iostats offline
Yes
Yes
load
No
No
mtidxbuild
Yes
No
mvsch
No
No
partitionmanage alter
Yes
No
partitionmanage merge
Yes
No
partitionmanage rename
Yes
No
partitionmanage split
Yes
No
partitionmanage truncate
Yes
No
partitionmanage view
Yes
Yes
rcodekey
No
No
set[area|lob|table]createlimit
Yes
No
set[area|lob|table]tosslimit
Yes
No
tabanalys online
Yes
Yes
tabanalys offline
Yes
Yes
tablemove online
Yes
No
tablemove offline
No
No
tpidxbuild          
Yes
No
truncate area
No
No
truncate bi 
Yes
No
updateschema
No
No
updatevst
No
No
viewB2
Yes
No
wordbreak-compiler 
NA
No
word-rules
No
No
RFUTIL
aimage begin 
Yes
Yes
aimage end
No
Yes
aimage extent empty
Yes
Yes
aimage extent full
Yes
Yes
aimage extent list
Yes
Yes
 aimage extract 
aimage new
Yes
Yes
aimage aioff
No
Yes
 aimage query
Yes
Yes
aimage scan
Yes
Yes
 aimage truncate
No
No
aiarchiver disable
Yes
No
aiarchiver enable
Yes
No
aiarchiver end
Yes
No
aiarchiver setdir
Yes
No
aiarchiver setinterval
Yes
No
aiarchive extent
Yes
No
aiverify full
Yes
No
aiverify partial
Yes
No
mark backup 
Yes
Yes
 roll forward
No
No
roll forward oplock
No
No
roll forward retry
No
No
roll opunlock 
No
No
sequence
No
No
SQLDUMP
Yes
Yes
SQLLOAD
Yes
No
SQLSCHEMA
Yes
Yes