The Compact action executes a compaction routine on all or selected database files.
When a partitioned file is compacted, all file partitions are compacted. You cannot execute this operation for a specific partition.
The syntax of the Compact action is as follows.
jdbadmin action=Compact
[path=database-path]
[ini=initialization-file-name]
[server=multiUser|singleUser]
[workers=number-of-workers [updatesAllowed=true|false]]
[files=file-name1,file-name2,…|file=file-name]
The path parameter is optional in multiuser mode.
The optional workers parameter enables you to specify the number of multiple concurrent worker threads (greater than 1) that are used in parallel when using the compact action. If you do not specify the number of workers or you specify a number less than two workers, serial compact actions are performed. The default value of 2 workers is used if you do not specify the workers parameter. If you specify a value greater than 16, the maximum number of 16 worker threads is used.
When you specify that multiple worker threads can compact the database in parallel, specify the optional updatesAllowed parameter with a value of true if you want to allow updates when multiple workers are in action during a database file compaction. If the updatesAllowed parameter is not specified, the value defaults to false.
The files parameter can be used to specify a file list or the file parameter can be used to identify a specific file. If a file selection is not specified, all database files are compacted. If you do not specify the file or files parameter, a list of files that will not be processed for non-error reasons is output to the console (that is, to stdout).
For details, see "Compacting Files", in Chapter 3.