DSXchange

I briefly lost my mind and read the manual and discovered the answer. A join does a high-speed sort on the driving and reference datasets. So what I was seeing was the preload and sort of all reference data. My primary data wasn't coming through because it was being sorted before it went through the...

DataStage has never been inclined towards any database except perhaps Universe. The reliance on Universe is being removed in the Hawk release. I have version 7.x of DataStage and it has an enterprise stage, a bulk loader and an OCI stage for Oracle, DB2 and Teradata - as well as some other database ...

I have a job with a dataset as a source followed by several transformers and lookups. When I started the job it would immediately start processing rows from the dataset and retrieve lookup rows where required. I replaced my first lookup with a join stage and now the job has gone topsy turvy! When I ...

There were rumours that DataStage Hawk would go into beta testing at the end of April. Anyone heard anything about this? I doubt the beta version will have any IBM WebSphere branding in it.

Interesting. I also had to abandon the multi client switcher as I couldn't install it onto my XP machine. During installation prompted for a user id and password as it needs to run as a service on my machine, it then rejected every user and password I supplied including every administration user on ...

If you read the FAQ you will get answers to most questions, though the situation is likely to be different in 12 months. Ascential training and support will continue as is. Same numbers and same people. All products retain the same name with the word Ascential replaced by IBM WebSphere. It is now kn...

I have just upgraded a Windows XP machine to release 7.5.1. I had been using version 7.1 for weeks without any problem but I've hit a performance problem with the new release. If I open an existing job and delete a stage from that job my CPU on the client hits 100% for a few seconds. Then when I do ...

But they haven't renamed AscentialWorld 2005 to IBMWebSphereDataIntegrationWorld 2005.

IBM have now completed the purchase of Ascential and announced the new names of the product suite: m It is now official IBM WebSphere DataStage, part of the IBM WebSphere Data Integration Suite. The IBM Ascential roadmap can be found at (the good news is that Hawk release is not delayed): m IBM rema...

I am going to make a controversial statement here. I think in two years DataStage will have parallel jobs but it will not have server jobs. If you are starting out with DataStage you are better off going parallel. Ascential are moving the entire product suite onto a parallel engine, they have put se...

An additional note, the latest versions of MetaStage have a custom report that highlights the differences between two versions of the same job. You may find this makes the installation of MetaStage worthwhile as it saves you time in comparing your production and dev environments.

You cannot use the Reporting Assistant on parallel jobs. DataStage Enterprise Edition comes with a MetaStage license and you can use that for reporting. You can also find job names by running dsjob -ljobs projectname . Run this from a telnet session on each DataStage server. You can also get DataSta...

I think there used to be a cosort plugin for DataStage (don't know about syncsort), there also used to be a Trillium plugin for DataStage, however these vendors have been getting the cold shoulder from Ascential in recent times as they can be seen as competition for parts of the Ascential suite. Any...

I try to keep my hands to myself. Is there any reason to use Syncsort with DataStage PX? I thought the parallel sort was good enough and you have support for reading sequential files from multiple nodes or using a sequential file as a lookup source.

If you have installed your MetaStage repository on your DataStage server it is simply a matter of setting up the Universe ODBC driver on your DataStage server so the MetaBroker can access any Universe tables on that server or accessible by that server. The MetaBroker runs on the MetaStage server and...