Problem: Give and explain the panel command to display all the components of DB2 database DSNDB01 along with their status.
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.
Here, DI indicates DISPLAY which is followed by the DB identifier indicating database. Finally, the database name has to be given in braces.