Partitions on source database

sathyanveshi · Post by **sathyanveshi** » Wed Dec 15, 2004 9:02 am

Hi,

I forgot to ask this question in my previous post.

Do we need a partitioned database as the source to use Parallel Extender?

Cheers,
Mohan

ray.wurlod · Post by **ray.wurlod** » Wed Dec 15, 2004 2:41 pm

No. For a non-partitioned database DataStage simply opens multiple cursors. If the database is capable of parallel execution, this can be used to some advantage.

mandyli · Post by **mandyli** » Sat Dec 18, 2004 11:48 pm

Hi

yes added ray stmt.. if daytabase partitioned we will get some good performance b'cus we used DB2 databae with partitioned table. in the datastage we used DB2 partition it will give good performance.

Thanks
Man