DSXchange

Arasan, would it be correct to condense your problem to something like this: We have a text file whose last line reads "### Job 86 (RPT507B BBW ): 25 lines, 1 pages, 10/26/2005 01:55:17" and we wish to rename this file to "RPT507B_BBW08", where the value 08 comes from the current day of the month. W...

If we were in a car forum your question would have been "my car isn't running, there's a blinking red light. What is wrong?". Also, using words like "urgent" and "asap" is not a good idea - we are all volunteers here - and usually results in slower responses. In your case you should reset the job an...

Tania, if you use that option, all hashed files that are created will be 64BIT. This is not necessarily wise, as the performance is somewhat slower due to overheads and the storage space required also increases. I wouldn't recommend doing this unless all of your hashed reference files are over 2Gb (...

Wolfgang,

I know I've seen jobs with over 100 stages. Don't know if they ever ran, though...

Then you should reproduce the problem and have the DBA tell you which locks the processes hold and are waiting on (if it is a deadlock as you assume the locks/waits should match up amongst your 3 sessions). I think in this case you should only have two sessions, though. Could one of them be an old o...

How many Oracle stages do you have in your job, and how many links going into the stage(s)? Each of these might be an Oracle connection. You should ask you DBA to monitor these sessions and see what lock or resource they are waiting on - a deadlock within connections for one DS job doesn't point to ...

Have you looked into your database's trigger mechanism to fire of the UNIX dsjob command?

Yes, looks like a bug - the "$" symbol prefix isn't accepted by the stage compiler. I tried using one in the stage variables as well and it didn't work.

The error message is when creating the file, not when writing to it. You most likely have a hashed file stage where you delete & create the file each run. A modulo of 985,339 and separtion of 11 will generate a file that needs more than the 32bit pointer to address; in fact I went to a DataStage...

dsusr,

you won't be getting any userful advice unless you actually tell us what the compiler error is.

There is always going to be some limit on the number of stages a job can support - but this is far, far higher than any acceptable job you will write. Put yourself in the shoes of someone opening up your job and trying to understand it in order to make some changes. If you have 150 stages and lines ...

"permission denied" is a UNIX error message, the user you are running your DataStage job as does not have sufficient privileges to open the sequential for (probably for writing). If you do a unix "ls -al {seqfilename}" you will see what the access rights to that file are. Access rights are changed u...

Rangs, yes. With a multprocessor windows machine even one program may span processeing time across the processors using multi-threading; but that is limited by many factors. When you specify multiprocess in a DataStage job you will have more than one Windows process running, and those can be active ...

Tania, the hashed file mechanism itself hasn't changed between versions, so any change in sizes is not due to internal structure modifications. Have you looked at the hashed file contents to see if there are visible differences in data (the one thing that springs to mind is that for some reason stri...

Isonisak,

that's correct.