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 #548 background imageLoading...
Page #548 background image
be invoked as a job or jobstep, from a
TSO terminal, or from within a user’s
application program.
IDCAMS LISTCAT
A facility for obtaining information that is
contained in the access method services
catalog.
identity column
A column that provides a way for DB2 to
automatically generate a numeric value
for each row. Identity columns are
defined with the AS IDENTITY clause.
Uniqueness of values can be ensured by
defining a unique index that contains
only the identity column. A table can
have no more than one identity column.
IFCID See instrumentation facility component
identifier.
IFI See instrumentation facility interface.
IFI call
An invocation of the instrumentation
facility interface (IFI) by means of one of
its defined functions.
image copy
An exact reproduction of all or part of a
table space. DB2 provides utility
programs to make full image copies (to
copy the entire table space) or incremental
image copies (to copy only those pages
that have been modified since the last
image copy).
IMS attachment facility
A DB2 subcomponent that uses z/OS
subsystem interface (SSI) protocols and
cross-memory linkage to process requests
from IMS to DB2 and to coordinate
resource commitment.
in-abort
A status of a unit of recovery. If DB2 fails
after a unit of recovery begins to be rolled
back, but before the process is completed,
DB2 continues to back out the changes
during restart.
in-commit
A status of a unit of recovery. If DB2 fails
after beginning its phase 2 commit
processing, it ″knows,″ when restarted,
that changes made to data are consistent.
Such units of recovery are termed
in-commit.
independent
An object (row, table, or table space) that
is neither a parent nor a dependent of
another object.
index A set of pointers that are logically ordered
by the values of a key. Indexes can
provide faster access to data and can
enforce uniqueness on the rows in a table.
index-controlled partitioning
A type of partitioning in which partition
boundaries for a partitioned table are
controlled by values that are specified on
the CREATE INDEX statement. Partition
limits are saved in the LIMITKEY column
of the SYSIBM.SYSINDEXPART catalog
table.
index key
The set of columns in a table that is used
to determine the order of index entries.
index partition
A VSAM data set that is contained within
a partitioning index space.
index space
A page set that is used to store the entries
of one index.
indicator column
A 4-byte value that is stored in a base
table in place of a LOB column.
indicator variable
A variable that is used to represent the
null value in an application program. If
the value for the selected column is null,
a negative value is placed in the indicator
variable.
indoubt
A status of a unit of recovery. If DB2 fails
after it has finished its phase 1 commit
processing and before it has started phase
2, only the commit coordinator knows if
an individual unit of recovery is to be
committed or rolled back. At restart, if
DB2 lacks the information it needs to
make this decision, the status of the unit
of recovery is indoubt until DB2 obtains
this information from the coordinator.
More than one unit of recovery can be
indoubt at restart.
indoubt resolution
The process of resolving the status of an
indoubt logical unit of work to either the
committed or the rollback state.
532 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