Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Data storageThe database server uses physical units of storage to allocate disk space. It stores data in logical units. Unlike the logical units of storage whose size fluctuates, each of the physical units has a fixed or assigned size that is determined by the disk architecture.
TblspacesDatabase server administrators sometimes must track disk use by a particular table. A tblspace contains all the disk space allocated to a given table or table fragment (if the table is fragmented). A separate tblspace contains the disk space allocated for the associated index.
Table and index tblspacesThe table tblspace and index tblspace contain certain types of pages.

Table and index tblspaces

The table tblspace and index tblspace contain certain types of pages.

The table tblspace contains the following types of pages:

Pages allocated to data
Pages allocated to indexes
Pages used to store TEXT or BYTE data in the dbspace (but not pages used to store TEXT or BYTE data in a blobspace)
Bitmap pages that track page use within the table extents

The index tblspace contains the following types of pages:

Pages allocated to indexes
Bitmap pages that track page use within the index extents

The following table illustrates the tblspaces for three tables that form part of the stores_demo database. Only one table (or table fragment) exists per tblspace. Blobpages represent TEXT or BYTE data stored in a dbspace.

This figure shows the tblspaces data for three tables in the stores_demo database. Each of these tblspaces contains data pages and a bitmap page. The figure also shows the index tblspaces for three same tables. Each index tblspace contains index pages and a bitmap page. — Figure 1: Sample tblspaces in the stores_demo database

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.