DSXchange

For remote monitoring of the production batch jobs, we want to allow regional helpdesks to be able to view the job logs. Our ideal solution would be an html page where they can select the job and view/refresh the job log as the job is running. A top-level page of each job and it's satus will also be a goal.

What is the best method to achieve this? We have looked at the API in both C++ and VB. There is also a UniVerse ODBC driver that some cases refer to, but we cannot find this on the DataStage installation on the IBM web site. We have also looked at the dsjob program.

Thanks for any advice on this. Any examples would also be welcome.

Buy DsWebMon from me. It is a Web front end that does most of what the Director does. It is designed to run over a modem. No VPN required. It is real cheap. You would spend a lot more money building this than it would cost to buy it. If you need it then we could customize it or sell you source code. It is a very thin client where all the client does is display data. It is real Delphi, ISAPI and BASIC.

If you want other options then VB would not be hard. It is fairly easy to connect to DataStage using VB. I have posted code snipets which show you how. The log files have good dictionary files to display the data. The log files have a field for instance id to separate mutiple instance logs. This is by far the easiest thing to extract from DataStage.

You could also do it with the dsjob command. You would have a lot more control in VB.