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 #531 background imageLoading...
Page #531 background image
Glossary
abend See abnormal end of task.
abend reason code
A 4-byte hexadecimal code that uniquely
identifies a problem with DB2.
abnormal end of task (abend)
Termination of a task, job, or subsystem
because of an error condition that
recovery facilities cannot resolve during
execution.
access method services
The facility that is used to define, alter,
delete, print, and reproduce VSAM
key-sequenced data sets.
access path
The path that is used to locate data that is
specified in SQL statements. An access
path can be indexed or sequential.
active log
The portion of the DB2 log to which log
records are written as they are generated.
The active log always contains the most
recent log records. See also archive log.
address space
A range of virtual storage pages that is
identified by a number (ASID) and a
collection of segment and page tables that
map the virtual pages to real pages of the
computer’s memory.
address space connection
The result of connecting an allied address
space to DB2. See also allied address
space and task control block.
address space identifier (ASID)
A unique system-assigned identifier for
an address space.
AFTER trigger
A trigger that is specified to be activated
after a defined trigger event (an insert,
update, or delete operation on the table
that is specified in a trigger definition).
Contrast with BEFORE trigger and
INSTEAD OF trigger.
agent In DB2, the structure that associates all
processes that are involved in a DB2 unit
of work. See also allied agent and system
agent.
aggregate function
An operation that derives its result by
using values from one or more rows.
Contrast with scalar function.
alias An alternative name that can be used in
SQL statements to refer to a table or view
in the same or a remote DB2 subsystem.
An alias can be qualified with a schema
qualifier and can thereby be referenced by
other users. Contrast with synonym.
allied address space
An area of storage that is external to DB2
and that is connected to DB2. An allied
address space can request DB2 services.
See also address space.
allied agent
An agent that represents work requests
that originate in allied address spaces. See
also system agent.
allied thread
A thread that originates at the local DB2
subsystem and that can access data at a
remote DB2 subsystem.
allocated cursor
A cursor that is defined for a stored
procedure result set by using the SQL
ALLOCATE CURSOR statement.
ambiguous cursor
A database cursor for which DB2 cannot
determine whether it is used for update
or read-only purposes.
APAR See authorized program analysis report.
APF See authorized program facility.
API See application programming interface.
APPL A VTAM network definition statement
that is used to define DB2 to VTAM as an
application program that uses SNA LU
6.2 protocols.
application
A program or set of programs that
performs a task; for example, a payroll
application.
application plan
The control structure that is produced
during the bind process. DB2 uses the
© Copyright IBM Corp. 1998, 2008 515
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

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