IBM 000-8697 Manual Do Utilizador

System Architecture

The paragraphs that follow describe the major events that occur when
OnLine creates a table and allocates the initial extent of disk space.

OnLine searches the linked list of chunk free-list maps in the dbspace for
contiguous free space equal to the initial extent size for the table. When
adequate space is found, the pages are allocated and the associated chunk
free-list page is updated. If space for the extent cannot be found, an error is
returned. (Since an extent is, by definition, contiguous disk space, extents
cannot span two chunks.)

OnLine adds a one-page entry for this table to the tblspace tblspace in this
dbspace. The tblspace number assigned to this table is derived from logical
page number in the tblspace tblspace where the table is described. (Refer to

 for further information about the tblspace tblspace.)

The tblspace number indicates the dbspace where the tblspace is located.
Tblspace extents can be located in any of the dbspace chunks. Execute
tbcheck -pe

 for a listing of the dbspace layout by chunk if you must know

exactly where the tblspace extents are located.

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 in a database is always 100. For
a complete discussion of the system catalog, refer to

utorial.