StorageTek 312564001 manual 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))
//*		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