Creating Table Spaces
The following instructions assist you in creating table spaces. Infor Lawson has these recommendations:
-
Specify a pagesize of 8K or higher for the BUFFERPOOL.
-
When you create a system temporary tablespace, specifying a BUFFERPOOL of 32K or higher.
-
Use SEGSIZE 32 because of the size of tables.
Note: When you create a system temporary
tablespace, Lawson recommends specifying a BUFFERPOOL of 32K or higher.
When you define table spaces, Lawson recommends that
you use segmented or partitioned table spaces for tables and that
you enforce row level locking. Execute the following SQL statement
to invoke these recommendations:
CREATE TABLESPACE
tablspc1 IN dbname SEGSIZE 32 BUFFERPOOL BP?
LOCKSIZE ROW USING STOGROUP tblstog1 PRIQTY 000000 SECQTY 00000 ;