DSXchange

Thanks for the response. We're on DB2. I think I have something that will work using Exit 0 and 1 based on conditions for logging an error.

Hi, We've created a routine that runs as an after-job subroutine in which DSExecute is utilized to launch a unix script with some sql in it. The program works fine. However, we're trying to build in error messages, so that let's say the SQL didn't execute for whatever reason (database down, etc.) th...

I'll remember the code tags for next time. Thanks alot for the response...that's what I kind of figured regarding the hash algorithm.

Hi, We have multiple jobs with large volumes of data where we've partitioned the jobs to load from a single DB2 source query into multiple DB2 target stages...though same table. Something like this (with some other processing in between): |---------->tgt Src---->Part------->tgt |---------->tgt Anywa...

I got an answer on this. I needed to add an environment variable called TEMP and then add the directory I wanted to direct the files to. Thanks for the response chulett!

Hi All,

Is it possible to change the directory where DataStage writes the buffer files for IPCs, transformers, etc? I changed UVTEMP and regened the uvconfig file and I also changed the tmpdir variable, but the server jobs still write to /tmp.

Hi All, I have a few questions regarding the DB2 Bulk Load Stage. We've been using the Bulk Load on the end of a process that has been disrupted more than two times now and every time the job aborts, the sequential file disappears! Is this a known issue with the bulk load stage or is there a setting...

Thanks for the response!

Thanks for the response!

Hey All,
I did a search but couldn't find any information on this particular topic. When you move Hashed files that were resized to 64bit from one project to another, do you need to perform a resize again in the new project before moving the Hashed Files to the new project?

Thanks for the responses and suggestions. I need to filter data from each file before loading (and this is a one time load) so I think I'll process each file separately to work around the link collector.

Hey All, Hopefully an easy question. We have 2 sequential files (same structure) loading to one table. We were using link collector stage but our job has failed a few times after running for a period of time. The files have different amounts of data (1st has 50 million rows and 2nd has 70 million). ...

Some more information. When writing to a sequential file, we are seeing performance upwards of 30000 rows/sec. Do you think this is an Ascential Configuration problem or Database issue? To me, it appears to be database but I don't know what to suggest to them for configuring the database to work bet...

Hi All, We are seeing consistently poor performance in our server jobs loading to DRS stages. Our database is db2. Poor performance is defined as ~25-500 rows/sec depending on table size. We manage 3 other environments and all perform much better. Of course, datastage is being blamed for not being c...

I understand changing the reusable job to allow multiple instances doesn't solve the problem Actually, that sounds like the only solution you have. Both the Sequence job (no 'r' by the way) itself and the Server job inside will need to be multi-instance jobs. And yes, the Sequence's invocation ID c...