Table spaces for sample application data

The table spaces that are not explicitly defined are created implicitly in the DSN8D12A 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 DSN8S12D
  IN DSN8D12A
  USING STOGROUP DSN8G120
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;
 
CREATE TABLESPACE DSN8S12E
  IN DSN8D12A
  USING STOGROUP DSN8G120
        PRIQTY 20
        SECQTY 20
        ERASE NO
  NUMPARTS 4
    (PART 1 USING STOGROUP DSN8G120
                  PRIQTY 12
                  SECQTY 12,
     PART 3 USING STOGROUP DSN8G120
                  PRIQTY 12
                  SECQTY 12)
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  COMPRESS YES
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S12B
  IN DSN8D12L
  USING STOGROUP DSN8G120
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE
  LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE LOB TABLESPACE DSN8S12M
  IN DSN8D12L
  LOG NO;
 
CREATE LOB TABLESPACE DSN8S12L
  IN DSN8D12L
  LOG NO;
 
CREATE LOB TABLESPACE DSN8S12N
  IN DSN8D12L
  LOG NO;

CREATE TABLESPACE DSN8S12C
  IN DSN8D12P
  USING STOGROUP DSN8G120
        PRIQTY 160
        SECQTY 80
  SEGSIZE 4
  LOCKSIZE TABLE
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;
 
CREATE TABLESPACE DSN8S12P
  IN DSN8D12A
  USING STOGROUP DSN8G120
        PRIQTY 160
        SECQTY 80
  SEGSIZE 4
  LOCKSIZE ROW
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S12R
  IN DSN8D12A
  USING STOGROUP DSN8G120
        PRIQTY 20
        SECQTY 20
        ERASE NO
  LOCKSIZE PAGE LOCKMAX SYSTEM
  BUFFERPOOL BP0
  CLOSE NO
  CCSID EBCDIC;

CREATE TABLESPACE DSN8S12S
   IN DSN8D12A
   USING STOGROUP DSN8G120
             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.