subsystems that directly access and
change the same data while maintaining
data integrity.
data sharing member
A DB2 subsystem that is assigned by XCF
services to a data sharing group.
data source
A local or remote relational or
non-relational data manager that is
capable of supporting data access via an
ODBC driver that supports the ODBC
APIs. In the case of DB2 for z/OS, the
data sources are always relational
database managers.
data type
An attribute of columns, constants,
variables, parameters, special registers,
and the results of functions and
expressions.
data warehouse
A system that provides critical business
information to an organization. The data
warehouse system cleanses the data for
accuracy and currency, and then presents
the data to decision makers so that they
can interpret and use it effectively and
efficiently.
DBA See database administrator.
DBAT See database access thread.
DB2 catalog
A collection of tables that are maintained
by DB2 and contain descriptions of DB2
objects, such as tables, views, and
indexes.
DBCLOB
See double-byte character large object.
DB2 command
An instruction to the DB2 subsystem that
a user enters to start or stop DB2, to
display information on current users, to
start or stop databases, to display
information on the status of databases,
and so on.
DBCS See double-byte character set.
DBD See database descriptor.
DB2I See DB2 Interactive.
DBID See database identifier.
DB2 Interactive (DB2I)
An interactive service within DB2 that
facilitates the execution of SQL
statements, DB2 (operator) commands,
and programmer commands, and the
invocation of utilities.
DBMS
See database management system.
DBRM
See database request module.
DB2 thread
The database manager structure that
describes an application’s connection,
traces its progress, processes resource
functions, and delimits its accessibility to
the database manager resources and
services. Most DB2 for z/OS functions
execute under a thread structure.
DCLGEN
See declarations generator.
DDF See distributed data facility.
deadlock
Unresolvable contention for the use of a
resource, such as a table or an index.
declarations generator (DCLGEN)
A subcomponent of DB2 that generates
SQL table declarations and COBOL, C, or
PL/I data structure declarations that
conform to the table. The declarations are
generated from DB2 system catalog
information.
declared temporary table
A non-persistent table that holds
temporary data and is defined with the
SQL statement DECLARE GLOBAL
TEMPORARY TABLE. Information about
declared temporary tables is not stored in
the DB2 catalog and can be used only by
the application process that issued the
DECLARE statement. Contrast with
created temporary table. See also
temporary table.
default value
A predetermined value, attribute, or
option that is assumed when no other
value is specified. A default value can be
defined for column data in DB2 tables by
specifying the DEFAULT keyword in an
SQL statement that changes data (such as
INSERT, UPDATE, and MERGE).
deferred embedded SQL
SQL statements that are neither fully
static nor fully dynamic. These statements
524 Application Programming Guide and Reference for Java
â„¢
|
|
|
|
|
|
|
|
|
|
|
|
|
|