To recover a dropped table, the Dropped Table Recovery option must be set to “Y” for the tablespace that contained the dropped table. For tablespaces created using the DB2 command prompt, this option is enabled by default. For tablespaces created using the DB2 Control Center graphical user interface (GUI), the Create Tablespace wizard lets you enable this option.
1 |
Start a terminal session on the DB2 Server, and navigate to the “…\SQLLIB\BIN” directory, where “…” indicates the installation path of DB2. |
4 |
To perform a soft recovery of a dropped database table, perform the following steps.
1 |
4 |
In the Navigation pane, click Create Restore Job, select Plug‑in for DB2 from the Plugin Type list, select a saveset that contains the backup of the target tablespace, and click Next. |
5 |
• |
Restore Mode: Select Online. |
• |
Restore only table space-level backup images: Select this option. |
• |
Rollforward Archived Logs: Clear this check box. |
To perform a hard recovery of a dropped database table, perform the following steps.
1 |
5 |
In the Navigation pane, click Create Restore Job, select Plug‑in for DB2 from the Plugin Type list, select a saveset that contains the backup of the target tablespace, and click Next. |
6 |
To avoid overwriting the existing data, use the procedure described in Renaming or relocating a database during a restore to restore the data to an alternate location. |
7 |
• |
Restore all table spaces in the database: Select this option. |
• |
Rollforward Archived Logs: Select this check box. |
• |
Hard Recovery: Select this option. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center