Manualshelf

SQL/MP Glossary

ManualsBrandsHP ManualsServerHP NonStop G-Series
21222324252627282930
Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-17
lock holder
lock holder. The process that acquires an exclusive or shared lock on data, sometimes called
lock owner. For audited tables, the lock holder is identified by a transaction ID.
lockable unit. The amount of data that can be protected by a single lock. Tables, partitions of
tables, subsets of rows, and single rows are lockable units. See also lock granularity
.
low PIN. A process identification number (PIN) in the range 0 through 255.
MDAM (MultiDimensional Access Method). An optimized scan method that provides
improved performance for queries that contain range or missing predicates on key
columns.
merge join. See sort merge join
.
message code. An integer that uniquely identifies an SQL error or warning.
message file. A key-sequenced file that contains error and warning messages and HELP text
that NonStop SQL/MP can return. The default message file is
$SYSTEM.SYSTEM.SQLMSG, with messages and text in American English.
message file language. An SQLCI session attribute indicating the language in which
messages and help text appear in the current SQL message file.
message file name. An SQLCI session attribute indicating the name of the current SQL
message file.
message file version. An SQLCI session attribute indicating the software version of the
current SQL message file. See also software version
and version number.
mixed object. A shorthand view or the result of a SELECT statement whose underlying
tables are a mixture of audited and nonaudited tables.
mixed-version network. A network in which nodes have different versions of
NonStop SQL/MP software.
mixed-version system. A NonStop system on which catalogs have different catalog versions.
multibyte character. A character that requires more than one byte for storage.
multibyte character set. A character set consisting of characters that require more than one
byte each for storage.
multibyte column. A column that has an associated multibyte character set.
MultiDimensional Access Method. See MDAM (MultiDimensional Access Method)
.
name resolution. The process of resolving names in a statement by mapping DEFINEs to
their physical names and expanding partially qualified object, file, and catalog names by
using the current default values.