DSXchange

So... what was the resolution?

I'm sorry, but how can anyone here help you? Get 'the basic architecture of the datawarehouse' from the client, as Arnd notes I seriously doubt it's an out-of-the-box solution.

How do you want to get this information - from DataStage or from the command line? An alternative to the logs approach is to simply ask the job itself, using either -jobinfo from dsjob or via DSGetJobInfo() with an InfoType of DSJ.JOBSTATUS.

Also let us know the exact version of the Oracle client installed on the DataStage server, the version of the database being connected to and your operating system's flavor of UNIX.

If you go the $? route, which would be a typical approach when scripting something like this, make sure you capture the value immediately after the dsjob call and stash it somewhere - file, another shell variable, whatever. Since it is the exit status of the most recent command, execute anything els...

I know... was wondering if our friend here did that or just cherry-picked a handful of 'alphanumeric' values to remove.

Job design? Do you have row buffering turn on or IPC stages in the job? Please post the complete, unedited error(s) from your log as well, please.

So... you listed every single character other than A-Z and a-z, and converted them to an empty string?

Didn't say it would be pretty. Select 'Next' and select the date the next time the 3rd business day rolls around. Then either go into the crontab for the scheduling user and duplicate/tweak that for say, the next year or wait for the upcoming schedule to run and than schedule it again for the next m...

Sure. Schedule how, though... Director? 'Add to schedule' each 3rd business day of the month. Enterprise scheduler? Pretty much the same answer. Manually. Another approach, one I've used quite successfully. Schedule a Sequence job to run every day. First activity is a routine that determines if the ...

Perhaps something like SysInternal's Process Explorer can help:

http://technet.microsoft.com/en-us/sysi ... 96653.aspx

Ok, wanted to make sure you weren't creating the issue yourself. So, now you need to find the process that has the file locked/open and kill that. Could be a user, could be a defunct instance of your job, who knows? It's out there and needs to be ended. Unfortunately, I have no idea how one would do...

Obviously, some process is using the file or you wouldn't have received this error message. What is your job design?

Not only outside of the project path, but off the partition where either the DataStage software or projects are installed. The goal to is keep storage of that nature from filling the DataStage partition which is nothing but Bad News and leads to project corruption. Best to create a separate, dedicat...

Not going to help.