Search found 2 matches

by hi.prabhunami
Tue Sep 17, 2013 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash Partition Query
Replies: 1
Views: 2543

Hash Partition Query

Hi, We have a table which is partitioned on column X. We are doing a partition based unload for this table using 10 DB2 stages for faster extracts and then merging all the data using a funnel stage. I wanted to check if in the funnel stage we specify hash partitioning would that put an additional ov...
by hi.prabhunami
Tue Sep 17, 2013 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WITH UR in SELECT/Isolation level in DB2 connector priority
Replies: 3
Views: 4389

Re: WITH UR in SELECT/Isolation level in DB2 connector prior

I have generally seen in the all client projects that I am working on that.. the isolation level in any DB2 connector stage is always defined as Cursor stabilty however the user defined query always as select statment "WITH UR". Incase the isolation level in the user defined query will alw...