O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required