|
| 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)) |
| ||||
//* |
| EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT,STEP02) | |||
//STEP03 | |||||
//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 | INTEGER | NOT NULL, | |
| ( QUERYNO | ||
| 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, |
174 | DB2 Manager User Guide |
| |
| StorageTek Proprietary |
|