Dump/Load Procedures
To dump/load data:
1 Back up the existing database.
2 Check available disk space. A full dump/load requires free space equaling approximately 70% of existing database size. See
Determining Disk Usage.
3 Log in to the system in single-user mode. You can speed up the dump/load by running multiple sessions of Database Table Dump/Load from multiple terminals.
4 Execute Database Table Dump/Load for the correct range of tables.
If there is enough free space, select all tables. If there is not, archive the dumped files to a tape, then erase them from the database. Repeat this step as needed.
5 When the dump is finished, copy the standard, empty database (mfg) onto your old database.
6 Load the dumped files back into the database using Database Table Dump/Load.
Data files (.d files) reloaded into databases containing data do not overwrite existing records. Files to be loaded must be in a directory specified in your PROPATH. A Progress bulk load is usually faster than a dump/load, but can require an index rebuild.
The system lists load errors in a .e file located in the directory you ran the process from.