--**********************************************************************00010000 --* MEMBER NAME: CRE8DB *00020000 --* *00030000 --* DESCRIPTION: CEJCO CLASS DATABASE SET-UP *00040000 --* *00050000 --* EDIT AND MODIFY AS NECESSARY. THIS SET-UP ASSUMES A SEPARATE *00060000 --* DATABASE FOR THE INSTRUCTOR (00) AND ONE FOR EACH OF TWELVE *00070000 --* STUDENTS (01-12); ADD OR REMOVE AS NECESSARY. ALSO, ALL GRANTS *00080000 --* ARE TO PUBLIC; CHANGE TO AUTHID-SPECIFIC GRANTS, IF DESIRED. *00090000 --* *00100000 --* CHANGE ALL: CEJCOSG TO YOUR STOGROUP NAME *00110000 --* ?????? TO YOUR STOGROUP VOLUME(S) *00120000 --* !!!! TO YOUR STOGROUP VCAT *00130000 --* CEJCO00-12 TO YOUR DATABASE NAMES *00140000 --* BP0 TO YOUR BUFFER POOL *00150000 --**********************************************************************00160000 -- 00170000 CREATE STOGROUP CEJCOSG 00180000 VOLUMES (??????) 00190000 VCAT !!!!; 00200000 GRANT USE OF STOGROUP CEJCOSG TO PUBLIC; 00210000 COMMIT; 00220000 -- 00230000 CREATE DATABASE CEJCO00 00240000 STOGROUP CEJCOSG 00250000 BUFFERPOOL BP0; 00260000 CREATE DATABASE CEJCO01 00270000 STOGROUP CEJCOSG 00280000 BUFFERPOOL BP0; 00290000 CREATE DATABASE CEJCO02 00300000 STOGROUP CEJCOSG 00310000 BUFFERPOOL BP0; 00320000 CREATE DATABASE CEJCO03 00330000 STOGROUP CEJCOSG 00340000 BUFFERPOOL BP0; 00350000 CREATE DATABASE CEJCO04 00360000 STOGROUP CEJCOSG 00370000 BUFFERPOOL BP0; 00380000 CREATE DATABASE CEJCO05 00390000 STOGROUP CEJCOSG 00400000 BUFFERPOOL BP0; 00410000 CREATE DATABASE CEJCO06 00420000 STOGROUP CEJCOSG 00430000 BUFFERPOOL BP0; 00440000 CREATE DATABASE CEJCO07 00450000 STOGROUP CEJCOSG 00460000 BUFFERPOOL BP0; 00470000 CREATE DATABASE CEJCO08 00480000 STOGROUP CEJCOSG 00490000 BUFFERPOOL BP0; 00500000 CREATE DATABASE CEJCO09 00510000 STOGROUP CEJCOSG 00520000 BUFFERPOOL BP0; 00530000 CREATE DATABASE CEJCO10 00540000 STOGROUP CEJCOSG 00550000 BUFFERPOOL BP0; 00560000 CREATE DATABASE CEJCO11 00570000 STOGROUP CEJCOSG 00580000 BUFFERPOOL BP0; 00590000 CREATE DATABASE CEJCO12 00600000 STOGROUP CEJCOSG 00610000 BUFFERPOOL BP0; 00620000 GRANT DBADM ON DATABASE CEJCO00 TO PUBLIC; 00630000 GRANT DBADM ON DATABASE CEJCO01 TO PUBLIC; 00640000 GRANT DBADM ON DATABASE CEJCO02 TO PUBLIC; 00650000 GRANT DBADM ON DATABASE CEJCO03 TO PUBLIC; 00660000 GRANT DBADM ON DATABASE CEJCO04 TO PUBLIC; 00670000 GRANT DBADM ON DATABASE CEJCO05 TO PUBLIC; 00680000 GRANT DBADM ON DATABASE CEJCO06 TO PUBLIC; 00690000 GRANT DBADM ON DATABASE CEJCO07 TO PUBLIC; 00700000 GRANT DBADM ON DATABASE CEJCO08 TO PUBLIC; 00710000 GRANT DBADM ON DATABASE CEJCO09 TO PUBLIC; 00720000 GRANT DBADM ON DATABASE CEJCO10 TO PUBLIC; 00730000 GRANT DBADM ON DATABASE CEJCO11 TO PUBLIC; 00740000 GRANT DBADM ON DATABASE CEJCO12 TO PUBLIC; 00750000 COMMIT; 00760000 -- 00770000 CREATE TABLESPACE USERSPC1 00780000 IN CEJCO00 00790000 USING STOGROUP CEJCOSG 00800000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 00810000 SECQTY 16 -- 1 4-PAGE SEGMENT 00820000 ERASE NO 00830000 SEGSIZE 4 00840000 LOCKSIZE PAGE LOCKMAX SYSTEM 00850000 BUFFERPOOL BP0 00860000 CLOSE YES; 00870000 CREATE TABLESPACE USERSPC1 00880000 IN CEJCO01 00890000 USING STOGROUP CEJCOSG 00900000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 00910000 SECQTY 16 -- 1 4-PAGE SEGMENT 00920000 ERASE NO 00930000 SEGSIZE 4 00940000 LOCKSIZE PAGE LOCKMAX SYSTEM 00950000 BUFFERPOOL BP0 00960000 CLOSE YES; 00970000 CREATE TABLESPACE USERSPC1 00980000 IN CEJCO02 00990000 USING STOGROUP CEJCOSG 01000000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01010000 SECQTY 16 -- 1 4-PAGE SEGMENT 01020000 ERASE NO 01030000 SEGSIZE 4 01040000 LOCKSIZE PAGE LOCKMAX SYSTEM 01050000 BUFFERPOOL BP0 01060000 CLOSE YES; 01070000 CREATE TABLESPACE USERSPC1 01080000 IN CEJCO03 01090000 USING STOGROUP CEJCOSG 01100000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01110000 SECQTY 16 -- 1 4-PAGE SEGMENT 01120000 ERASE NO 01130000 SEGSIZE 4 01140000 LOCKSIZE PAGE LOCKMAX SYSTEM 01150000 BUFFERPOOL BP0 01160000 CLOSE YES; 01170000 CREATE TABLESPACE USERSPC1 01180000 IN CEJCO04 01190000 USING STOGROUP CEJCOSG 01200000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01210000 SECQTY 16 -- 1 4-PAGE SEGMENT 01220000 ERASE NO 01230000 SEGSIZE 4 01240000 LOCKSIZE PAGE LOCKMAX SYSTEM 01250000 BUFFERPOOL BP0 01260000 CLOSE YES; 01270000 CREATE TABLESPACE USERSPC1 01280000 IN CEJCO05 01290000 USING STOGROUP CEJCOSG 01300000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01310000 SECQTY 16 -- 1 4-PAGE SEGMENT 01320000 ERASE NO 01330000 SEGSIZE 4 01340000 LOCKSIZE PAGE LOCKMAX SYSTEM 01350000 BUFFERPOOL BP0 01360000 CLOSE YES; 01370000 CREATE TABLESPACE USERSPC1 01380000 IN CEJCO06 01390000 USING STOGROUP CEJCOSG 01400000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01410000 SECQTY 16 -- 1 4-PAGE SEGMENT 01420000 ERASE NO 01430000 SEGSIZE 4 01440000 LOCKSIZE PAGE LOCKMAX SYSTEM 01450000 BUFFERPOOL BP0 01460000 CLOSE YES; 01470000 CREATE TABLESPACE USERSPC1 01480000 IN CEJCO07 01490000 USING STOGROUP CEJCOSG 01500000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01510000 SECQTY 16 -- 1 4-PAGE SEGMENT 01520000 ERASE NO 01530000 SEGSIZE 4 01540000 LOCKSIZE PAGE LOCKMAX SYSTEM 01550000 BUFFERPOOL BP0 01560000 CLOSE YES; 01570000 CREATE TABLESPACE USERSPC1 01580000 IN CEJCO08 01590000 USING STOGROUP CEJCOSG 01600000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01610000 SECQTY 16 -- 1 4-PAGE SEGMENT 01620000 ERASE NO 01630000 SEGSIZE 4 01640000 LOCKSIZE PAGE LOCKMAX SYSTEM 01650000 BUFFERPOOL BP0 01660000 CLOSE YES; 01670000 CREATE TABLESPACE USERSPC1 01680000 IN CEJCO09 01690000 USING STOGROUP CEJCOSG 01700000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01710000 SECQTY 16 -- 1 4-PAGE SEGMENT 01720000 ERASE NO 01730000 SEGSIZE 4 01740000 LOCKSIZE PAGE LOCKMAX SYSTEM 01750000 BUFFERPOOL BP0 01760000 CLOSE YES; 01770000 CREATE TABLESPACE USERSPC1 01780000 IN CEJCO10 01790000 USING STOGROUP CEJCOSG 01800000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01810000 SECQTY 16 -- 1 4-PAGE SEGMENT 01820000 ERASE NO 01830000 SEGSIZE 4 01840000 LOCKSIZE PAGE LOCKMAX SYSTEM 01850000 BUFFERPOOL BP0 01860000 CLOSE YES; 01870000 CREATE TABLESPACE USERSPC1 01880000 IN CEJCO11 01890000 USING STOGROUP CEJCOSG 01900000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 01910000 SECQTY 16 -- 1 4-PAGE SEGMENT 01920000 ERASE NO 01930000 SEGSIZE 4 01940000 LOCKSIZE PAGE LOCKMAX SYSTEM 01950000 BUFFERPOOL BP0 01960000 CLOSE YES; 01970000 CREATE TABLESPACE USERSPC1 01980000 IN CEJCO12 01990000 USING STOGROUP CEJCOSG 02000000 PRIQTY 72 -- 4 PAGES FOR EACH OF 4 TABLES, PLUS 2 OVERHEAD 02010000 SECQTY 16 -- 1 4-PAGE SEGMENT 02020000 ERASE NO 02030000 SEGSIZE 4 02040000 LOCKSIZE PAGE LOCKMAX SYSTEM 02050000 BUFFERPOOL BP0 02060000 CLOSE YES; 02070000 COMMIT; 02080000