To manually reorganize a database, use the following command line argument:
DBReorgEXE.exe <alias> <dbName> <owner> <retainMode> <execMode> <folder>
Where,
alias is the name of the Database Server Registration for the system database, as created by the database administrator using the Administration Tool (for example, default).
dbName is the name of the database to be reorganized.
owner is the schema owner's user name.
retainMode is whether the existing database is to be retained for the operation (YES or NO).
execmode is the function you want to perform on the database:
CHECK – performs a consistency check on the database.
PLAN – builds and prints the reorganization plan. The reorganization plan is a collection of actions that reorganize the database.
REORG – completes the reorganization of the database.
DROP – removes the database tables.
UMTCHECK – runs a user maintained consistency check on the database
folder is the directory where system files such as DatabaseSchema.xml are located.
Once a database is reorganized, one of the following values is displayed:
0 – reorganization has started, and has successfully completed.
1 – reorganization has started, and is unsuccessful.
2 – reorganization has failed to start.
Note: Stop the system before attempting to manually reorganize a database.