StorageTek 312564001 manual Otdbdef

OTDBDEF

Member OTDBDEF creates the DB2 Manager system database.

//OTDBDEF		JOB
//*	DB2 Manager system database creation job.
//*
//*	Change history:
//*
//*	GW 19-Mar-03 V1.1 created
//*	GW 02-Apr-04 V1.1 re-branded
//*	This job creates the database manager system database. It
//*
//*	includes steps to allocate files, define the database and
//*	grant authorities for database access.
//*	Before submitting the job, review each line marked with
//*
//*	with "<===" and modify as appropriate for execution at
//*	your installation.
//*		EXEC PGM=IKJEFT01
//STEP01
//SYSTSPRT DD SYSOUT=*
//SYSTSIN		DD *		<===
DSN	SYSTEM(DB2)
RUN	PROGRAM(DSNTIAD) PLAN(DSNTIAnn) -			<===
	LIB('DB2.runtime.library')			<===
//SYSPRINT DD SYSOUT=*
//SYSIN		DD *
DROP		DATABASE LCDDB2;
COMMIT;
//*		EXEC PGM=IDCAMS
//STEP02
//SYSPRINT DD SYSOUT=*
//SYSIN		DD *	-
DELETE				<===
DSN610.DSNDBC.LCDDB2.LCDDB2TS.I0001.A001			-
	CLUSTER		-
DELETE				<===
DSN610.DSNDBC.LCDDB2.REGIX1.I0001.A001			-
	CLUSTER		-
DELETE				<===
DSN610.DSNDBC.LCDDB2.REGIX2.I0001.A001			-
	CLUSTER
SET LASTCC=0
SET MAXCC=0			-
DEFINE CLUSTER				<===
(NAME(DSN610.DSNDBC.LCDDB2.LCDDB2TS.I0001.A001)			-
		LINEAR	-
		SHAREOPTIONS(3 3)	-	<===
		VOLUMES(vvvvvv)	-
		CYLINDERS(1 1)	-
		UNIQUE )	-
	DATA		-	<===
(NAME(DSN610.DSNDBD.LCDDB2.LCDDB2TS.I0001.A001))			-
DEFINE CLUSTER				<===
(NAME(DSN610.DSNDBC.LCDDB2.REGIX1.I0001.A001)			-
		LINEAR	-
		SHAREOPTIONS(3 3)	-	<===
		VOLUMES(vvvvvv)	-
		DB2 Manager User Guide		173
		StorageTek Proprietary