Chapter C. DB2CERT Database DDL

The following is the DDL that will create the following DB2 objects for the DB2CERT database:

  • Stogroup

  • Database

  • Segmented Tablespace

  • Partitioned Tablespace

  • LOB Tablespace

  • Tables

  • Indexes

  • Auxiliary Table

  • Auxiliary Index

  • User-Defined Types

 -- Create Storage Group CERTSTG CREATE STOGROUP CERTSTG VOLUME(*) VCAT DB2USER1; -- Create Database DB2CERT CREATE DATABASE DB2CERT STOGROUP CERTSTG BUFFERPOOL BP7 INDEXBP BP8; -- Create Segmented Table Space CERTTS CREATE TABLESPACE CERTTS IN DB2CERT USING STOGROUP CERTSTG PRIQTY 52 SECQTY 20 ERASE NO LOCKSIZE PAGE BUFFERPOOL BP6 CLOSE YES SEGSIZE 32; -- Create Partitioned Table Space CERTTSPT CREATE TABLESPACE CERTTSPT IN DB2CERT USING STOGROUP CERTSTG PRIQTY 100 SECQTY 120 ERASE NO NUMPARTS ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application 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.

Start your free trial