doyouDB2.com - Backup/Recovery

Backup/Recovery - Tips & Tricks

db2untag tool

Friday, 05 September 2008 11:09 Ravi Khandelwal

A quick tip to save time during a large database restore - the db2untag tool.

Consider the following scenario:

You are trying to use redirected restore to restore a 5 Terabyte production database having DMS tablespaces to a development system. The first step of the restore (RESTORE REDIRECT) completes successfully. The second step (SET TABLESPACE CONTAINERS) creates new tablespace containers (this may take hours if the database is sized at 5TB). Unfortunately, the third step (RESTORE CONTINUE) fails with some weird error.

Write comment (0 Comments)

Restoring a v8 backup into a v9 database

Monday, 04 August 2008 02:25 Ajay Jain

Here is a tip from db2 expert Ajay Jain on how to restore a db2 v8 database into a db2 v9 instance.

If you are also working for a client like me, where migrating production system(s) to latest version(V9) takes months even after you migrated the QA/DEV/other boxes, then I assume, you may face a situation when there is a need to restore v8 prod copy into one of the v9 migrated QA/DEV/other DB2 instance/db.

Here are two ways in which you can achieve this:

Write comment (1 Comment)

DB2DART – Extract data from a Corrupted Table

Tuesday, 29 July 2008 10:51 Vijay Budde

This tip has been submitted by Vijay Budde. Mr. Budde is a long time db2 expert and enjoys tuning db2 databases for optimal performance.

If a table in the database gets corrupted because of any reason (say a hardware problem), attempts to access the table through SQL may not work and db2 might drop all the connections to the database and even mark the database as BAD.

Write comment (0 Comments)

ROLLFORWARD to END OF BACKUP - Finally!

Thursday, 24 July 2008 10:44 Ravi Khandelwal

I always hated DB2 for the way it had structured the rollforward to work post restore from an online backup. Most of the times, while restoring to a target database on a different system, I just wanted to rollforward my database till the end of backup and would have liked a single straightforward command. But until v9.5 arrived, I had to use a roundabout way to accomplish this feat.

Prior to v9.5, to find the minimum recovery time of the database backup, I had to issue a the following command:

Write comment (2 Comments)

Remove Backup Pending state without taking backup

Wednesday, 16 July 2008 13:44 Ravi Khandelwal

How to remove backup pending state of a tablespace/database without actually taking a backup?

A LOAD operation without the nonrecoverable or copy yes option puts the tablespace in backup pending state. If you change your database logging from circular to archive, the database state will change to backup pending state.

While it is strongly recommended to take an actual backup in such cases any stay out of any possible trouble, there is a workaround to bring your database out of backup pending state using DB2DART utility. This would save a lot of time (if you database is huge) but in the case of a corruption your database may become unrecoverable. You must backup your database/tablespace on the first available opportunity if you use DB2DART to change database/tablespace state.

Write comment (2 Comments)

More Articles...

«
Start
Prev
1
2
Next
End
»

Page 1 of 2

doyoudb2

db2untag tool

Restoring a v8 backup into a v9 database

DB2DART – Extract data from a Corrupted Table

ROLLFORWARD to END OF BACKUP - Finally!

Remove Backup Pending state without taking backup

Search Site

Subscribe

Categories

Sign In/Register

Syndicate Feeds - Subscribe