Hi

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')
EXTENTSIZE 32
BUFFERPOOL "IBMDEFAULTBP"
TRANSFERRATE 0.18;

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

Thanks in Anticipation
Neha

you may find the following article helpful:
Introducing DB2 9, Part 2: Table partitioning in DB2 9