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}

dbreorg -L Library Productline

Restart is automatic. The log file for a database reorganization is in the IFS in /EnvironmentDirectory/DB/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.
L Library The library where you want the NEWIO delivery file placed. Use this option if you have made changes through the Database Definition utility (dbdef) and need to run the split80 program after the dbreorg. For more information, see Doc for Developers: Application Development Workbench Standards.