# How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?

DB2DatabaseBig Data Analytics

A segmented table space is divided in multiple segments. A segment is defined as a contiguous set of fixed number of pages. This fixed number is defined during the table space definition using the SEGSIZE parameter. The SEGSIZE serves multiple purposes - It defines the tablespace as segmented and also defines the size of the segment.

In a segmented tablespace, the rows of a table are stored in one or more segments and a particular segment can only have rows from one table.

The segmented tablespace can be created by using the CREATE TABLESPACE command with SEQSIZE parameter as below.

CREATE TABLESPACE TABSPA1
IN DBSPAC1
USING STOGROUP STG1
PRIQTY 50
SECQTY 50
BUFFERPOOL BP02
ERASE NO
SEQSIZE 4

The SEQSIZE parameter 4 indicates here that one segment in this tablespace will have 4 pages.

Published on 12-Sep-2020 14:29:19