DSXchange

And are those values correctly filled when you look at the first job log entries?

You can edit your post to remove all the details, they are not required in this case. Most likely the code is too big for your installation's optimizer. I would recommend turning off optimization either via your ADMIN tool for all jobs, or to change the compiler options for this particular transform...

No simple way, but you could write a procedure/function in DB2 and use that. See this link for an example.

Is the DataStage project UNIX directory being created? If you attach there, what are the file ownership and groups? Perhaps your user with which you create the project has incorrect umask settings?

"At the beginning" usually points more to a SQL or Database issue, whereas "at the end" often indicates a DataStage issue. As is often the case with sporadic problems, perhaps the column position change has just changed the frequency of the problem but hasn't solved it; I can't see how a column posi...

I have Version 8 on UNIX and the limit rows values are greyed out for Parallel jobs and enable for server jobs.

I haven't worked with FUTEX locks, but it seems to be the LINUX equivalent of MUTEX calls. So all the separate server job processes seem to be waiting on a signal that they are probably never going to get. Do you have any "defunct" or "zombie" processes visible?

satish_valavala wrote:...get the process id using above command
and issue the below command
kill -9 <pid>...

NEVER use kill -9 unless you know what you are doing and have the ability to clean up locks and the opportunity to restart DataStage

Mohandl - the numbers are absolutely meaningless; you asked for metrics without detailing what you wanted, so I did a typical consultant type of thing and gave you metrics The "best looking code" part doesn't have much meaning, either. First of all, you need to tell the forum if you are doing a Main...

There are various ways to do this using different functions. The answer depends on how you define "subtract one month". What is one month less than "July 31"? The simple method is to use ICONV() and OCONV() to convert a display date into an internal date, then subtract 30 and reconvert to a display ...

I don't think that this can be diagnosed from DataStage alone, you will need to involve your DBA when this happens again. Does the "hang" occur after all the data has been read or at the beginning of the SELECT?

I chose 132 as that is the (old) common width for wide printouts, before the days of variable width fonts. You can raise that width, but look at the help file to get the maximum allowable value. In this case, 132 should have been ample. Can you do a "LIST DICT yourhashedfile" ?

are the other processes also waiting on the same or similar locks?

I went to Google and entered "LINUX equivalent of truss" and found out that you need to enter the "strace" or "ltrace" command.

The SET.TERM.TYPE command should be on a separate line; and a subsequent GET.TERM.TYPE command will show a new width of 132 (or you can set it higher, if you wish). Right now, 5 columns of width 15 plus the default 3 space separator is over 80, which is why you are getting this vertically aligned ou...