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 #549 background imageLoading...
Page #549 background image
inflight
A status of a unit of recovery. If DB2 fails
before its unit of recovery completes
phase 1 of the commit process, it merely
backs out the updates of its unit of
recovery at restart. These units of
recovery are termed inflight.
inheritance
The passing downstream of class
resources or attributes from a parent class
in the class hierarchy to a child class.
initialization file
For DB2 ODBC applications, a file
containing values that can be set to adjust
the performance of the database manager.
inline copy
A copy that is produced by the LOAD or
REORG utility. The data set that the inline
copy produces is logically equivalent to a
full image copy that is produced by
running the COPY utility with read-only
access (SHRLEVEL REFERENCE).
inner join
The result of a join operation that
includes only the matched rows of both
tables that are being joined. See also join,
equijoin, full outer join, left outer join,
outer join, and right outer join.
inoperative package
A package that cannot be used because
one or more user-defined functions or
procedures that the package depends on
were dropped. Such a package must be
explicitly rebound. Contrast with invalid
package.
insensitive cursor
A cursor that is not sensitive to inserts,
updates, or deletes that are made to the
underlying rows of a result table after the
result table has been materialized.
insert trigger
A trigger that is defined with the
triggering SQL operation, an insert.
install The process of preparing a DB2
subsystem to operate as a z/OS
subsystem.
INSTEAD OF trigger
A trigger that is associated with a single
view and is activated by an insert,
update, or delete operation on the view
and that can define how to propagate the
insert, update, or delete operation on the
view to the underlying tables of the view.
Contrast with BEFORE trigger and
AFTER trigger.
instrumentation facility component identifier
(IFCID)
A value that names and identifies a trace
record of an event that can be traced. As a
parameter on the START TRACE and
MODIFY TRACE commands, it specifies
that the corresponding event is to be
traced.
instrumentation facility interface (IFI)
A programming interface that enables
programs to obtain online trace data
about DB2, to submit DB2 commands,
and to pass data to DB2.
Interactive System Productivity Facility (ISPF)
An IBM licensed program that provides
interactive dialog services in a z/OS
environment.
inter-DB2 R/W interest
A property of data in a table space, index,
or partition that has been opened by more
than one member of a data sharing group
and that has been opened for writing by
at least one of those members.
intermediate database server
The target of a request from a local
application or a remote application
requester that is forwarded to another
database server.
internal resource lock manager (IRLM)
A z/OS subsystem that DB2 uses to
control communication and database
locking.
internationalization
The support for an encoding scheme that
is able to represent the code points of
characters from many different
geographies and languages. To support all
geographies, the Unicode standard
requires more than 1 byte to represent a
single character. See also Unicode.
intersection
An SQL operation that involves the
INTERSECT set operator, which combines
two result tables. The result of an
intersection operation consists of all of the
rows that are in both result tables.
Glossary 533
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

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