Glossary
E
EBCDIC
Extended binary-coded decimal interchange
code. A coded character set of 256 8-bit characters.
embedded SQL
SQL statements coded within an application
program. See static SQL.
EN
End node.
encoding scheme
A set of rules to represent character
data.
end node (EN)
In APPN, a node that supports sessions
between its local control point (CP) and the CP in an adjacent network node.
enhanced conflict detection
Conflict detection that guarantees data
integrity among all replicas and the origin table. The Apply program locks all
replicas in the subscription set against further transactions, and begins
detection after all changes made prior to locking have been captured. See also
standard conflict detection, conflict detection.
environment handle
A handle that identifies the global
context for database access. All data that is pertinent to all objects in the
environment is associated with this handle.
equijoin
A join in which the predicate contains an
equals operator. For example, T1.C1 = T2.C2.
EUC
Extended UNIX code.
event monitor
A database object for monitoring and
collecting data on database activities over a period of time.
exclusive lock
A lock that prevents concurrently
executing application processes from accessing database data.
executable statement
An SQL statement that can be embedded in
an application program, dynamically prepared and executed, or issued
interactively.
explain
To capture detailed information about the
access plan that was chosen by the SQL compiler to resolve an SQL statement.
The information describes the decision criteria used to choose the access
plan.
explainable statement
An SQL statement for which the explain
operation can be performed. Explainable statements are SELECT, UPDATE, INSERT,
DELETE, and VALUES.
explained statement
An SQL statement for which an explain
operation was performed.
explained statistics
Statistics for a database object that was
referenced in an SQL statement at the time the statement was explained.
explain snapshot
A capture of the current internal
representation of an SQL query and related information. This information is
required by the Visual Explain tool.
export
To copy data from database manager tables
to a file using formats such as PC/IXF, DEL, WSF, or ASC. Contrast with
import.
exposed name
A correlation name, a table, or a view
name specified in a FROM clause for which a correlation name is not specified.
Extended UNIX Code (EUC)
A protocol that can support sets of
characters from 1 to 4 bytes in length. EUC is a means of specifying a
collection of code pages rather than actually being a code page encoding
scheme itself. This is the UNIX alternative to the PC double-byte (DBCS) code
page encoding schemes.
extent
An allocation of space, within a container
of a table space, to a single database object. This allocation consists of
multiple pages.
extent map
A meta-data structure stored within a
table space that records the allocation of extents to each object in the table
space.
external source table
A non-DB2 table that is manually updated
to match the consistent change data table structure and defined as a
replication source. See also consistent change data (CCD) table.
[ Top of Page | Previous Page | Next Page | Table of Contents ]
[ DB2 List of Books |
Search the DB2 Books ]