DSXchange

Maybe Ernie or someone else might comment, but didn't we have an attempt at an "Accelerator Pack" with DS years ago, I think it might have included some attempts at parallelism and Syncsort.

I'm not at a DataStage system this morning, but there should be a file called "CFFSTAGE.PDF" in your DataStage documents folder.

<shudder> I just realized the condition posted was a column derivation, not an actual transform constraint. Craig, you caught that one. I thought the date value of '0' was coming from somewhere else, not this line of code...

Ray, the source code is case sensitive in the DS_ROUTINES hashed file, but the executables are in the BP.O type 19 directory (I can't recall the actual dir name right now) and thus subject to the DOS case limitations.

Hello Quest, in your last post you were leaving the forum in a huff because some of the detailed responses were from premium posters and weren't visible to you. Now, just a couple of hours later, you post another thread with the same question. First off, a constraint evaluates to either TRUE or FALS...

The amount of memory used by programs is mostly dependant upon how you write your jobs. There are some possible configuration changes that can make DS use more memory but it is doubtful that they will speed up processing appreciably. If you design your jobs to use more memory (i.e. loading lookups t...

The existing verb is DS.REINDEX; but that begs the question why you want to create an additional index on the DS_JOBS file in the first place.

I need glasses. Mea Culpa Recommendation retracted.

Do you know the data values for the failed statement? Please go into your database command line tool and issue the same insert statement as generated in the DataStage job. You will get the same error. Then list your ITEMS table and you will see that your ITEMID does not exist in that table. Then ple...

Shri - it does. You should look up the "foreign key" concept in the database book (or web page) of your choice. Once you understand what you executed in the DDL you will understand what the error message means and how to correct it.

47shailesh - I have issues with several of your recommendations - Recommendation 1 is a correct one. Recommendation 2 is terrible, it will stop the DataStage engine - kick out any other users on the system who might be logged in and cause them to lose data if they were editing jobs and might leave r...

I would also recommend you set the MINIMUM.MODULUS on the large hashed file to a very large number so that it doesn't have to enlarge the modulus continually while writing rows to the file.

can you touch and create a file in /data with the same user id that you are logged into DataStage with?

It this a server or a px job? A recent similar post showed that the string actually contained unprintable characters - could this be the case for you?

And how much space at runtime in your scratch directory as pointed to in the config file?