=============================================================
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
——————————————————————————————————
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 “
ScreenShot : Lists the DB2 Tablespace with container details
| [db2inst1@mercury ~]$ db2 list tablespace containers for 3 show detail |
