You have just been assigned a new task: to clone the production database PROD1 on a Windows server to another Windows test server. These are the criteria:
The cloned database name is TEST1.
The containers for TEST1 must be redefined. They must reside on the D: drive of the test server.
TEST1 must contain the most recent data in PROD1.
1. | First, take a backup of the database PROD1. Because PROD1 is a 24x7 production database, it is not possible to perform an offline backup. Therefore, you decide to perform an online backup: db2 backup db prod1 online to d: emp
The backup image is created as: D: empPROD1.0DB2NODE0000CATN000020040414170803.001 |
2. | Obtain the table space container information on PROD1. This information is needed to define table space containers for the test database.
|
3. | Transfer the backup image over to the test server. FTP the backup image, including the folders and directories starting at D: emp, over to the test server. |
4. | Perform a database redirected restore and define the table space containers for database TEST1, as shown in Figure 13.21. Figure 13.21. Performing redirected restore of PROD1 into TEST1 |
5. | Perform a roll forward on the newly restored database TEST.
|
6. | Connect to TEST1 and verify that it contains the correct data. |