- 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
What is the panel command to display all DB2 database components?
Problem: Give and explain the panel command to display all the components of DB2 database DSNDB01 along with their status.
Solution
A DB2 is a relational database which can be visualized to have both physical as well as logical structures. The physical structure contains components like log files, bufferpools, control files etc. On the other logical structure contains components like tablespace, indexspace, tables, views, packages, plans, etc.
The components of physical structure have restricted access and only DBAs can access those files. However, it is possible for us to view components of logical structure using any of the below 2 options.
- Using DB2 administration facility provided with DB2 z/OS installation. In this utility, using a database name we can find out all the objects like tables, packages, plans, etc residing inside this database.
- The more convenient way to find out components of logical structure within a DB2 database is panel command. The following panel command will help us to achieve this.
DIS DB(DSNDB01)
Here, DI indicates DISPLAY which is followed by the DB identifier indicating database. Finally, the database name has to be given in braces.
- Related Questions & Answers
- Give and explain the panel command to display all the components of DB2 database DSNDB01 along with their status?
- How to start a DB2 database DSNDB001 using the command panel?
- 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?
- Drop all indexes from all the collections in a MongoDB database using the command line?
- What is the MySQL query to display the number of tables in a database?
- Connecting to MySQL database from the command line?
- Bootstrap package consists of what all components?
- What is MySQL CREATE command? How can we create both database and table with this command?
- What is Principal Components Analysis?
- Display all tables inside a MySQL database using Java?
- Impact of database downtime on the COBOL-DB2 program
- Connect to MySQL database from command line
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- What is the purpose of the command interpreter?