Partion Table option in DB2 Enterprise Stage
Posted: 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.
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.