how to get max performance using upsert mode?
Posted: Mon Jun 17, 2013 5:16 pm
Hi there
I developed good number of jobs and I Iam happy the way how I developed the jobs. But when I develop a job using "upsert" mode, I am not having the full satisfaction. Jobs are running 1000+/- rows per sec.
Once I raised a PMR with IBM in this relates. But the discussion lead the topic in to performance and end up with no result.
I do agree, this is related to performance, but I wish to know is there is any thumb rule do we need to follow in Datastage point of view?
Or
Is there is any other clever approach to achive this in a very good manner?
Please dont reply the factor of Network, Hardware, DB, No of records, Index, Partition etc.
I developed good number of jobs and I Iam happy the way how I developed the jobs. But when I develop a job using "upsert" mode, I am not having the full satisfaction. Jobs are running 1000+/- rows per sec.
Once I raised a PMR with IBM in this relates. But the discussion lead the topic in to performance and end up with no result.
I do agree, this is related to performance, but I wish to know is there is any thumb rule do we need to follow in Datastage point of view?
Or
Is there is any other clever approach to achive this in a very good manner?
Please dont reply the factor of Network, Hardware, DB, No of records, Index, Partition etc.