Tag Archive | List DB2 TableSpace

List DB2 TableSpace


=============================================================
DB2 list TableSpaces
=============================================================
This command is used to provide the details of the Tablespace
• Table space ID
• Name
• Type (system managed space or database managed space)
• Contents (any data, long or index data, or temporary data)
• State, a hexadecimal value indicating the current table space state. eg; 0x0 Normal

[[db2inst1@mercury ~]$ db2 connect to sample
[db2inst1@mercury ~]$ db2 list tablespaces

ScreenShot : Lists the DB2 Tablespace

listtablspace
——————————————————————————————————
List TableSpace with Details
——————————————————————————————————
If “show details” option is specified, the following additional information about each table space is provided:
• Total number of pages
• Number of usable pages
• Number of used pages
• Number of free pages
• High water mark (in pages)
…. and many more details

[[db2inst1@mercury ~]$ db2 connect to sample
[db2inst1@mercury ~]$ db2 list tablespaces show detail

 

ScreenShot : Lists the DB2 Tablespace with “show details “
listtablspace2
ScreenShot : Lists the DB2 Tablespace with container details

[db2inst1@mercury ~]$ db2 list tablespace containers for 3 show detail

 

listtablspace3