Recovery as Normal Files(DB2) - Revision history

Sachin at 09:56, 6 January 2021

2021-01-06T09:56:35Z

Sachin at 09:56, 6 January 2021

2021-01-06T09:56:24Z

Sachin at 09:55, 6 January 2021

2021-01-06T09:55:53Z

Sachin at 09:55, 6 January 2021

2021-01-06T09:55:42Z

Sachin at 09:55, 6 January 2021

2021-01-06T09:55:02Z

Sachin: Created page with " Below documentation shows how to restore DB2 data after it has been recovered as normal files using steps as shown in Recovery as Normal Files(FileSystem) | Recovery as No..."

2021-01-06T09:47:25Z

Created page with " Below documentation shows how to restore DB2 data after it has been recovered as normal files using steps as shown in Recovery as Normal Files(FileSystem) | Recovery as No..."

New page

Below documentation shows how to restore DB2 data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files(FileSystem) | Recovery as Normal Files ]].
Please recover the DB2 database files.

Recovered filename will have a naming convention as shown below.

e.g. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001

Database Name = Sample
Instance Name = DB2
Timestamp = 20180523164142
Catalog Name = CATN000
Once you have the files, please follow the steps to restore.

We are demonstrating recovery for SAMPLE database (shown in below picture).

[[File:DB2SAMPLERestore.JPG | border|700x600px]]

{|style="padding: 5px; width: 85%;"
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' There are more ways to perform DB2 restore.
For more detailed information please refer to the DB2 Restore Documentation.
|
|}

===Step 1===

Login to DB2 Server and connect to the SAMPLE database.

{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
|
db2 => connect to sample

Database Connection Information

Database server = DB2/NT64 9.7.0
SQL authorization ID = ADMINIST...
Local database alias = SAMPLE
|}

===Step 2===
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
|
db2 => restore database sample from "C:\backup" taken at 20180919172832 with 2 buffers buffer 1024 parallelism 1 without prompting
SQL2540W Restore is successful, however a warning "2539" was encountered during Database Restore while processing in No Interrupt mode.
|}

===Step 3===

From Device , select the data file to restore.

[[File:SelectDataFile.JPG | border|900x700px]]

After that , optionally you can click on Verify Backup Media too.

===Step 4===

Click on OK and start the restore. Your data should start restoring.

[[File:DataRestoreProgress.JPG | border|900x700px]]

===Step 5===

Verify the restored data,once restore has been successful

[[File:DataRestored.JPG | border|900x700px]]

[[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

@@ Line 49: / Line 49: @@
+|
 db2 => restore database sample from "C:\Temp\RestoredData" taken at 20210105171743 with 2 buffers buffer 1024 parallelism 1 without prompting
-SQL2540W  Restore is successful, however a warning "2539" was encounteredduring Database Restore while processing in No Interrupt mode.
+SQL2540W  Restore is successful, however a warning "2539" was encountered during Database Restore while processing in No Interrupt mode.
 |}

@@ Line 19: / Line 19: @@
 {|style="padding: 5px; width: 85%;"
-| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' There are more ways to perform DB2 restore.
+| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' There are more ways to perform DB2 restore.For more detailed information please refer to the DB2 Restore Documentation.
+|
 |}

@@ Line 11: / Line 11: @@
      Timestamp = 20210105171743
      Catalog Name = CATN000
 We are demonstrating recovery for SAMPLE database (shown in below picture).
@@ Line 27: / Line 24: @@
 |}
+Once you have the files, please follow the steps to restore.
 ===Step 1===

@@ Line 5: / Line 5: @@
 Recovered filename will have a naming convention as shown below.
-e.g. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001
+e.g. SAMPLE.0.DB2.NODE0000.CATN0000.20210105171743.001
      Database Name = Sample
      Instance Name = DB2
-     Timestamp = 20180523164142
+     Timestamp = 20210105171743
      Catalog Name = CATN000
 Once you have the files, please follow the steps to restore.
@@ Line 48: / Line 48: @@
 {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
+|
-db2 => restore database sample from "C:\backup" taken at 20180919172832 with 2 buffers buffer 1024 parallelism 1 without prompting
+db2 => restore database sample from "C:\Temp\RestoredData" taken at 20210105171743 with 2 buffers buffer 1024 parallelism 1 without prompting
-SQL2540W  Restore is successful, however a warning "2539" was encountered during Database Restore while processing in No Interrupt mode.
+SQL2540W  Restore is successful, however a warning "2539" was encounteredduring Database Restore while processing in No Interrupt mode.
 |}
@@ Line 56: / Line 56: @@
 ===Step 3===
-From Device , select the data file to restore.
+Roll the logs forward to the end of the backup to make sure the database is in a consistent state.
-[[File:SelectDataFile.JPG | border|900x700px]]
+                                 Rollforward Status
-After that , optionally you can click on Verify Backup Media too.
+ Node number                            = 0
+'''Note :''' If log files are not included in backup images, the rollforward recovery needs to be done as per the method used for backing up logs.
 [[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]