MVSFORUMS.com

nagapa · Beginner Joined: 16 Sep 2004 Posts: 11 Topics: 4

Hi,
I am a application developer and doing a bit of db2 admin work for our system. We are trying to refresh our test region with prod data.

Is there are way to copy the complete production database and load it on to the test database. Both are identical in design and size.

If we cant do it at the database lever, can we do it at table space.

I have done table load and unloads, as we have over 400 tables it would be our last resort.

Thanks for your time.

Regards
Nagappan

kolusu · Posted: Fri Jun 08, 2007 8:31 am Post subject:

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

there are several ways:
1. system level, you can clone the whole system (include the OS)

2. DB2 subsystem level, define the same DB2 subsystem in test, copy all the DB2 volumes, and start in test system (not recommended)

3. IMAGE COPY, then DSN1COPY to test

4. UNLOAD, then LOAD to teset (the best way)
Use LIST and TEMPLATE will be convient if there are hundreds of tables.