DSXchange

Did you call it up and see if you could find locks? I don't have it active on this machine, so cannot walk you through the single steps.

saraswati - I am going to make an exception to my practice of not responding to any posts where people state that they need an answer because the problem is "urgent" -> if it is indeed an urgent issue then go to your support provider for immediate assistance, but be prepared to pay for that service....

I would recommend ensuring that the deadlock daemon is activated and running. That way if a job gets locked it will automatically clear within 15 minutes (the default setting in the deadlock daemon).

Do you have "job administration" active in your Director?

You posted SQL but didn't explain what the problem is.

I've used -1 and see no detectable slowdown in read speeds. How did you measure this?

Posting the same message several times in different forum is considered bad form, particularly as you posted in both Server and Parallel and now it is unclear which product you are asking about.

define a key column

lstsaur - you forgot to add "And Bob's your uncle"

Srini - I don't expect the auto-generated SQL to work for you, but it will show you the correct syntax on how to use the orchestrate column name.

Mea Culpa. UniSeq is the way to go

Can you monitor your scratch space while running this job? Also, if you halve the number of rows does the job run through (i.e. determine if your error is caused by data volumes)?

I'm not at a datastage machine and cannot remember the exact syntax to use, but I usually go to the database lookup stage and select the automatically generated SQL and use that syntax as the basis for my own SQL statement.

SEQ() should return a number so I'm not sure what you did...

In this type of case the best way is to declare the file as one long string and then use string functions in a transform stage to parse the elements. Your example doesn't show a variable number of columns, though.

r_arora - the APT_... value changes were a long shot but worth trying.
What are the data volumes for the two links and could you tell us what you are doing in the join?