StorageTek 312564001 manual Otdbind ASC Cluster

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:

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

nis 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.

DB2 Manager User Guide	77
StorageTek Proprietary