Hi All,

Im using DB2 ver 7 for OS/390.
I haven't got the time to test this although I really intend to but could somebody tell me if there's a rule against this scenario.

Table A have have a primary key defined in col1. I intend to partition this table. Is it ok to partitioned it according to col2 although the primary key is defined in col1.

Logically i don't see any problem but can someone tell if there's a rule against it?

thanks!

You normally won't use your primary key as partitioning key (although you can). It's OK to use another column. Remember: you only can have one cluster index per table.
Your decision should be based on your knowledge of the data (how is my data distributed, why should some pieces of information stay together in one partition, etc.).

HTH

Thanks! Actually I already did a test and it works as you have said. And thanks for the reminder.

starra

Partitioning on OS/390 is quite different than on other DB2 platforms, since they use range partitioning, instead of hash partitioning. So it is more likely that the primary key would be used as the partitioning index.

thanks! I appreciate the input!