Hi ipc I use a modified version of UtilityHashLookup, which I call DirectoryHashLookup. It takes two keys (but can easily be modified). The code is as follows: ************************************************************************* * Author: David Thompson * Date: 16th December 2003 * This functio...
Does anybody know how, or if, DataStage is able to schedule jobs to run on either of two physically distinct servers, such that if one should go down for whatever reason, the jobs will continue to run on only the surviving box?
Hi Guys Thanks for all the feedback. Ray - I have split the job in two, thus creating two jobs, each of which has only half the original number of conditions in the WHERE clause. Otherwise, these two jobs are identical to the original one job, and combined, they perform the same function on the same...
Hi All I have had problems with two of my jobs, which abort with the following error message: Abnormal termination of stage JobNAME..Transform detected (where Tranform is the name of the job's transformer). Both jobs have long conditions specified within the WHERE clause of the input Oracle OCI stag...
Thanks for those, they were very helpful. One more question however. Kenneth - you mention the type of i/o activity DS is going to do to them Could you clarify the sort of activity we should expect? Would the following encompass it? writing log files reading / writing inter-job hash files one-time r...
Hi All I'm trying to pin down some hardware requirements for a DataStage server to run an overnight Data Migration job. We're using DataStage 5.2.2 on Solaris, and will probably run 8 parallel jobs over 8 CPUs. The job uses several hash files, all pre-loaded to memory, but none larger than 500 kB. T...
The DBMS code is null in most cases, so this approach doesn't work (writes all rows to the reject file). However, I tried some similar approaches and it seems that, although the unconstrained reject row fails to work without any constraint, the Linkname.REJECTED variable is still set correctly. I've...
That approach returns all rows into the reject file, whether they are rejected by Oracle or not. I just want to get the rows that are rejected by the database.
Hi I've been using the Oracle OCI stage in DataStage 5.2.2. The stage writes out a number of rows to various tables in the database, and rolls back all rows should an error be encountered when writing any one row (eg. value too long for column). In the transformer which feeds the OCI stage, I also h...