karri somasekhar reddy's Profile

database restore operation uses a database backup image to recreate a database. If you want to clone a database from one machine to another, the simplest way is to restore the database from a backup image. The file system paths used by the database are also contained within the backup image. Therefore, unless the file systems and the physical devices that are referenced by the database on the source system are set up exactly the same way on the target system, you will need to perform a redirected restore operation.

A redirected restore operation consists of a two-step database restore process with an intervening table space container definition step:



1. Issue the RESTORE DATABASE command with the REDIRECT option.
2. Use the SET TABLESPACE CONTAINERS command to define table space containers for the restored database (DB2 needs to know where you want the table spaces to reside on the target system.)
3. Issue the RESTORE DATABASE command again, this time specifying the CONTINUE option.



It is important to remember that the entire redirected restore operation must be invoked from the same session; otherwise, SQL0900N is returned and the restore operation fails. One way to ensure that this does not happen is to create and run a script that contains all three parts of the redirected restore procedure.

The following example shows you exactly how to successfully perform a redirected restore operation on Windows operating systems or on UNIX-based systems. Instead of restoring a backup image from another server, I will show you how to restore a backup image from a different instance. The principle is the same, and the details are identical.

The source instance for the Windows example is called PROD. The target instance is called MYINST. The existing database on PROD that is going to be restored (created) on MYINST is called MOVIES. The MOVIES database is located on drive D.

The source instance for the UNIX example is called prod. The target instance is called myinst.

he IBM DB2 SAMPLE database includes a number of sample Tables, Views, and stored procedures. For readers who haven't worked with Delphi 2005 in combination with the IBM DB2 UDB SAMPLE database before, here are the steps to connect to the IBM DB2 UDB SAMPLE database:

Start Delphi 2005 Enterprise (or higher), and go to the Data Explorer. Here, you'll see the list of available connections to databases, like DB2, SQL Server, InterBase, Sybase, and so. Select the DB2 connection, and right-click on it to modify the connection in order to connect to the IBM DB2 UDB SAMPLE database. (See Figure 1 for my settings.)