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 #558 background imageLoading...
Page #558 background image
table. A table cannot be defined as a
parent unless it has a unique key or
primary key.
principal
An entity that can communicate securely
with another entity. In Kerberos,
principals are represented as entries in the
Kerberos registry database and include
users, servers, computers, and others.
principal name
The name by which a principal is known
to the DCE security services.
privilege
The capability of performing a specific
function, sometimes on a specific object.
See also explicit privilege.
privilege set
v For the installation SYSADM ID, the set
of all possible privileges.
v For any other authorization ID,
including the PUBLIC authorization ID,
the set of all privileges that are
recorded for that ID in the DB2 catalog.
process
In DB2, the unit to which DB2 allocates
resources and locks. Sometimes called an
application process, a process involves the
execution of one or more programs. The
execution of an SQL statement is always
associated with some process. The means
of initiating and terminating a process are
dependent on the environment.
program
A single, compilable collection of
executable statements in a programming
language.
program temporary fix (PTF)
A solution or bypass of a problem that is
diagnosed as a result of a defect in a
current unaltered release of a licensed
program. An authorized program analysis
report (APAR) fix is corrective service for
an existing problem. A PTF is preventive
service for problems that might be
encountered by other users of the
product. A PTF is temporary, because a
permanent fix is usually not incorporated
into the product until its next release.
protected conversation
A VTAM conversation that supports
two-phase commit flows.
PSRCP
See page set recovery pending.
PTF See program temporary fix.
QSAM
See queued sequential access method.
query A component of certain SQL statements
that specifies a result table.
query block
The part of a query that is represented by
one of the FROM clauses. Each FROM
clause can have multiple query blocks,
depending on DB2 processing of the
query.
query CP parallelism
Parallel execution of a single query, which
is accomplished by using multiple tasks.
See also Sysplex query parallelism.
query I/O parallelism
Parallel access of data, which is
accomplished by triggering multiple I/O
requests within a single query.
queued sequential access method (QSAM)
An extended version of the basic
sequential access method (BSAM). When
this method is used, a queue of data
blocks is formed. Input data blocks await
processing, and output data blocks await
transfer to auxiliary storage or to an
output device.
quiesce point
A point at which data is consistent as a
result of running the DB2 QUIESCE
utility.
RACF Resource Access Control Facility. A
component of the z/OS Security Server.
range-partitioned table space
A type of universal table space that is
based on partitioning ranges and that
contains a single table. Contrast with
partition-by-growth table space. See also
universal table space.
RBA See relative byte address.
RCT See resource control table.
RDO See resource definition online.
read stability (RS)
An isolation level that is similar to
repeatable read but does not completely
isolate an application process from all
other concurrently executing application
542 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