- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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 Tablespace in storage group STG1 and bufferpool BP01?
A table space is a logical entity in DB2 architecture. It is basically a collection of data files. A tablespace contains tables, indexes, objects, etc. To create a new tablespace we have to issue the following command.
CREATE TABLESPACE TABSPA1 IN DBSET1 USING STOGROUP STG1 PRIQTY 50 SECQTY 50 BUFFERPOOL BP03
The CREATE AND TABLESPACE are the reserved words which are followed by the name of tablespace we want to create. In this case it is TABSPA1.
IN is a reserved word which is followed by the name of the database in which we want to create this tablespace. The database is DBSET1 in this case.
USING STOGROUP are the reserved words which are accompanied by the name of the storage group to be used for this tablespace.
The PRIQTY and SECQTY are reserved words which describe the storage space in KB for primary and secondary allocation respectively.
The BUFFERPOOL parameter is used to give the name of bufferpool which has to be used for this tablespace.
- Related Articles
- 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 segmented tablespace TABSPAC2 in storage group STOGRP1?
- How to create a DB2 bufferpool with pagesize 4096?
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to add volume VOL34 and remove volume VOL29 from storage group STG1?
- How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
- Updating and sampling of catalog statistics for DB2 tablespace
- Give the panel command to start a specific tablespace within a DB2 database.
- How to monitor temporary tablespace usage in Oracle?
- How to create a "button group" with CSS?
- How to create the Azure Storage context using PowerShell?
- How to create an ALIAS TAB2 for DB2 table TAB1?
- How to create a vertical "button group" with CSS?
- How to create a new local group using PowerShell?
