Page 1 of 1

Partitions on source database

Posted: Wed Dec 15, 2004 9:02 am
by sathyanveshi
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

Posted: Wed Dec 15, 2004 2:41 pm
by ray.wurlod
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.

Posted: Sat Dec 18, 2004 11:48 pm
by mandyli
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