DSXchange

But are there drivers in DataDirect drivers for i-series/AS/400 in IBM Information Server list? I dont think so.

This time same issue, it didnt show up in the web console, but it showed up in XMETALOCK table.

Okay will try to sort at the OS level and check the Processing in Job.

running from 4 hours.

Still Running and no rows on the Sort Output link Yet, running from 3 hours.

Here is the settings i am using. Rows coming in 1.2 million rows Max Rows in VM = 49000 Max Open Files = 20 Temp File = explicit Full Path mentioned(i can also see files getting created therr) tracing level = 0 Stable sort = no esc char= \ column seperator = , Sort spec = Col1 ASC,COl2 ASC,Col3 ASC ...

Okay the input link to the SORT stage has processed all the rows but the output link doesnt show any rows processed from a long time, does this mean it is not configured correctly????

Got it, it was the metadata error, with more quotes in other columns,
issue resolved, running the job again with Sort and Agg....post the results soon.

Job failed with the error saying "Required column missing"

Okay got it, will post results soon.

Okay i will add the Sort Stage before AGG sort on the Key columns and in Agg stage i have two tabs on the input tab Sort and Sort Order , i wud update them with number and 'ignore' respectively and check the KEY box for all the Keys, is that correct settings?

No changes to the Job, it has 800k rows and its been running from 4 hrs....!

PS: it has one SUM function and 4 MAX functions.

Increased the tablesize to 32768 while the job is running, will post the results soon.

Changes effected by this command are stored in the RT_CONFIGnnn table for the job. They are lost if the job is re-compiled >>>> Can i resize the table when the job is running or i need to resize and then run the job without compiling???

Okay Thanks Ray and chulett, i will keep my fingers crossed.