Dbspace table

The dbspace table tracks storage spaces in the database server.

The dbspace-table information includes the following information about each dbspace:
  • Dbspace number
  • Dbspace name and owner
  • Dbspace mirror status (mirrored or not)
  • Date and time that the dbspace was created

If the storage space is a blobspace, flags indicate the media where the blobspace is located: magnetic or removable. If the storage space is an sbspace, it contains internal tables that track metadata for smart large objects and large contiguous blocks of pages containing user data.

If the storage space is a blobspace, flags indicate the media where the blobspace is located: magnetic, removable, or optical media. If the storage space is an sbspace, it contains internal tables that track metadata for smart large objects and large contiguous blocks of pages containing user data.

For information about monitoring dbspaces, see Monitor disk usage.