Creating Table Spaces

The following instructions assist you in creating table spaces:

Log into the IBM DB2 database as an administrator.

Note: Using bufferpools is optional depending on your site, but highly recommended by Lawson.
Lawson recommends that you specify a pagesize of 8K or higher for the BUFFERPOOL.
When you create a system temporary tablespace, Lawson recommends specifying a BUFFERPOOL of 32K or higher.

Use the CREATE BUFFERPOOL command to create bufferpools by running a script similar to the following:
```
CREATE BUFFERPOOL DATPOOL1 SIZE -1; 
(uses BUFFPAGES size in db cfg)
CREATE BUFFERPOOL IDXPOOL SIZE 40000;
```

Use the CREATE TABLESPACE command to create a table space by running a script similar to the following:

CREATE REGULAR TABLESPACE DATTS PAGESIZE 8 K
 MANAGED BY DATABASE USING
 ( FILE '/sqldata/db2v6/db2tc/instdb_datts1.dbf' 2560)
 EXTENTSIZE 16 OVERHEAD 18.6 PREFETCHSIZE 16
 TRANSFERRATE 1.0;

CREATE REGULAR TABLESPACE IDXTS PAGESIZE 4 K MANAGED
 BY DATABASE USING 
( FILE '/sqldata/db2v6/db2tc/inst1db_idxts1.dbf' 2560)
 EXTENTSIZE 16 OVERHEAD 18.6 PREFETCHSIZE 16
 TRANSFERRATE 1.0;

Use the ALTER TABLESPACE command:

ALTER TABLESPACE datts bufferpool datpool1
ALTER TABLESPACE idxts bufferpool idxpool