DSXchange

Have a look at my blog entry <a href=http://blogs.ittoolbox.com/bi/websphere/archives/are-you-suffering-from-row-leakage-7169>Are You Suffering from Row Leakage</a> which has a link to instructions on capturing SQL codes in parallel jobs.

There are a list of helpful certification links and study material at http://www.squidoo.com/datastage

Also need forums for new products in the next release: Federation and Replication servers. Formerly part of the DB2 suite, soon to be part of the Information Server.

Try importing your table definitions through the Orchestrate schema import option rather than the ODBC or client import. They may be more accurate.

A dataset does not need a reject link as it saves the data in the internal data formats. This makes it the most efficient way to save and retrieve data in parallel jobs. Filesets are similar to datasets in that they are saved to nodes and not a specific file location, but they are saved in standard ...

That might be a record! Great score. Well done.

I used to wonder why you went with DSXchange instead of DSExchange, that is until I read about embarrassing URLs:
http://independentsources.com/2006/07/1 ... pany-urls/

You could have made it onto the list!

You don't need to know MS Access to use the reporting assistant. Your client installs a system ODBC connection called DataStage Reporting Assistant. Once you move your data into the Reporting repository from the Manager tool you can access the details in any ODBC enabled product such as MS Query or ...

If you were confident you running the only job updating the sequence for the duration of the job you could call it prior to the start of the job (from a sql script run by a sequence job) and pass it in as a job parameter, increment it in a transformer, update it at the end of the job (via the after-...

Just make sure you set the APT variable at the job level (by adding it as a job parameter) rather than at the project level where it could break a lot of other jobs. The danger of setting these variables is one of the reasons why I prefer the Sort stage set to already sorted as they APT variable cou...

There is a very good job comparison utility in the next release of DataStage but not much in the current release. Since you are talking server edition you can extract your job definitions to the reporting tool and run queries against it and compare the query results. You should be able to run a quer...

The dataset should remember that it is partitioned and sorted when you read from it. Set the partitioning out of the starting dataset to "same" and not "auto" to make sure it takes the settings of the dataset. This might be enough to convince the join stage that it should not resort the data. The in...

I think you can sit the exams for free at the conference! Anyone had this confirmed to them?

The next version of DataStage has an option to turn on performance monitoring in a job and produces 19 different performance graphs on disk I/O, RAM and CPU utilisation. Have a look at the Advanced Parallel Job Developers Guide section on memory, buffering, disk I/O and CPU utilisation for descripti...

I remember back when I was taking Visual Basic certification there were all types of preparation exams and books. You could train a parrot to pass the exam. People would sit the exam several times over to build up a good long list of actual or similar certification questions and then use them to sel...