MVSFORUMS.com

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Members,

I want to copy a production IMS database to a Test Database which is existing / or to a new database which should be created by me , can somebody help me in this regard ,what all should i do to have a copy of Prod to Test Database, how can i check after copying that it is in sync with the prod database.Please help me with the process.

Sreejith · Posted: Thu Nov 06, 2008 11:50 am Post subject:

If you have FileAid for IMS, use the extract and load feature.Otherwise use the production image copy.

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Sreejith,

Thanks for your reply.I do not have File Aid for IMS , can you please help me with the production image copy JCL and what should i have the necessary pre-requisite before i run the utility i mean what all should i create before i run the utility.

Sreejith · Posted: Thu Nov 06, 2008 12:08 pm Post subject:

Assuming you already have an image copy, the reload jcl will look something like following

Anuj Dhawan · Posted: Thu Sep 17, 2009 6:27 am Post subject:

Usually, there are some "in-house" COBOL-IMS program at every site to do what you asked for. IMS DB may contain some maskable information, which should not be loaded to a test envireonment DB. Suggest you get in touch with some peer at your shop before you proceed to do what you ask for.
_________________
Regards,
Anuj

ANIL SARATHY · Posted: Sat Dec 26, 2009 8:08 pm Post subject:

IMS is nothing but VSAM files in most cases. Just copy the vsam files individually into your own test vsam files. You will be all set.
_________________
Anil Sarathy

Anuj Dhawan · Posted: Mon Dec 28, 2009 3:29 am Post subject:

Hi Anil,

I did not understand your reply well, can you please elobrate on "copy the VSAM".

On the other hand, does that mean, as we have LDS in case of DB2, copy those LDS to test LPAR would allow us to browse through the prodcution data? Confused

_________________
Regards,
Anuj