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
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

    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 45

    Assisted Solution


    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

    You guys ROCK!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now