SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-11
fallback node
fallback node. A node on which the NonStop SQL/MP system software has an older version
than an object, catalog, or program on the same node.
field. A portion of a record reserved for a specific item of information. In relational terms,
each column of a table represents one field. In a date-time or INTERVAL column value,
a DATETIME field or INTERVAL field, such as HOUR, is a specific part of the value.
file. The physical storage for a table, index, collation, table partition, or index partition. The
creation of a table or index implicitly creates a file with the same name as the table or
index.
file attribute. An attribute that describes a physical characteristic of a file, such as block size,
record length, the number and sizes of extents, and whether the file is audited.
file code. An integer describing the type of file or the type of SQL object that the file
contains; for example, the file code for an EDIT file is 101, and the file code for a
collation is 941.
file ID. The last part of a file name, after the subvolume name. See also file name
and
operating system name.
file label. A label, containing file and catalog information in encoded form, associated with
each table, index, view, collation, table partition, and index partition.
file name. The operating system name of a disk or tape file. A file name includes a node
name, volume name, subvolume name, and file ID. See also operating system name
.
file recovery. A TMF feature for returning a table or disk file to its most recent consistent
state following a media failure by redoing all transactions starting from a known backup
copy of the data. Contrast with volume recovery
.
file system. A set of operating system procedures and data structures that provide
communication between a process and a disk file, nondisk device, or another process.
The FS2 file system is a component of the NonStop SQL/MP software. Contrast with
disk process
.
In the Open System Services (OSS) environment, a set of files with a common mount
point within the file hierarchy. A fileset can be part or all of a single virtual file system.
On a TNS/R system, the Guardian file system for a node has a mount point and is a
subset of the Open System Services (OSS) virtual file system. The entire Guardian file
system therefore can be viewed as a single fileset. However, each volume, and each
process of subtype 30, within the Guardian file system is actually a separate fileset.
The term file system is often used interchangeably with fileset.
file system error. An error returned by the file system.
file type. A designation for a file structure. On a NonStop system, file types include entry
sequenced, key sequenced, and relative.