Unanswered: How to create Partitioned Tables in DB2 LUW
Can anybody give me Syntax for creating partitioned TABLES in LUW DB2?
I have created the table space USERSPACE1 as below, to create Partitioned tables in USERSPACE1
CREATE REGULAR TABLESPACE "USERSPACE1"
IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
PAGESIZE 4 K
MANAGED BY SYSTEM
USING ( '/db/db2inst2/SAMPLE/db2inst2/NODE0000/SQL00001/SQLT0002.0')
Basically I would like to know how to know how to divide data across multiple data partitions according to values in the table partitioning key columns for the table