Give the panel command to start a specific tablespace within a DB2 database.

To start a specific tablespace within a DB2 database we can use below panel command.

START DATABASE (DSNDB01) SPACENAM(TABSPAC1)

Using the START DATABASE command, we can also start database and indexspace.

Mandalika

Published on 12-Sep-2020 16:22:25

• Related Questions & Answers
• How to start a DB2 database DSNDB001 using the command panel?
• What is the panel command to display all DB2 database components?
• Give and explain the panel command to display all the components of DB2 database DSNDB01 along with their status?
• How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
• Create a table within a Bootstrap Panel
• How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
• How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
• How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
• Updating and sampling of catalog statistics for DB2 tablespace
• How to execute a command and get the output of command within C++ using POSIX?
• How to provide & remove user access to/from DB2 object? Give the DB2 commands?
• Include list groups within any Bootstrap Panel
• How can a COBOL-DB2 program call a STORED PROCEDURE? Give an example.
• How to create a DB2 database DBSET1 in the storage group STG1?
• How to execute a command and get output of command within C++ using POSIX?