DSXchange

This problem is almost never caused by a missing password and is usually due to an incorrectly setup DB2 client for DataStage. I posted a link to a DB2 tutorial from IBM DataStage Tip: Extracting database data 250% faster . One tip is to try to connect to DB2 from the command line to get better erro...

The last thing you want to do is to have the log messages being loaded into your Director, that really slows things down. I think you can right mouse click and clear the log from Director without looking at the log. This should make it easier to get rid of your warnings.

IBM have now added links to download the Information Server 8.0.1 for AIX and LINUX so it looks DataStage 8 for Linux and AIX has arrived. I'm sure it's not long until the Solaris and HP versions!

Would it work with the join stage? You might also be able to replace your lookup stages with a custom operator stage that calls the lookup function without the GUI. Not sure how this would go with job parameters and RCP though.

You are learning about this in my blog aren't you?

QualityStage is fully implemented as stages within DataStage 8 so you don't get the option to install them on different servers. You could probably do something with the config files if you wanted to make parts of a cluster or grid specialise in Quality functions like matching. QS 8 and DS 8 are ful...

It's pointless to convert all jobs since many smaller volume jobs will run faster as server jobs. It is dangerous to do a large scale conversion without an expert parallel job developer. IBM offers a conversion service, they have conversion tools in house and a specialised team, they don't advertise...

If you choose "Show Link" from the compilation box and immediately hit the delete button it should remove the link even if you can't see it. Another way of finding it is to draw a selection box over your entire job and see if anything gets highlighted that is too small to see. You also might have a ...

My IBM DataStage RSS feed alerted me to a new release note for the Information Server 8.0.1 release that indicates it is the first AIX and Linux version. See my blog post IBM release Information Server 8.0.1 for Unix AIX and Linux for the links. Can anyone confirm whether this is available in the US?

It doesn't need to change. While the metadata repository has changed the parallel engine hasn't. Datasets should be the same. It's the cataloguing of datasets that is causing your problems. If you have upgraded it should still be available through the dataset manager. If it isn't get in touch with A...

Use the new performance monitoring reports and graphs to monitor jobs that fail. Do they fail when they are run individually or when they are run with a lot of other jobs? Compare your current environment and project variables to the values you had pre migration to find out if any important settings...

If you have no constraint and no rows going down that link it is usually because the rows are being rejected. Do you have a reject link on the transformer to trap dropped rows? Are there warning messages in the log. If it is a glitch in the link you could just delete it and replace it with the link ...

It's odd because they are giving you access to the most sensitive tables - the customer and financial data tables - and are kicking up a stink about irrelevant system tables that have no private information in them. I think you could publish most system tables to the entire world without breaking SO...

You should explore your right mouse click menu in Transformer to see what macros and constants are available. You might find a use for things like job start time or job name or invocation id. Functions like wait for file and send email should be run once before or after the job so they are best in a...

Have a look at the first message in the Director logs that lists all the environment variables for that processing session. Sometimes a job uses a different profile to the one you expect. It's not all that dynamic since the user would need to keep changing the environment variable each time they run...