Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How do you restore a 15 DB2 Database Partition to 7 DB2 DB partitioned target database (Such as Prod to QA database)?

Posted on 2012-09-05
Medium Priority
Last Modified: 2012-09-09
Hi all,

I have a 15 Database partitions on my production DB2 and 7 database partitions for my QA Test database. I need to restore to test environment the backup image copy of my production Db2 database to the 7 partitioned Test Database.
How can this be done efficiently with best practice in mind?
Question by:Enyinnaya
LVL 37

Accepted Solution

momi_sabag earned 1000 total points
ID: 38367452
i don't think you can do that
i think the only way to "cut down" the number of partitions is either use export on the prod machine and then import on the test machine (and the records will get distributed correctly), or you can recover the prod backup to an identical structure in test (15 partitions) and then manually merge some of the partitions until you narrow it down to 7

the question to ask is, why can't you have 15 partitions in the test system? it will occupy the same amount of space if all the data is copied, so i don't see any logic behind that decision
LVL 46

Assisted Solution

by:Kent Olsen
Kent Olsen earned 1000 total points
ID: 38367652

Starting with UDB 9.5, you can backup and restore multiple partitions with a single backup.


Keep in mind that the backup/restore process essentially copies a database, or in this case the partitions of a database.  When the restore is complete, the restored database will have the characteristics of the original database.  The process will not perform any fundamental changes to the database, like repartitioning.

If you need the restored database to have half the partitions of the original database, you'll need to micro-manage that.  And it will likely be a painful process.


Author Closing Comment

ID: 38381538
You guys ROCK!!

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question