- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 Questions & Answers
- 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 add volume VOL34 and remove volume VOL29 from storage group STG1?
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- Updating and sampling of catalog statistics for DB2 tablespace
- How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
- 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 new local group using PowerShell?
- How to create the Azure Storage context using PowerShell?
- 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?