MVSFORUMS.com

PRAKASH · Beginner Joined: 07 Mar 2004 Posts: 10 Topics: 5

Hi all

I have a request where in I have to transfer the data from IDMS SQL table( not record) from one database region to another data base region. (from pre prod region to test region to be precise). Can you please let me know how can I achieve this.

Thanks.

kolusu · Posted: Tue Sep 06, 2005 1:03 pm Post subject:

prakash,

IDMS has an add-on tool called IDMS Database Extractor Option which can be used to copy the data from production. You can now use this dataset to load the test database.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

PRAKASH · Beginner Joined: 07 Mar 2004 Posts: 10 Topics: 5

Thanks Kolusu for your reply.
I talked to our DBA and found and unfortunately we dont have IDMS Data Base Extractor tool. Is there any other way to achieve this may be thru some JCL utility etc..
Thanks for your help

vivek · Posted: Mon Oct 03, 2005 8:31 am Post subject:

you need to use the migrator option in your configuration managemetn tool. otherwise punch into tso and then punch out to destination database.
_________________
Vivek,NJ

Db2,IDMS