Benchmark for DB2/UDB Enterprise Stage
Posted: Fri Jun 08, 2007 3:19 am
Hi all,
We have a requireent to load about 60-70 million of records per day.Currently we are using OPTILOAD tool for this.Now we are considering to load it using Data Stage through DB2/UDB Enterprise stage.So just wanted to know about the fesability of this or if there are any benhmarks laid by IBM on how many records can be loaded per second using this stage.Currently OPTILOAD loads 2000 records/second.
thanks in advance.
We have a requireent to load about 60-70 million of records per day.Currently we are using OPTILOAD tool for this.Now we are considering to load it using Data Stage through DB2/UDB Enterprise stage.So just wanted to know about the fesability of this or if there are any benhmarks laid by IBM on how many records can be loaded per second using this stage.Currently OPTILOAD loads 2000 records/second.
thanks in advance.