Database Tblspace Entries

Each database tblspace entry includes the following five components:
  • Database name
  • Database owner
  • Date and time that the database was created
  • The tblspace number of the systables system catalog table for this database
  • Flags that indicate logging mode

The database tblspace includes a unique index on the database name to ensure that every database is uniquely named. For any database, the systables table describes each permanent table in the database. Therefore, the database tblspace only points to the detailed database information located elsewhere.

When the root dbspace is initialized, the database tblspace first extent is allocated. The initial-extent size and the next-extent size for the database tblspace are four pages. You cannot modify these values.

Copyright© 2018 HCL Technologies Limited