Search found 2 matches
- 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...
- 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...