467,926 Members | 1,521 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

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

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
  • viewed: 1662
Share:
1 Reply
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.

Similar topics

3 posts views Thread by somaboy mx | last post: by
1 post views Thread by johnny | last post: by
reply views Thread by PokerMan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.