IBM 000-8697 Manual Do Utilizador

2-112

IBM Informix OnLine Database Server Administrator’s Guide

Create a Table: What Happens on Disk

illustrates the pointers within the disk data structures that track

and monitor the disk space allocated to a table.

Figure 2-22

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.

OnLine tracks

tblspaces

independently of

the database.

Tblspace

Tblspace tblspace

Initial extent

Dbspace

Initial extent

Next extent

Initial extent

Tblspace

Dbspace