Compact

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 argument is optional in multiuser mode.

The optional workers argument 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 argument. 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 argument 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 argument is not specified, the value defaults to false.

The files argument can be used to specify a file list or the file argument 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 argument, 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.