Boppana

• May 11th, 2006

 

hi

     Regarding the database it varies and dependa upon teh project and for the second question ,inprocess is the process where teh server transfers only one row at a tiem to target and interprocess means that the server sends group of rows to the target table...these both are available at the tunables tab page of the administrator client component..

Daniel

• May 14th, 2006

 

In-process

You can improve the performance of most DataStage jobs by turning in-process row buffering on and recompiling the job. This allows connected active stages to pass data via buffers rather than row by row.

Note: You cannot use in-process row-buffering if your job uses COMMON blocks in transform functions to pass data between stages. This is not recommended practice, and it is advisable to redesign your job to use row buffering rather than COMMON blocks.

Inter-process

Use this if you are running server jobs on an SMP parallel system. This enables the job to run using a separate process for each active stage, which will run simultaneously on a separate processor.

Note: You cannot inter-process row-buffering if your job uses COMMON blocks in transform functions to pass data between stages. This is not recommended practice, and it is advisable to redesign your job to use row buffering rather than COMMON blocks.

vijaypatiln

 Profile Answers by vijaypatiln 

• Jul 28th, 2009

 

In process allows connected active stages to pass data via buffers, rather than row by row.



Inter process enables the job to run using a separate process for each active stage, which will run simultaneously on a separate processor.