Hi,
I have a question regarding to bulkload.
Our datastage server and DB2 server are located on different servers
Is it possible to create INPDATA.DAT and ULOAD.BAT, etc at the DB2 server machine, i.e. to make export and load locally at the db2 server?
Thanks,
Carol
BulkLoad
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can run a subsequent pair of jobs to FTP the control and data files to the other server. Or simply run the FTP from a BAT file, perhaps from an after-stage or after-job subroutine.
You can use a "remote shell" or "remote execution" or "remote login" script (BAT file) to execute the bulk loader. Search for these terms on the Forum; the technique has been discussed before.
You can use a "remote shell" or "remote execution" or "remote login" script (BAT file) to execute the bulk loader. Search for these terms on the Forum; the technique has been discussed before.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.