The performance of IPC stage

loveojha2 · Post by **loveojha2** » Thu Oct 13, 2005 10:38 pm

Hi All,
I have a question reated with the performance gains from IPC stages.
We are using IPC stages at following places:
1. After the Source stages.
2. Before the target stages.
3. Prior to Hashed file stages (at the time of hashed file writing/creation).
4. Prior to transformer and after the hashed file stages in case of lookups.

My question is what are the criterias in deciding where to use an IPC stage and where to not. (Apart from keeping it in between two passive stages).

Thanx in advance.

akhiln · Post by **akhiln** » Thu Oct 13, 2005 11:40 pm

IPC provides a communication channel between DataStage processes running simultaneously in the same job. It allows you to design jobs that run on SMP systems with great performance benefits. One can use them to speed up data transfer between two data sources(eg: a source and target).

him121 · Post by **him121** » Fri Oct 14, 2005 2:14 am

IPC Stage will use to allocate memory block while transfering data (rows) Block by Block between Active->Active or Active->Passive Stages.
this will give better performace to diff processes to read and write data.

Himanshu