- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
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.
- How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
- How to create a DB2 storage group STG1 with volume VOL1.
- How to create a DB2 database DBSET1 in the storage group STG1?
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
- Give the panel command to start a specific tablespace within a DB2 database.
- Updating and sampling of catalog statistics for DB2 tablespace
- How to create a DB2 bufferpool with pagesize 4096?
- How to monitor temporary tablespace usage in Oracle?
- How to create a new local group using PowerShell?
- How to create the Azure Storage context using PowerShell?
- How to add volume VOL34 and remove volume VOL29 from storage group STG1?
- How to create a group column in an R data frame?
- How to create a scatterplot with colors as group in R?
- How to create a "button group" with CSS?