DSXchange

hi, I got another error, it says : sort2 failed and Abnormal termination of stage DB2_INVOICE_LINE_ITEM_RPT_partition1.. detected i am doing sort in all three aggregators : inv_id a and i also add ascending sorting order for inv_id in all three aggregators but i still get this error. sort 2 failed. ...

hi, i m not using the sorting at all. My job looks like this: db2 then a partitioner then three transformers and then three aggregators and then link collector and then mainframe database. Now i m getting this error: ds_ipcgetnext - timeout waiting for mutex There are like 1.7 million records. Can i...

no, i am not. If this is what i m doing wrong. I will do that. I thought that sort is to increase the performance. thanks shivan Hi, You mean you are using them before and after the aggregator? And are you sorting the data before passing to aggreVator! hi, i am getting this error : Abnormal terminat...

hi, i am getting this error : Abnormal termination of stage CopyOfDB2_INVOICE_LINE_ITEM_RPT_part..Aggregator3 detected I am using link_partitioner and partioner_collector. thanks shivan Hi Shivan, Use a SORT stage before the aggregator and sort the columns. Also make sure you mention the sort order ...

thanks Kumar, i will check with a DBA. the other problem i have is performance , the number of rows are like 800 per sec. Is there any way i can make them more. thanks shivan hi shivan, Looks like you connection timed out, I believe your source is returning more data and it takes time read all the r...

I run the job again. Now i got this error:
CLI0108E Communication link failure. SQLSTATE=40003

thanks

shivan wrote:Inter process is already disabled. Settings is to default.

thanks
shivan

Sainath.Srinivasan wrote:Disable inter process comm and retry.

Inter process is already disabled. Settings is to default.

thanks
shivan

Sainath.Srinivasan wrote:Disable inter process comm and retry.

Hi, thanks for replying. I am trying to get the data from db2 and putting into mainframe. The number of records are more than 1 million. It works fine while going from db2 to transformer and then to aggregate processor. But at the time of writing to mainframe. It gives an error. I was thinking of so...

Hi,
I am getting this error.
.INPUT_TO_AGGR: ds_ipcput() - timeout waiting for mutex
I really appreciate if someone telles me how to solve this problem.

thanks
shivan