Filter
Top Products
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),
PAGE_RANGE CHAR(1) NOT NULL WITH DEFAULT,
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
( TABNAME VARCHAR(27) NOT NULL,
LCDDBID CHAR(4) NOT NULL
)
IN LCDDB2.LCDDB2TS;
CREATE UNIQUE INDEX LCDDB2.REGIX1
ON LCDDB2.REGISTRY
(
TABNAME ASC
)
USING VCAT DSN610 <===
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
CREATE UNIQUE INDEX LCDDB2.REGIX2
ON LCDDB2.REGISTRY
(
LCDDBID ASC
)
USING VCAT DSN610 <===
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;