Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Transfer of DB2 data from NT to Mainframe 1
- Thread starter msmithuk
- Start date
-
1
- #2
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.
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.
- Thread starter
- #3
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.
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.
- Status
Similar threads
- Locked
- Question