Table spaces for sample application data

The table spaces that are not explicitly defined are created implicitly in the DSN8D13A database, using the default space attributes.

Begin general-use programming interface information.

The following SQL statements explicitly define a series of table spaces.

CREATE TABLESPACE DSN8S13D
  IN DSN8D13A
  USING STOGROUP DSN8G130
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;
 
CREATE TABLESPACE DSN8S13E
  IN DSN8D13A
  USING STOGROUP DSN8G130
        PRIQTY 20
        SECQTY 20
        ERASE NO
  NUMPARTS 4
    (PART 1 USING STOGROUP DSN8G130
                  PRIQTY 12
                  SECQTY 12,
     PART 3 USING STOGROUP DSN8G130
                  PRIQTY 12
                  SECQTY 12)
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  COMPRESS YES
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S13B
  IN DSN8D13L
  USING STOGROUP DSN8G130
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE
  LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE LOB TABLESPACE DSN8S13M
  IN DSN8D13L
  LOG NO;
 
CREATE LOB TABLESPACE DSN8S13L
  IN DSN8D13L
  LOG NO;
 
CREATE LOB TABLESPACE DSN8S13N
  IN DSN8D13L
  LOG NO;

CREATE TABLESPACE DSN8S13C
  IN DSN8D13P
  USING STOGROUP DSN8G130
        PRIQTY 160
        SECQTY 80
  SEGSIZE 4
  LOCKSIZE TABLE
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;
 
CREATE TABLESPACE DSN8S13P
  IN DSN8D13A
  USING STOGROUP DSN8G130
        PRIQTY 160
        SECQTY 80
  SEGSIZE 4
  LOCKSIZE ROW
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S13R
  IN DSN8D13A
  USING STOGROUP DSN8G130
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S13S
   IN DSN8D13A
   USING STOGROUP DSN8G130
             PRIQTY 20
             SECQTY 20
             ERASE NO
   LOCKSIZE PAGE LOCKMAX SYSTEM
   BUFFERPOOL BP0
   CLOSE NO
   CCSID EBCDIC;

CREATE TABLESPACE DSN8S81Q 
   IN DSN8D81P
   USING STOGROUP DSN8G810 
             PRIQTY 160
             SECQTY 80
   SEGSIZE 4
   LOCKSIZE PAGE
   BUFFERPOOL BP0
   CLOSE NO
   CCSID EBCDIC;

CREATE TABLESPACE DSN8S81U
   IN DSN8D81E
   USING STOGROUP DSN8G810
             PRIQTY 5
             SECQTY 5
             ERASE NO
   LOCKSIZE PAGE LOCKMAX SYSTEM
   BUFFERPOOL BP0
   CLOSE NO
   CCSID UNICODE;

End general-use programming interface information.