basic row format
A row format in which values for
columns are stored in the row in the
order in which the columns are defined
by the CREATE TABLE statement.
Contrast with reordered row format.
basic sequential access method (BSAM)
An access method for storing or retrieving
data blocks in a continuous sequence,
using either a sequential-access or a
direct-access device.
BEFORE trigger
A trigger that is specified to be activated
before a defined trigger event (an insert,
an update, or a delete operation on the
table that is specified in a trigger
definition). Contrast with AFTER trigger
and INSTEAD OF trigger.
binary large object (BLOB)
A binary string data type that contains a
sequence of bytes that can range in size
from 0 bytes to 2 GB, less 1 byte. This
string does not have an associated code
page and character set. BLOBs can
contain, for example, image, audio, or
video data. In general, BLOB values are
used whenever a binary string might
exceed the limits of the VARBINARY
type.
binary string
A sequence of bytes that is not associated
with a CCSID. Binary string data type can
be further classified as BINARY,
VARBINARY, or BLOB.
bind A process by which a usable control
structure with SQL statements is
generated; the structure is often called an
access plan, an application plan, or a
package. During this bind process, access
paths to the data are selected, and some
authorization checking is performed. See
also automatic bind.
bit data
v Data with character type CHAR or
VARCHAR that is defined with the
FOR BIT DATA clause. Note that using
BINARY or VARBINARY rather than
FOR BIT DATA is highly
recommended.
v Data with character type CHAR or
VARCHAR that is defined with the
FOR BIT DATA clause.
v A form of character data. Binary data is
generally more highly recommended
than character-for-bit data.
BLOB See binary large object.
block fetch
A capability in which DB2 can retrieve, or
fetch, a large set of rows together. Using
block fetch can significantly reduce the
number of messages that are being sent
across the network. Block fetch applies
only to non-rowset cursors that do not
update data.
bootstrap data set (BSDS)
A VSAM data set that contains name and
status information for DB2 and RBA
range specifications for all active and
archive log data sets. The BSDS also
contains passwords for the DB2 directory
and catalog, and lists of conditional
restart and checkpoint records.
BSAM
See basic sequential access method.
BSDS See bootstrap data set.
buffer pool
An area of memory into which data pages
are read, modified, and held during
processing.
built-in data type
A data type that IBM supplies. Among
the built-in data types for DB2 for z/OS
are string, numeric, XML, ROWID, and
datetime. Contrast with distinct type.
built-in function
A function that is generated by DB2 and
that is in the SYSIBM schema. Contrast
with user-defined function. See also
function, cast function, external function,
sourced function, and SQL function.
business dimension
A category of data, such as products or
time periods, that an organization might
want to analyze.
cache structure
A coupling facility structure that stores
data that can be available to all members
of a Sysplex. A DB2 data sharing group
uses cache structures as group buffer
pools.
CAF See call attachment facility.
Glossary 517
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General