Dump/Load
Database Dump Methods
- MFG/PRO Dump/Load program
- PROGRESS Data Dictionary Dump/Load
- Progress Binary Dump (Individual Table)
- MFG/UTIL (eB and beyond)
Database Load Methods
- MFG/PRO Dump/Load program
- PROGRESS Data Dictionary Dump/Load
- PROGRESS Bulk Load utility (proutil)
- Progress Binary Load (Individual Table)
- MFG/UTIL Data Load
MFG/PRO Dump/Load
- Ensure you are the only user logged into MFG/PRO.
- Back up the old database.
- Run MFG/PRO Dump/Load.
- Reload data into the desired database. – Usually a copy of mfgempty.
You should perform dump/loads in Host mode for UNIX, and in batch mode on the character admin client in NT.
Load Procedure Notes
- Loading into database with existing data is not recommended.
- If reloading onto a database with data in it, .d records will not overwrite existing records for files with unique indexes.
- Duplicate records can occur in files with no unique indexes.
- Errors in loading a file are recorded in .e files.
- PROGRESS bulk load is faster, but requires an index rebuild.
MFG/PRO Load Procedures
- Place .d files in load directory.
- Run Database File Dump/Load w/ Batch choosing LOAD.
- Check dumpload.e, dumpload.log.
There is no performance advantage to performing a multi-stream load.
Dumping and Loading Data in MFG/PRO
Dumping Through MFG/PRO
Overview: In this activity, you will be dumping a single table, prd_det, using the dump/load program in MFG/PRO.
Prerequisites:
- If you have not done so, you must build the dump/load procedures for the Windows client PC. (Dump/load procedures are delivered pre-built with the server media, but they are only used for dumping through a noninteractive batch process.) To create the dump/load procedures, run utmkdl from any MFG/PRO menu. This step takes several minutes.
- View the output to be deleted.
- Select Printer Setup Maintenance (36.13.2).
- Press the look-up button attached to the Output To field.
Note the various printer definitions.
- Select Database File Dump/Load w/Batch (36.21.4 / 36.16.4), and enter the following
|
Field |
Enter |
|---|---|
|
Database Name |
Defaults to physical name of primary database. |
|
Dumpfile Directory |
. (YourWorkingDir)* |
|
Dump/Load |
Dump |
|
File Name |
prd_det |
|
To |
prd_det |
|
Allow Errors, Log file |
These fields are display only. |
* This program attempts to append a forward slash (/) to the end of the directory entered here. This is a problem on Windows where a backslash is expected (\). Using your working directory for this class will get around this issue. Press OK at the Continue with Dump/Load prompt, and enter the following
- Press OK at the Continue with Dump/Load prompt, and enter the following
|
Field |
Enter |
|---|---|
|
Output |
Window |
|
Batch ID |
Leave this field blank |
- Choose Go when ready.
Note The report displays the number of records dumped and dump data file name. To view this file, exit to the operating system and check your working directory.
Preparing the Training Database for Load
Overview: For purposes of this training only, follow these steps to delete the standard printer records from your training database.
Warning Do not perform these steps under normal circumstances. They are only applicable to this training activity.
- If not start started already, open the PROGRESS Procedure Editor against your training database. To do so, start an MFG/PRO session, select the User Menu, and choose PROGRESS Editor.
- In the Procedure Editor, type the following program to delete the printer records. for each prd_det: delete prd_det.
- Press Go to run the program.
- When the program completes, exit the Procedure Editor and return to MFG/PRO.
- Verify the printer record deletes.
- Select Printer Setup Maintenance (36.13.2)
- Press the look-up button attached to the Output To field.
Note that all the printer records are no longer present.
Loading Through MFG/PRO
Overview: In this activity you will load the prd_det table using the dump/load program in MFG/PRO.
Prerequisites:
- Your dump directory must be created and contain prd_det.d
- Select Database File Dump/Load w/Batch (36.21.4 / 36.16.4), and enter the following:
|
Field |
Enter |
|---|---|
|
Database Name |
Defaults to physical name of primary database. |
|
Dumpfile Directory |
. (YourWorkingDir) |
|
Dump/Load |
Load |
|
File Name |
prd_det |
|
To |
prd_det |
|
Allow Errors |
Yes |
|
Log File |
This field is display only. |
- Press OK at the Continue with Dump/Load prompt, and enter the following:
|
Field |
Enter |
|---|---|
|
Output |
dlout |
|
Batch ID |
Leave this field blank |
- Choose Go when ready.
- Press the Spacebar to acknowledge the warning that occurs.
A file named dlout is created. This file contains any load output.
- Verify the printer records load.
- Select Printer Setup Maintenance (36.13.2)
- Press the look-up button attached to the Output To field.
Notice that the printer records are again available.