dbreorg - Reorganize Database

Caution:

Before using the dbreorg utility, see the Data Access guide for your database for a complete description of the dictionary file reorganization process.

dbreorg [-SCFYdin] [-W WFFile] {{-p dataarea} | Productline}

dbreorg [-G [GCFile]] [-W WFFile] {{-p dataarea} | Productline}

dbreorg [-lcs] {{-p dataarea} | Productline}

dbreorg [-x] {{-p dataarea} | Productline}

Restart is automatic. The log file for a database reorganization is $LADBDIR/PRODUCTLINE/reorg.hist.


Program Option	Description
`C`	Conservative mode. This is the traditional dump and load operation. Using the `-C` option, dbreorg first saves the table's data in a dump file before altering the table. It is a safe mode because dbreorg can recover data using the dump file backup. This is the most time-consuming way of performing a dbreorg and ensures that no data is corrupted. It is called conservative because it requires the extra step of saving the data of the table in a dump file before altering the table in the database.
`F`	Fast mode. This mode bypasses the step of saving the table's data in a dump file. Note: Back up your data before running dbreorg with this option.
`S`	Safe mode (the default). In this mode, dbreorg first saves the table's data in a dump file and then alters the table directly in the database. If a table(s) alteration fails, dbreorg goes into Conservative mode for the failed table and reloads from the dump file.
`Y`	Yes. Do not prompt to continue in Fast mode (requires `-F`)
`d`	No physical database exists.
`i`	Rebuild data ID dictionary for shared data areas.
`n`	Do not run srgen.
`G GCFile`	Garbage collection; reorganize files specified in the garbage collection file. The garbage collection file is a list of files to be reorganized. File names specified in the garbage collection file are separated by a <cr> (carriage return character) or spaces, tabs, or commas. When `-G` is specified without a garbage collection file, all files are marked for garbage collection.
`W WFFile`	Could specify a number of work files. You must have a file to specify the work file names. Optional. Work file to hold the database file. A work file can be a tape device. If you do not supply a name, the default is $LAWDIR/`productline`/reorg.rwrk. - or - $LAWDIR/reorg.rwrk The reorganization process dumps the database file to a work file. It splits a single database file among multiple work files if a work file grows too large for the partition it is in. If the file gets full, the system prompts you for the next work file.
`c`	Compare dictionaries showing files changed.
`l`	List files to be reorganized.
`s`	List number of records in the files (requires `-l`).
`p dataarea`	Reorganize the specified data area. If you do not use the `-p` option, specify a product line to run the reorg for.
`x`	Print out the detail from the dbreorg.cntrl file.