setrstats.blogg.se - Logical volume manager windows

#Logical volume manager windows how to#
#Logical volume manager windows archive#

Table fragmentation and data storage The fragmentation feature gives you more control over where the database stores data.

A separate tblspace contains the disk space allocated for the associated index. A tblspace contains all the disk space allocated to a given table or table fragment (if the table is fragmented).

Tblspaces Database server administrators sometimes must track disk use by a particular table.

You can create either a STANDARD or RAW table and change tables from one type to another.

The default standard table is like a table created in earlier versions without a special keyword specified.

The two table types are STANDARD (logging tables) and RAW (nonlogging tables).

Table types for HCL OneDB™ You can create logging or nonlogging tables in a logging database on HCL OneDB™.

The row of column headings identifies one or more columns and a data type for each column.

Tables In relational database systems, a table is a row of column headings together with zero or more rows of data values.

Each database also contains a system catalog that tracks information about many of the elements in the database, including tables, indexes, SPL routines, and integrity constraints.

Databases A database is a logical storage unit that contains tables and indexes.

The resource that the extspace references depends on a user-defined access method for accessing its contents.

Extspaces An extspace is a logical name associated with an arbitrary string that signifies the location of external data.

When the physical log is in the plogspace, the database server increases the size of the physical log as needed to improve performance.

Plogspace A plogspace is a logical storage unit that is composed of one chunk that stores the physical log.

Sbspaces An sbspace is a logical storage unit composed of one or more chunks that store smart large objects.

Blobspaces A blobspace is a logical storage unit composed of one or more chunks that store only TEXT and BYTE data.

Place databases, tables, logical-log files, and the physical log in dbspaces. The database server uses the dbspace to store databases and tables.

Dbspaces A dbspace is a logical unit that can contain between 1 and 32,766 chunks.Extents An extent consists of a collection of contiguous pages that store data for a given table.An sbpage is the same size as the database server page, which is usually 2 KB on UNIX™ and 4 KB on Windows™. Unlike blobpages, sbpages are not configurable. Sbpages An sbpage is the type of page that the database server uses to store smart large objects within an sbspace.Blobpages A blobpage is the unit of disk-space allocation that the database server uses to store simple large objects (TEXT or BYTE data) within a blobspace.Pages A page is the physical unit of disk storage that the database server uses to read from and write to HCL® OneDB® databases.Chunks A chunk is the largest unit of physical disk dedicated to database server data storage.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. Data storage The database server uses physical units of storage to allocate disk space.Shared memory These topics describe the content of database server shared memory, the factors that determine the sizes of shared-memory areas, and how data moves into and out of shared memory.

#Logical volume manager windows how to#

Manage virtual processors These topics describe how to set the configuration parameters that affect database server virtual processors, and how to start and stop virtual processors.Virtual processors and threads These topics describe virtual processors, explain how threads run within the virtual processors, and explain how the database server uses virtual processors and threads to improve performance.Administrator's Guide The HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.System administration These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.

#Logical volume manager windows archive#

Administering In addition to administering the database server, you can tune performance, replicate data, and archive data.