Control Center Legend

To open the Legend window, click on the toolbar.

Objects

System

A computer system defined to the DB2® system DB2 administration tools.

Instance

A database manager environment that is an image of the actual database manager environment. You can have several instances of a database manager on the same system.

Database

A DB2 relational database. A relational database presents data as a collection of tables.

Table

A named data object consisting of a specific number of columns and some unordered rows.

View

A logical table that consists of data that is generated by a query.

Alias

An alternative name used to identify a table, view, or database.

Schema

A collection of database objects such as tables, views, indexes, and triggers. It provides a logical classification of database objects.

Index

A set of pointers that are logically ordered by the values of a key. Indexes provide quick access to data and can enforce uniqueness on the rows in the table.

Trigger

An object in a database that is invoked indirectly by the database manager when a particular SQL statement is run.

Table Space

An abstraction of a collection of containers into which database objects are stored.

Buffer Pool

An area of storage in which all buffers of a program are kept.

User-Defined Distinct Datatype

A data type that is not native to the database manager and that was created by a user.

User-Defined Function

A function that is defined to the database management system and can be referenced in SQL queries.

Package

A control structure produced during program preparation that is used to execute SQL statements.

Stored Procedures

A block of procedural constructs and embedded SQL statements that is stored in a database and can be called by name.

DB User

A user that has specific database privileges.

DB Group

A group of users that has specific database privileges.

Partition

In a partitioned database environment, one part of either a database partition, a table space partition, or a portion of a table.

Database Partition

In a partitioned database environment, a part of the database that consists of its own user data, indexes, configuration files, and transaction logs.

Table Space Partition

In a partitioned database environment, table spaces that reside in database partition groups.

Table Partition

A table in a database partition group consisting of multiple partitions, some of its rows are stored in one partition, and other rows are stored in other partitions.

Database Partition Group

In a partitioned database environment, a named set of one or more database partitions.

A set of a particular object type is represented by a folder that has the icon for that type displayed on top of it. For example, a set of systems is represented by the following icon: