StorageTek 312564001 manual DB2 Manager User Guide 175 StorageTek Proprietary

MIXOPSEQ		SMALLINT	NOT NULL WITH DEFAULT,
VERSION		VARCHAR(64)	NOT NULL WITH DEFAULT,
COLLID		CHAR(18)	NOT NULL WITH DEFAULT,
ACCESS_DEGREE		SMALLINT,
ACCESS_PGROUP_ID		SMALLINT,
JOIN_DEGREE		SMALLINT,
JOIN_PGROUP_ID		SMALLINT,
SORTC_PGROUP_ID		SMALLINT,
SORTN_PGROUP_ID		SMALLINT,
PARALLELISM_MODE		CHAR(1),
MERGE_JOIN_COLS		SMALLINT,
CORRELATION_NAME		CHAR(18),	NOT NULL WITH DEFAULT,
PAGE_RANGE		CHAR(1)
JOIN_TYPE		CHAR(1)	NOT NULL WITH DEFAULT,
GROUP_MEMBER		CHAR(8)	NOT NULL WITH DEFAULT,
IBM_SERVICE_DATA		VARCHAR(254) NOT NULL WITH DEFAULT,
WHEN_OPTIMIZE		CHAR(1)	NOT NULL WITH DEFAULT,
QBLOCK_TYPE		CHAR(6)	NOT NULL WITH DEFAULT,
BIND_TIME		TIMESTAMP	NOT NULL WITH DEFAULT,
OPTHINT		CHAR(8)	NOT NULL WITH DEFAULT,
HINT_USED		CHAR(8)	NOT NULL WITH DEFAULT,
PRIMARY_ACCESSTYPE CHAR(1)			NOT NULL WITH DEFAULT
)
IN LCDDB2.LCDDB2TS;
CREATE TABLE LCDDB2.REGISTRY		VARCHAR(27)	NOT NULL,
( TABNAME
LCDDBID		CHAR(4)	NOT NULL
)
IN LCDDB2.LCDDB2TS;
CREATE UNIQUE INDEX LCDDB2.REGIX1
ON LCDDB2.REGISTRY
(	ASC
TABNAME
)	VCAT DSN610		<===
USING
CLOSE	NO
BUFFERPOOL BP1
PCTFREE	10;
CREATE UNIQUE INDEX LCDDB2.REGIX2
ON LCDDB2.REGISTRY
(	ASC
LCDDBID
)	VCAT DSN610		<===
USING
CLOSE	NO
BUFFERPOOL BP1
PCTFREE	10;
COMMIT;
GRANT CREATETAB
ON DATABASE LCDDB2
TO PUBLIC;

GRANT USE OF TABLESPACE LCDDB2.LCDDB2TS

TO PUBLIC;

GRANT SELECT, DELETE, INSERT, UPDATE

ON TABLE LCDDB2.PLAN_TABLE

TO PUBLIC;

COMMIT;

DB2 Manager User Guide	175
StorageTek Proprietary