Simple Tablespace


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