Appendix A. DDL for the DB2CERT Database
The following DDL represents the statements needed to create DB2 objects for the DB2CERT database: stogroup, database, segmented table space, partitioned table space, LOB table space, tables, indexes, auxiliary table, auxiliary index, and user-defined types:
-- CREATE STOGROUPCREATE STOGROUP CERTSTGVOLUME(*) VCAT DB2USER1;-- CREATE DATABASECREATE DATABASE DB2CERTSTOGROUP CERTSTGBUFFERPOOL BP7INDEXBP BP8;-- CREATE SEGMENTED TABLESPACECREATE TABLESPACE CERTTSIN DB2CERTUSING STOGROUP CERTSTG PRIQTY 52 SECQTY 20 ERASE NO LOCKSIZE PAGE BUFFERPOOL BP6 CLOSE YES SEGSIZE 32;-- CREATE PARTITIONED TABLESPACE WITH 2 PARTITIONSCREATE TABLESPACE CERTTSPTIN DB2CERTUSING STOGROUP CERTSTG PRIQTY 100 SECQTY 120 ...
Get DB2® for z/OS® Version 8 DBA Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
