Kbase 21951: Loading a Progress Format Incremental File into AS/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/04/2002 |
|
SUMMARY:
This applies to Progress/400 9.1C DataServer. When you load a Progress incremental file into a Progress/400 library, this might fail with the client-side error message:
"DBA Commit failed"
EXPLANATION:
There is a new Progress utility for incremental dump in AS/400 format.
Here the instructions are separated into different blocks which are separately committed.
To load an incremental file in Progress format, this should be broken up into five different files, which will correspond to the blocks from a similar incremental file in AS/400 format.
SOLUTION:
The five different files contain the following information:
1. Rename File -- all objects that are renamed in the following order:
tables, fields, indexes and sequences.
2. Delete File -- all objects that are being deleted in the following
order: indexes, fields, table, sequences.
3. Add objects to EXISTING files in the following order: fields and
indexes.
4. Modify ( Updates ) to existing files, fields or indexes.
5. Add new tables and sequences.
If you break up the Progress incremental .df into five files, make sure that each file follows the order for objects, load files 1 through 5, and do a commit after each load.