13.13. Case Study

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:\temp
The backup image is created as: 
D:\temp\PROD1.0\DB2\NODE0000\CATN0000\20040414\170803.001
2.
Obtain the table space container information on PROD1. This information ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial