Transfer of DB2 data from NT to Mainframe 1

[msmithuk]

What are the different methods available to get data from an NT DB2 database to a Mainframe DB2 database?

Thanks
Moira

 

[tbtcust]

Hi,

I would try the following:
1) setup db2 connect on NT.
This will allow you to interact with the MF DB
2) use the export command on NT to get the data out
3) use the import command on NT to load the
data onto the Mainframe DB

Hope this helps.

 

[msmithuk]

Your reply was good and I have checked it out.
However, I do need to select only certain columns off specific tables and put some logic around it, i.e. only select data that has changed since the last time, so I am going to store a "last run timestamp" on an NT DB2 table, this will be updated each time the data is selected.
So I needed to schedule an application program, as the company I work for do not like scheduling Java apps, I have suggested they write a PL1 program on the mainframe, scheduled via Jobtrac, which sends a message via MQSeries to a queue which triggers the Java application.
This Java application is then going to use JDBC to be able to insert the selected NT data into the Mainframe database.