My question is probably too simple for most of the people here, but I really don't know the right way to make a table partitions. I've tried the PARTITIONING KEY when CREATE TABLE, but as the result, I only found that the table only has 1 partition which is numbered 0
Could I make multiple table partitions in LUW's DB2 v8.2 ? I know that there's Range partitioning, etc. at DB2 Viper though, but I'm currently using DB2 v8.2, so if anyone know the way, please help me
Partitioning in V8 is using DPF. In V9 the syntax for setting up DPF partitioning is different. The PARTITIONING KEY in V8 is using DPF and if you only have one partition, then you get what you are getting. Prior to V9, you have to do what is called "union all views" to partition a table the way you want. V9 and on, you can do it directly.