DSXchange

Team, I am working on a project to regularly process terabytes of legacy System z (mainframe) data (e.g. VSAM, Physical Sequential)) with DataStage. DataStage will be co-located on System z running in z/Linux. Communications between z/OS and z/Linux will be via HiperSockets. https://www.ibm.com/docs...

Customer is just implementing DataStage. They would like to use files stored on MS Distributed File System (DFS) as input to DataStage jobs. Searching the documentation and general Googling has not turned up which Stage to use and how to configure it to access MS DFS files. TIA!

The Db2 Connector supports the "Bulk load" option using the Db2 Load command. Is there a way to invoke the Continuous Data Ingest (CDI) Utility from the Db2 Connector?

It looks like the navigation panel in the upper left corner of the Properties tab of the ODBC and database connector stages has disappeared. It looks like it has been replaced a pulldown menu. Please confirm I am not missing something (obvious). TIA.

By-the-book InfoSphere Information Server v8.x backup procedures require several steps on each tier and perhaps an extended outage. I am teaching an Information Server class and many students say their organizations rarely backup IS because of the outage impact on production operations (which run 24...

Note that the documentation referred to in the thread "WebSphere DataStage Programmer's Guide" is available via Information Server v8.1 APAR JR31951 along with a bunch of other manuals. http://www-01.ibm.com/support/docview.wss?rs=14&uid=swg1JR31951 It can be downloaded at http://www-9...

Where can I find the complete syntax of the DSJOB command? I have spent the better part of an hour looking in the DataStage Information Center online, the Parallel Job Developers Guide, Parallel Job Advanced Developers Guide, Server Job Developers Guide. Is there a link or manual you can point me to...

kumar_s wrote:I supppose by not passing the invocation id, you are trying to keep on triggerin the master job.
When you run the Job sequence from Windows, you will have small box with a display of Invocation id, w ...

That fixed it. Thanks.

You could check couple of things: 1. See if the job is in aborted state or Not compiled state as the warning suggests. 2. Are you passing different invocation id's every time you are running the Job Sequence. All seven of the Server Jobs compiled successfully after I updated the Job Properties. All...

I have created seven DataStage Server Jobs each of which runs against hundreds of source databases. I would like to run the same DataStage Job against multiple source databases simultaneously. I set the "Allow Multiple Instance" switch in the Job Properties of the Server Jobs. I have a Seq...

I am looking for a recommendation for Windows job scheduling software to run DataStage Jobs. I am looking at ActiveBatch, JAMS, and Vinzant. Any experiences? Any other alternatives.

TIA!

The native scheduling facility in the Director is somewhat limited. I have some Jobs I want to run every five minutes. Others every hour. Information Server is installed on Windows. I am assuming the alternative to the Director scheduler is a batch script invoking the DataStage Job via a line comman...

Thank you to all who responded to this post. I have blogged on the integration of InfoSphere Change Data Capture and DataStage - including the solution to the pruning question I had posted here.

http://www.thefillmoregroup.com/blog/?p=369

I have an ODBC Stage that SELECTs rows from a System i table/physical file. This feeds a Transformer stage that puts the rows on respective INSERT/UPDATE/DELETE links to a second ODBC Stage writing to another database. Once all of the records have been processed in the second ODBC Stage, I would lik...