QAD 2017 Enterprise Edition
>
User Guides
>
System Administration
>
Database Management
>
Dumping and Loading Data
Dumping and Loading Data
Dump/load programs move the contents of database tables into or out of ASCII files. The dump procedure reads a database table, puts quotation marks around the data value of each field, and places those values in an ASCII file.
Example: A record in the user master table (usr_mstr) consists of the following entries:
|
usr_lang
|
FR
|
|
usr_site
|
1000
|
|
usr_user1
|
|
|
usr_user2
|
|
|
usr_user
|
pxr
|
One line in the dump file would read:
“FR” “1000” “”“”“pxr”
You can use dump files as input to other programs after converting the files to CIM input-file format. You can also take output from other programs, convert it to CIM input-file format, and load it into the database. This assumes the data has the correct form, based on the screen flow and format the CIM input is duplicating. The
Database Definitions book contains details on specific table formats. See
Using the CIM Interface for details.
Dump/load procedures are located at 36.16.4 for Windows clients and at 36.16.3 for UNIX environments. Load procedures do not overwrite existing records. You must delete the old data first.
Note: Progress and Oracle each provide dump/load and import/export programs, but these programs do not maintain the integrity of data in the QAD database. See the Progress user manuals.
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 your QAD 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 QAD 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.