Partion Table option in DB2 Enterprise Stage

jayantthakore · Post by **jayantthakore** » Mon Jun 22, 2009 4:17 pm

Hi,

I have a query with join 3 Tables(eg : A,B,C).I defied it as User Defined Qyery in the Db2 Enterprise Stage.The job run slow as the default method of "User Defied Query" is sequential.I am trying to use the PARTION Table option to make this qury work in parallel mode.I provided value

Partion Table = A,B,C

The job aborted.

Can you please let me know what value should I give to this parameter.
Is there any other way to make this query work in parallel mode.

ArndW · Post by **ArndW** » Tue Jun 23, 2009 2:07 am

Is there any chance of you telling us what the error message was?

bobyon · Post by **bobyon** » Tue Jun 23, 2009 5:38 am

If I understand your question correctly, and I may not, what is provided as the partition table is the name of a table that you want your data to be partitioned like. i.e if table A is partitioned on col X and you want your data coming out of the DB2 stage partitioned on col X then, provide table A as the partition table.