Entries in the System Catalog Tables
The table itself is fully described in entries stored
in the system catalog tables for the database. Each table is assigned
a table identification number or tabid. The tabid value of
the first user-defined table object in a database is always 100
.
(The object whose tabid = 100 might also be a view, synonym, or a
sequence.) For a complete discussion of the system catalog, see the HCL OneDB™ Guide to SQL:
Reference.
A table can be located in a dbspace that is different than the dbspace that contains the database. The tblspace itself is the sum of allocated extents, not a single, contiguous allocation of space. The database server tracks tblspaces independently of the database.