DSXchange

DataStage is one component in IBM Information Server. Information Analyzer is another. You purchase the product IBM Information Server (this is the only one with a part number) and optional add-ons, one of which is DataStage.

Make sure that every row you send to DB2 does not violate the foreign key constraint mentioned in the error message (or any other constraint for that matter).

Get into Help from Designer or Manager and open the topic BASIC Tasks

Welcome aboard. :D You are not the first to have encountered this problem. It seems from what you have tried that you have already searched the forum for possible answers. It might be useful to place before-stage and after-stage subroutines that execute timing points either side of the Transformer s...

It is if you create one. Create a routine of type before/after subroutine. In there you can invoke the DSGetLinkInfo() function (and every other function in the DataStage API). What do you want to do with this row count?

You can create projects anywhere you like except the root of a file system.

Don't used mapped network drives, however, for that introduces far too many points of failure, some that aren't even visible (such as locking in the Repository database).

Please re-educate your coworker.

Yes, but you will need separate columns on the rejects link for the DBMSCODE or LASTERR or SQLSTATE link variables from the ten other output links. Name these columns appropriately, such as Table1.DBMScode.

More standards than you can imagine!

It seems that most sites develop their own, or have them suggested or sold or otherwise imposed by a consulting firm.

There's apparently no "industry standards".

Wait for the challenge in getting all the silo owners to agree on consistent enterprise-wide terminology. How good are your negotiation and dispute resolution skills?!

... although sometimes you will get "log" and "logbad" files in /tmp.

We do not - can not, according to out licensing agreements with IBM - ship or otherwise redistribute material in which IBM owns intellectual property. Most of their manuals can be had for the asking, or for a small fee, in electronic form. Contact your DataStage reseller.

The overflow file could be used even if the hashed file contains very few groups. It's not related to the total volume of data - it's related to the evenness of spread among the available groups (pages) within the hashed file structure. The only control you have over that is choice of hashing algori...

You could undertake some training

Manage expectations better. This might be the best achievable time - it depends on very many things, such as the complexity of transformations, the number of indexes and constraints on the target table and, of course, the efficiency of your ETL design. Without knowing those factors it is impossible ...