DSXchange

There is a kernel patch for Linux for PDFLUSH. This is a known LINUX issue with EE. My site has patched SUSE kernel for this, but it may be called something else in Redhat. Regards, Ray Daignault Thanks for your response. I forgot to mention, but our shop is SuSE Linux, not RedHat . Do you happen t...

mandyli wrote:Hi,

Red-Hat Linux

@mandyli - Did you get a solution to this problem? Please advise if you have a solution as I am facing exactly the same problem and this happens very randomly to any job at any given time. It just hangs there forever...

Thanks.

Link Sort is a sort that is done within the link using DataStage Sort Utility.

Sort stage gives you more power to handle things, like the kind of sort utility you wish to use (using Unix Sort or DataStage sort etc.).

Regarding Stable Sort, the manual has a great description. Please do read it.

I am reviving this topic again, as I have a couple of questions with regards to the state files which are impeding performance for some jobs. Scenario: I saw in the state file that it is storing ranges of values that are not yet generated. In our shop, the state file block size is set to be 500,000 ...

*Update* I did not realize that Resource Estimation "Run" will actually do a run and log entries in Director. When I looked at it, here is what is logged: Entry-1) main_program: Unexpected tokens: -f RT_SC2944/OshScript.osh -escaped -pf RT_SC2944/jpfile -impexp_charset UTF-8 -string_charse...

Thanks for your replies. I could not find any documentation relating to these tools in the Designer guide. I launched the tool and there is some help w.r.t that. However, when I launch this tool, it is asking me to "Run" the job (according to the documentation, it will create a static mode...

Did anybody in this forum work with IBM Tivoli Workload scheduler? Does that help in my case? Or is it more like a conventional (external) scheduler?

Hello, We are a relatively small DataStage shop (about 10 - 12 users) and we (our team) use DataStage, QualityStage and Information Analyzer to do their work for Business Intelligence. There are other non-BI related DataStage jobs that are running in Development, Test and Production environments. Ne...

See if this helps:

viewtopic.php?t=136356&highlight=leading+zeroes

An execute command there does a sleep nnn to get you your 2 hours. Then you perform your check for the file again using ls and your file pattern. Well, he doesn't want to wait for 2 hrs and then check the file. He wants the process to start doing its thing within those two hours if there is a file ...

Not that I am aware of. If you want a pure DS solution, then you might have to "ls" and check if the file exists, if not do a "SLEEP" and loop back. This is kind of (not exactly) simulating what the wait for file activity does. The easier way would be to have a Unix script.

Reject that and in the link's constraint box, put in '1' underneath "Abort After rows". That should do the trick for you.

Interesting, never tried this. But, if you couldn't do it the way you are attempting to do, you could always: 1) "ls <filename>*" in a Execute command activity and use the output in the Wait for file activity. or 2) If it is the current date that the file has, then get that in a User varia...

I have enabled the "dsdlockd" daemon in both Development and Test areas. So far so good with respect to the locks, although next week we are planning to run the production process on test to do a pre-load and that should be the acid test to this daemon. This process will take about a week ...

Is this job, that is causing you grief, running as part of a sequence? The disk may be getting full at the time the job is getting triggered. Check with your Unix admins to see the disk usage at a point in time or you monitor that and see what is happening. Lookup is dependent on the memory. As long...