DBSU DATAUNLOAD/DATALOAD, DBSU UNLOAD/RELOAD, and Data Restore UNLOAD/RELOAD are pairs of functions that are in themselves compatible. You cannot use the output of one pair as input for another.
The Data Restore SELECT function is compatible with the DBSU DATALOAD function. You can SELECT data via Data Restore and load the data with the DBSU DATALOAD. The Control Center SQLTABLE function is compatible with, and makes use of, the DBSU DATAUNLOAD function.
The Control Center SQLREORG function is compatible with, and makes use of, the DBSU UNLOAD and RELOAD functions.
The Data Restore UNLOAD and RELOAD functions are incompatible with the DBSU UNLOAD and RELOAD functions, as described in Data Restore UNLOAD and RELOAD.
Table 6 gives you an overview of the compatibilities among the
methods to unload or reload data on a DB2 database.
Table 6. Compatibilities Data Unload and Load
|
| ... can be Input to: | ||||
| Output from ... | DBSU DATALOAD | DBSU RELOAD | Data Restore DESCRIBE | Data Restore RELOAD | Control Center SQLREORG |
| DBSU DATAUNLOAD | X | - | - | - | - |
| DBSU UNLOAD | - | X | - | - | X |
| Data Restore UNLOAD | - | - | X | X | - |
| Data Restore SELECT | X | - | - | - | - |
| Control Center SQLTABLE | X | - | - | - | - |
| Control Center SQLREORG | - | X | - | - | X |
| DB2 archive | - | - | - | X | - |
| Translated DB2 archive | - | - | X | X | - |
| Data Restore BACKUP | - | - | X | X | - |
Table 7 gives you an overview of the methods and their possibilities offered to unload or reload data on a DB2 database.
Reorganization can be achieved also with other means; we indicate here just the main purpose.
For "Data Restore RELOAD from TRANSLATE" (translated DB2 archive), see column "RELOAD from BACKUP".
Table 7. Possibilities Data Unload and Load
|
| DBSU | Data Restore | Control Center | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Function | DATAUNLOAD | DATALOAD | UNLOAD | RELOAD | SELECT | UNLOAD | RELOAD from BACKUP | RELOAD from DB2 Archive | RELOAD from UNLOAD | SQLTABLE | SQLREORG |
| Unit | |||||||||||
| row | X | X | - | - | X | - | - | - | - | X | - |
| table | - | - | X | X | - | - | X | X | X | X | X |
| dbspace | - | - | X | X | - | X | - | - | - | - | X |
| DML Data Manipulation Language | |||||||||||
| user defined | X | X | - | - | - | - | - | - | - | X | - |
| DDL Data Definition Language | |||||||||||
| user defined columns | X | X | - | - | - | - | - | - | - | X | - |
| user defined table | - | - | - | X | - | - | X | X | X | - | - |
| user defined dbspace | - | - | - | X | - | - | X | X | X | - | X |
| Reorganization | |||||||||||
| free empty pages | - | - | - | - | - | - | - | - | - | - | X |
| to other dbspace | - | X | - | X | - | - | X | X | X | - | X |
| user defined (order by) | X | - | - | - | - | - | - | - | - | - | - |
| system defined (clustering index) | - | - | X | - | - | - | - | - | - | X | X |
| Export / Import data | |||||||||||
| DB2 | X | X | X | X | X | X | X | X | X | X | X |
| non- DB2 | X | X | - | - | - | - | - | - | - | X | - |
| Database status | |||||||||||
| online | X | X | X | X | X | X | X | X | X | X | X |
| offline | - | - | - | - | X | X | - | - | - | - | - |
| Recover log | |||||||||||
| apply all | - | - | - | - | - | - | X | X | - | - | - |
| to point in time | - | - | - | - | - | - | X | X | - | - | - |