Use the Legend window to see the object icons used in the Control Center
and what they represent.
Objects
-
System
- A computer system defined to the DB2 system 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.
-
Wrapper
- A mechanism utilizing routines and control information that the federated
server uses to communicate with, and retrieve data from, a data source.
-
Server
- A unit of information that identifies a data source to a federated
server. This information can include the server's name, its type,
its version, and the name of the wrapper that the federated server uses to
communicate with and retrieve data from it.
-
User mapping
- An association between the authorization under which a user connects to a
federated server and the authorization under which the user connects to a data
source.
-
Nickname
- An identifier that a federated server uses to reference a data source
table or view.
-
Alias
- An alternative name used to identify a table, view, or database.
-
Trigger
- An object in a database that is invoked indirectly by the database manager
when a particular SQL statement is run.
-
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.
-
Table Space
- An abstraction of a collection of containers into which database objects
are stored.
-
Connection
- An association between an application process and an application
server.
-
Replication Source
- A database table that is defined as a source for replication. This
type of table can accept copy requests and is the source table in a
replication subscription set.
-
Replication Subscription
- A specification for copying changed data from replication sources to
target tables at a specified time and frequency, with the option of enhancing
data.
-
Buffer Pool
- An area of storage in which all buffers of a program are kept.
-
User-Defined Type
- A data type that is not native to the DB2 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.
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:
