A user-defined time period for running only required automatic maintenance activities.
The deletion of all rows in a table.
The coordinated execution of a single request either by multiple single-processor computers in a shared-nothing environment (in which each computer has its own memory and disks) or by symmetric multiprocessor (SMP) computers (in which multiple processors in each computer share memory and disks). Both environments require that all computers are linked together in a high-speed network.
A table whose definition is based on the result of a query and whose data is in the form of precomputed results taken from the one or more tables that the materialized query table definition is based on.
See multidimensional clustering table.
To update and insert new content into a table.
Data that describes the characteristics of stored data; descriptive data. For example, the metadata for a database table might include the name of the table, the name of the database that contains the table, the names of the columns in the table, and the column descriptions, either in technical terms or business terms. Database catalogs and information catalogs contain metadata.
(1) The process of moving data from one computer system to another without converting the data.
(2) Installation of a new version or release of a program to replace an earlier version or release.
A database manager parameter manipulated by the user to control the type and quantity of information returned in performance snapshots.
A set of characters in which each character is represented by 1 or more bytes. Contrast with double-byte character set and single-byte character set.
In the DB2 OLAP Server, pertaining to a method of referencing data through three or more dimensions. An individual data value in a fact table is the intersection of one member from each dimension.
A table whose data is physically organized into blocks along one or more dimensions, or clustering keys, specified in the ORGANIZE BY DIMENSIONS clause.
In the DB2 OLAP Server, a nonrelational database into which you copy relational data for OLAP analysis.
Distributed relational database processing in which data is updated in more than one location within a single unit of work.
A mode of operation that provides for concurrent performance or interleaved execution of two or more tasks.