StorageTek 312564001 User Manual
DB2 Manager User Guide
77
StorageTek
Proprietary
FIELD13 TIMESTAMP ,
OTDBIND CHAR(1) DEFAULT '0'
)
IN OTDBSYST.TAB1TS
EDITPROC OTDBP300;
•
For existing non-partitioned tables, a new partitioning index to the new
table must be created, as follows:
table must be created, as follows:
CREATE INDEX dbname.indexname
ON dbname.tabname
(
OTDBIND ASC
)
CLUSTER
(PART 1 VALUES('0'),
PART 2 VALUES('1'))
....
• For existing partitioned tables, the definition of the existing partitioning
index should be copied with the following modifications:
CREATE INDEX dbname.indexname
ON dbname.tabname
(
OTDBIND ASC,
field1
ASC/DESC,
........,
fieldn
ASC/DESC
)
CLUSTER
(PART 1 VALUES(‘0’,a,...,b)
PART n VALUES (‘0’,c,...,d)
PART n+1 VALUES (‘1’,y,...,z)) ...
where:
field1 is the first column in the existing clustering index
fieldn is the last column in the existing clustering index
n is the number of partitions defined in the existing clustering
index
‘a’ ... ‘b’ are the values of columns field1 to fieldn used to define partition
1 in the existing clustering index
‘c’ ... ‘d’ are the value of columns field1 to fieldn used to define partition n
in the existing clustering index
‘y’ ... ‘z’ are the lowest possible values for columns field1 to fieldn
• All other existing indexes should be copied without modification to index
the new table.