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 #554 background imageLoading...
Page #554 background image
network identifier (NID)
The network ID that is assigned by IMS
or CICS, or if the connection type is
RRSAF, the RRS unit of recovery ID
(URID).
new-function mode (NFM)
The normal mode of operation that exists
after successful completion of a
version-to-version migration. At this
stage, all new functions of the new
version are available for use. A DB2 data
sharing group cannot coexist with
members that are still at the prior version
level, and fallback to a prior version is
not supported. Contrast with
compatibility mode, compatibility mode*,
enabling-new-function mode, and
enabling-new-function mode*.
NFM See new-function mode.
NID See network identifier.
node ID index
See XML node ID index.
nondeterministic function
A user-defined function whose result is
not solely dependent on the values of the
input arguments. That is, successive
invocations with the same argument
values can produce a different answer.
This type of function is sometimes called
a variant function. Contrast with
deterministic function (sometimes called a
not-variant function).
nonleaf page
A page that contains keys and page
numbers of other pages in the index
(either leaf or nonleaf pages). Nonleaf
pages never point to actual data. Contrast
with leaf page.
nonpartitioned index
An index that is not physically
partitioned. Both partitioning indexes and
secondary indexes can be nonpartitioned.
nonpartitioned secondary index (NPSI)
An index on a partitioned table space that
is not the partitioning index and is not
partitioned. Contrast with
data-partitioned secondary index.
nonpartitioning index
See secondary index.
nonscrollable cursor
A cursor that can be moved only in a
forward direction. Nonscrollable cursors
are sometimes called forward-only cursors
or serial cursors.
normalization
A key step in the task of building a
logical relational database design.
Normalization helps you avoid
redundancies and inconsistencies in your
data. An entity is normalized if it meets a
set of constraints for a particular normal
form (first normal form, second normal
form, and so on). Contrast with
denormalization.
not-variant function
See deterministic function.
NPSI See nonpartitioned secondary index.
NUL The null character (’\0’), which is
represented by the value X’00’. In C, this
character denotes the end of a string.
null A special value that indicates the absence
of information.
null terminator
In C, the value that indicates the end of a
string. For EBCDIC, ASCII, and Unicode
UTF-8 strings, the null terminator is a
single-byte value (X’00’). For Unicode
UTF-16 or UCS-2 (wide) strings, the null
terminator is a double-byte value
(X’0000’).
ODBC
See Open Database Connectivity.
ODBC driver
A dynamically-linked library (DLL) that
implements ODBC function calls and
interacts with a data source.
OLAP See online analytical processing.
online analytical processing (OLAP)
The process of collecting data from one or
many sources; transforming and
analyzing the consolidated data quickly
and interactively; and examining the
results across different dimensions of the
data by looking for patterns, trends, and
exceptions within complex relationships
of that data.
Open Database Connectivity (ODBC)
A Microsoft database application
programming interface (API) for C that
allows access to database management
systems by using callable SQL. ODBC
538 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