EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #532 background imageLoading...
Page #532 background image
application plan to process SQL
statements that it encounters during
statement execution.
application process
The unit to which resources and locks are
allocated. An application process involves
the execution of one or more programs.
application programming interface (API)
A functional interface that is supplied by
the operating system or by a separately
orderable licensed program that allows an
application program that is written in a
high-level language to use specific data or
functions of the operating system or
licensed program.
application requester
The component on a remote system that
generates DRDA requests for data on
behalf of an application.
application server
The target of a request from a remote
application. In the DB2 environment, the
application server function is provided by
the distributed data facility and is used to
access DB2 data from remote applications.
archive log
The portion of the DB2 log that contains
log records that have been copied from
the active log. See also active log.
ASCII An encoding scheme that is used to
represent strings in many environments,
typically on PCs and workstations.
Contrast with EBCDIC and Unicode.
ASID See address space identifier.
attachment facility
An interface between DB2 and TSO, IMS,
CICS, or batch address spaces. An
attachment facility allows application
programs to access DB2.
attribute
A characteristic of an entity. For example,
in database design, the phone number of
an employee is an attribute of that
employee.
authorization ID
A string that can be verified for
connection to DB2 and to which a set of
privileges is allowed. An authorization ID
can represent an individual or an
organizational group.
authorized program analysis report (APAR)
A report of a problem that is caused by a
suspected defect in a current release of an
IBM supplied program.
authorized program facility (APF)
A facility that allows an installation to
identify system or user programs that can
use sensitive system functions.
automatic bind
(More correctly automatic rebind.) A
process by which SQL statements are
bound automatically (without a user
issuing a BIND command) when an
application process begins execution and
the bound application plan or package it
requires is not valid.
automatic query rewrite
A process that examines an SQL statement
that refers to one or more base tables or
materialized query tables, and, if
appropriate, rewrites the query so that it
performs better.
auxiliary index
An index on an auxiliary table in which
each index entry refers to a LOB or XML
document.
auxiliary table
A table that contains columns outside the
actual table in which they are defined.
Auxiliary tables can contain either LOB or
XML data.
backout
The process of undoing uncommitted
changes that an application process made.
A backout is often performed in the event
of a failure on the part of an application
process, or as a result of a deadlock
situation.
backward log recovery
The final phase of restart processing
during which DB2 scans the log in a
backward direction to apply UNDO log
records for all aborted changes.
base table
A table that is created by the SQL
CREATE TABLE statement and that holds
persistent data. Contrast with clone table,
materialized query table, result table,
temporary table, and transition table.
base table space
A table space that contains base tables.
516 Application Programming Guide and Reference for Java
â„¢
|
|
|
|
|
|
|
|
|
|
|

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability