| View previous topic :: View next topic |
| Author |
Message |
erasani_p
Beginner
Joined: 28 Jun 2004
Posts: 14
Topics: 10
|
 Posted: Mon Jul 05, 2004 10:28 am Post subject: Copying Tables from Production to Development |
 |
|
Hi all,
I have heard that we have to copy tables from Prodcution to Development before we can work on DB2?
Can anyone explain the exact procedure for doing that? If possible suggest me any link where i can find all these stuff?
Please give me the steps for doing the above mentioned prob?
Thanks & waiting for u r answer
Prashanth |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Mon Jul 05, 2004 12:53 pm Post subject: |
|
|
Erasani_p,
It is recommended that you do your testing with a sample production data before you move your program to production.
However there are many ways to achieve this.
Usually a sample data from production tables is unloaded then re-loaded in test region.
You can check the DB2 forum for samples of unload and LOAD jcl's
On the other hand if your production and test db2 systems are connected then you can use QMF to copy the data from production.
Check this link which discusses in detail about accessing tables from two different sub-systems
http://www.mvsforums.com/helpboards/viewtopic.php?t=67&highlight=access
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
