DSXchange

Our Windows 2003 Server has a Raid-System. Raid 1 for the System Disk (where DataStage is installed to) and Raid 5 for the Hashfiles. Under Raid 5 there are 5 Disks with each 180 GB acting under a 1 Logical Disk. Its a little bit weird...with 100.000 I have great performance, but with 200.000 it see...

Hello everybody, I almost despaire of performing my DataStage Jobs. In some jobs i have to use Hashfiles because of Duplicate Keys, but writing or reading in Hashfiles crashes our performance. At the beginning it works very good (about 600 - 1000 rows/sec) but after some time the performance is decr...

Hi Ray, thank you for your reply. In normal case there shouldnt be any warnings or in some cases only a few ones. But after fixing activities I got in a few jobs a huge amount of warnings which makes it sometimes unpossible to open the job logs and it is also very uncomfortable to purge every log ma...

Hello, is there any way to delete all job logs in a project by a command, routine or something like this? We have several jobs creating job logs over 1 GB (in case of warnings). Before restarting the jobs I want to clear the logs but it is hard to do it manually and the provided auto purge does not ...

Hello, i got the following phantom-error message when started a job. I tried to figure out the problem but till yet i havent found any approach. Can you help me? Where in my job is the mistake? DataStage Job 516 Phantom 2844 Program "JOB.657285897.DT.1351835990.TRANS1": Line 598, Nonnumeri...

Thanks for your fast reply!

It is a pathed hashfile with a pointer (set by "SETFILE"), so IT works :D

Good idea with the "dummy join"

Hello everybody, I hope you can help me. In my job I use a hashfile as source which have to be sorted at the beginning without using a Sort-Stage. My question is now, is it possible to sort a hashfile via command defined as "Before Job Routine"? I found a command like SORT.ITEM, but it doe...

Does this mean that if I set a pointer via SETFILE, DataStage is not able to delete the hashed file created in a directory?

How do you realize the import of Universe File Definitions if you specified it to a specific directory?

Because this was the reason of fooling in the database

Sorry, but i have to fool in the database because DataStage is not able to delete his own hashfile or just clear the data, although I have checked the options offered by DataStage ("Create File" / "Clear before writing" / "Delete file before Creating"). All this options...

Thanks, it works :D
Wow, DataStage is much more complex than Informatica PowerCenter

Hello everybody, i created a job which writes to a hashfile specified to a directory. After the job-run (hashfile was created) I tried to set a pointer to this hashfile like this: SET.FILE D:\HASHFILES\hash_RIS_to_vertrZURIS hash_RIS_to_vertrZURIS OVERWRITING Now I want to delete the hashfile with i...

Thanks for your reply. Within DataStage I created the hashfile hash_POLIZZ1 to the directory path D:\Hashfiles. Via command (SET.FILE D:\Hashfiles\hash_POLIZZ1 hash_POLIZZ1 OVERWRITING) I pointed the file to VOC. Because of a new requirement (new columns have to be added to the specified hashfile) i...

What is a UV Stage. I have a similiar problem. I want to get multiple rows from a lookup against a hash file (analog to ODBC Stage). How can i solve it?

Thanks for your reply

Regards