Simple Tablespace
Simple Tablespace
Summary
Table space will be represented as pages and data will be stored in the form of pages. More than one table can be stored in the table space. Page contains all the table rows in which order they inserted into the table.
The rows from different tables can be stored in one page. There is no order defined to store the data on the pages. CREATE TABLESPACE is used to create the table space.
Syntax -
CREATE TABLESPACE tablespace-name
IN database-name
USING STOGROUP stored-group-name
PRIQTY priqty-value
SECQTY secqty-value
ERASE {NO/YES}
FREEPAGE freepage-value
PCTFREE pctfree-value
COMPRESS {YES/NO }
BUFFERPOOL bufferpool-value
LOCKSIZE {ANY/locksize-value}
LOCKMAX {SYSTEM/lockmax-value}
CLOSE {YES/NO}
The above parameters are explained in table space concept and find the page here .
Example -
Below example is to create MFTHTS table space in MTH1DB under the storage group MFTCHP
CREATE TABLESPACE MFTHTS
IN MTH1DB
USING STOGROUP MFTCHP
PRIQTY 250
SECQTY 100
ERASE NO
FREEPAGE 10
PCTFREE 10
COMPRESS NO
BUFFERPOOL MF
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES