Partioning in DB2 Enterprise Stage , 4 node and 1 node
Posted: Sat Jun 26, 2004 2:34 am
All,
We have developed Parallel Jobs and we have used Hash Partion in the Jobs and for DB2 enterprise stage we have set "DB2" as partion method
Jobs are running fine with single node and when we are testing the same with 4 node we have problems
When we have changes the partion method as "SAME" on DB2 Enterprise the Jobs are working fine in 4 node .
Can anybody explain the reasons for this behavior and what are the pros & cons of using "DB2" or "SAME" as partion method
Thanks
Pani
We have developed Parallel Jobs and we have used Hash Partion in the Jobs and for DB2 enterprise stage we have set "DB2" as partion method
Jobs are running fine with single node and when we are testing the same with 4 node we have problems
When we have changes the partion method as "SAME" on DB2 Enterprise the Jobs are working fine in 4 node .
Can anybody explain the reasons for this behavior and what are the pros & cons of using "DB2" or "SAME" as partion method
Thanks
Pani