In today's data processing environment, running global business operations in a 24 hours-a-day, 7 days-a-week mode is a key goal of many data centers. Data Restore helps data centers approach this goal by minimizing the time the database needs to be down.
It is for users who need the maximum database availability that the UNLOAD function is most useful. With the UNLOAD function, you can do a partial backup by unloading while the server is online or offline. If a physical error occurs, you can reload tables from the UNLOAD file after redefining the database. With the UNLOAD function, you can back up dbspaces containing critical tables more frequently than the rest of your database. If you have defined one table per dbspace, you effectively have table-level backup.
If a logical error occurs, you can reload all dbspaces in error from the unloaded tape or DASD.
| Note: | Forward log recovery is not available when restoring from unloaded dbspaces. |
The primary purposes of the UNLOAD function is to allow you to:
| Note: | Data Restore executes a physical unload of all pages containing data for the specified dbspaces. For that reason, the UNLOAD command and the RELOAD command of this feature and the UNLOAD command and the RELOAD command of the IBM DATABASE 2 Server for VSE & VM Services Utility (DBSU) are not compatible, so one cannot use the output of the other. |