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! =-----