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.

raja
Updated on 12-Sep-2020 14:29:54

Advertisements