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.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Effect of configuration on I/O activityThe configuration of your database server affects I/O activity.
Placement of simple large objectsYou can store simple large objects in either the same dbspace in which the table resides or in a blobspace.
Blobpage size considerationsBlobspaces are divided into units called blobpages. The database server retrieves simple large objects from a blobspace in blobpage-sized units. You specify the size of a blobpage in multiples of a disk page when you create the blobspace.
Obtain blobspace storage statisticsTo help you determine the optimal blobpage size for each blobspace, use the oncheck -pB command.

Obtain blobspace storage statistics

To help you determine the optimal blobpage size for each blobspace, use the oncheck -pB command.

The command lists the following statistics for each table (or database):

The number of blobpages used by the table (or database) in each blobspace
The average fullness of the blobpages used by each simple large object stored as part of the table (or database)