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 1. 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
	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
	conv1112	NA	NA
	conv1112 replsource	Yes	No
	conv1112 repltarget	No	Yes
	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
	disablemultitenancy	Yes	No
	disablereadonlypartitions	Yes	No
	disabletablepartitioning	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
	enablelargekeys	Yes	No
	enablemultitenancy	Yes	No (enabled automatically on an online source or as part of a restored backup)
	enablereadonlypartitions	Yes	No
	enablesitereplication	Yes	Yes
	enablestoredproc	No	No
	enabletablepartitioning	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	Yes, only if run online to truncate data storage area. Change replicates to target.	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