Filter
Top Products
174 DB2 Manager User Guide
StorageTek Proprietary
CYLINDERS(1 1) -
UNIQUE ) -
DATA -
(NAME(DSN610.DSNDBD.LCDDB2.REGIX1.I0001.A001)) <===
DEFINE CLUSTER -
(NAME(DSN610.DSNDBC.LCDDB2.REGIX2.I0001.A001) - <===
LINEAR -
SHAREOPTIONS(3 3) -
VOLUMES(vvvvvv) - <===
CYLINDERS(1 1) -
UNIQUE ) -
DATA -
(NAME(DSN610.DSNDBD.LCDDB2.REGIX2.I0001.A001)) <===
//*
//STEP03 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT,STEP02)
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2) <===
RUN PROGRAM(DSNTIAD) PLAN(DSNTIAnn) - <===
LIB('DB2.runtime.library') <===
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
CREATE DATABASE LCDDB2;
COMMIT;
CREATE TABLESPACE LCDDB2TS
IN LCDDB2
USING VCAT DSN610 <===
LOCKSIZE ANY
CLOSE NO
SEGSIZE 64
BUFFERPOOL BP0;
COMMIT;
CREATE TABLE LCDDB2.PLAN_TABLE
( QUERYNO INTEGER NOT NULL,
QBLOCKNO SMALLINT NOT NULL,
APPLNAME CHAR(8) NOT NULL,
PROGNAME CHAR(8) NOT NULL,
PLANNO SMALLINT NOT NULL,
METHOD SMALLINT NOT NULL,
CREATOR CHAR(8) NOT NULL,
TNAME CHAR(18) NOT NULL,
TABNO SMALLINT NOT NULL,
ACCESSTYPE CHAR(2) NOT NULL,
MATCHCOLS SMALLINT NOT NULL,
ACCESSCREATOR CHAR(8) NOT NULL,
ACCESSNAME CHAR(18) NOT NULL,
INDEXONLY CHAR(1) NOT NULL,
SORTN_UNIQ CHAR(1) NOT NULL,
SORTN_JOIN CHAR(1) NOT NULL,
SORTN_ORDERBY CHAR(1) NOT NULL,
SORTN_GROUPBY CHAR(1) NOT NULL,
SORTC_UNIQ CHAR(1) NOT NULL,
SORTC_JOIN CHAR(1) NOT NULL,
SORTC_ORDERBY CHAR(1) NOT NULL,
SORTC_GROUPBY CHAR(1) NOT NULL,
TSLOCKMODE CHAR(3) NOT NULL,
TIMESTAMP CHAR(16) NOT NULL,
REMARKS VARCHAR(254) NOT NULL,
PREFETCH CHAR(1) NOT NULL WITH DEFAULT,
COLUMN_FN_EVAL CHAR(1) NOT NULL WITH DEFAULT,