IBM Books

Legend

Use the Legend window to see the object icons used in the Control Center and what they represent.

Objects

Figure lgsystm not displayed.System
A computer system defined to the DB2 system administration tools.

Figure lginst not displayed.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.

Figure lgdbase not displayed.Database
A DB2 relational database. A relational database presents data as a collection of tables.

Figure lgtable not displayed.Table
A named data object consisting of a specific number of columns and some unordered rows.

Figure lgview not displayed.View
A logical table that consists of data that is generated by a query.

Figure lgalias not displayed.Alias
An alternative name used to identify a table, view, or database.

Figure lgtrigg not displayed.Trigger
An object in a database that is invoked indirectly by the database manager when a particular SQL statement is run.

Figure lgschma not displayed.Schema
A collection of database objects such as tables, views, indexes, and triggers. It provides a logical classification of database objects.

Figure lgindx not displayed.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.

Figure lgtbspc not displayed.Table Space
An abstraction of a collection of containers into which database objects are stored.

Figure lgcnnx not displayed.Connection
An association between an application process and an application server.

Figure lgrpsrc not displayed.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.

Figure rpsub not displayed.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.

Figure hibufp not displayed.Buffer Pool
An area of storage in which all buffers of a program are kept.

Figure lgudt not displayed.User-Defined Type
A data type that is not native to the DB2 database manager and that was created by a user.

Figure hiudf not displayed.User-Defined Function
A function that is defined to the database management system and can be referenced in SQL queries.

Figure lgpkge not displayed.Package
A control structure produced during program preparation that is used to execute SQL statements.

Figure stproc not displayed.Stored Procedures
A block of procedural constructs and embedded SQL statements that is stored in a database and can be called by name.

Figure lgusr not displayed.DB User
A user that has specific database privileges.

Figure lggrp not displayed.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: Figure lgsfold not displayed.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]