By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Mass copy data from db2 in OS/390 to udb db2 running NT

P: n/a
Hi ,
I am in need to find a way, to mass copy the data from db2 table
running in mainframe to universal database db2 on NT. I know that DB2
connect gives the flexiblity of connecting and communicate the db2
application running in mainframe. but i want to know that whether i
can do mass transfer data between the two system . i like to do as a
night job that runs for many hrs.I like to know any protocol is used
for such connectivity and communication.pls help me.

Thanks and Regards
kartick
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
kartik wrote:
Hi ,
I am in need to find a way, to mass copy the data from db2 table
running in mainframe to universal database db2 on NT. I know that DB2
connect gives the flexiblity of connecting and communicate the db2
application running in mainframe. but i want to know that whether i
can do mass transfer data between the two system . i like to do as a
night job that runs for many hrs.I like to know any protocol is used
for such connectivity and communication.pls help me.


You have a number of options. Disclaimer: I'm not a DB2 z/OS expert.

You can unload the data on the mainframe into a flat file; FTP the
file and load it on NT.

With DB2 Connect, you can use the EXPORT command to export the data
to a flat file on the NT box.

You could also define nickname(s) on the NT server that reference the
table(s) on the mainframe to allow you to do 'load from cursor' or
even 'insert into ... select' (yuck, if you have a lot of data).

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.