How does DB2 query all the Container in the Database?

This article mainly describes the actual operation methods of all Container in DB2 Database query. The following describes the actual operation methods of all Container in DB2 Database query, I hope this will help you in your future studies.

How does DB2 query all the iner in the Database?

 
 

  
  
db2 "select substr(tbsp_name,1,25) tbsp_name,substr(container_name,1,50)  
  
  
container_name,total_pages,usable_pages from sysibmadm.snapcontainer"  
  
  
Exp  
  
  
:  
  
  
[db2inst1@localhost ~]$ db2 "select substr(tbsp_name,1,25) tbsp_name,substr(container_name,1,50)  
  
  
container_name,total_pages,usable_pages from sysibmadm.snapcontainer"  
  
  
TBSP_NAME CONTAINER_NAME TOTAL_PAGES USABLE_PAGES  
  
  
SYSCATSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000000/C 8192 8188  
  
  
TEMPSPACE1 /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000001/C 0 0  
  
  
USERSPACE1 /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000002/C 4096 4064  
  
  
IBMDB2SAMPLEREL /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000003/C 4096 4064  
  
  
SYSTOOLSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C 4096 4092  
  
  
IBMDB2SAMPLEXML /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000005/C 4096 4064  
  
  
SYSTOOLSTMPSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000006/C 0 0 
 
 

The above content is an introduction to all the Container methods in the DB2 Database query. I hope you will get some benefits.

The above content is the description of all the Container methods in the DB2 Database query, hoping to help you in this aspect.