- 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 database DBSET1 in the storage group STG1?
A database is a structured collection of data which can be organized, maintained and updated easily. There can be multiple databases in a DB2 installation. The DB2 database can be created by giving the name of the database, storage group and bufferpool, as below−
CREATE DATABASE DBSET1 STOGROUP (STG1) BUFFERPOOL BP3;
The CREATE and DATABASE are the reserved words which are followed by the name of the database we want to create. The STOGROUP parameter should be given with the name of the storage group and finally BUFFERPOOL parameter followed by the name of bufferpool.
Updated on 11-Sep-2020 12:51:47
- Related Questions & Answers
- How to create a DB2 storage group STG1 with volume VOL1.
- How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
- How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
- How to add volume VOL34 and remove volume VOL29 from storage group STG1?
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to start a DB2 database DSNDB001 using the command panel?
- Get the storage size of a database in MongoDB?
- Access to the Group Database in Python
- How to view storage configuration of Oracle database?
- How to create the Azure Storage context using PowerShell?
- How to save database in local storage of android webview?
- How to create a DB2 bufferpool with pagesize 4096?
- Give the panel command to start a specific tablespace within a DB2 database.
- What are the ways to calculate DB2 database size using DB2 utility and other methods?
- How to create a new database in MongoDB?
Advertisements