SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Creating an SQL/MX Database
HP NonStop SQL/MX Installation and Management Guide—523723-004
7-3
SQL/MX Data File Naming Guidelines
•
The subvolume name must be exactly eight characters long.
•
All Guardian files representing data in a particular schema must have the same
subvolume name regardless of the volume on which they reside. This subvolume
name must match the subvolume name indicated in the SCHEMA_SUBVOLUME
column of the system schema table
NONSTOP_SQLMX_system-name.SYSTEM_SCHEMA.SCHEMATA.
Examples of valid SQL/MX subvolume names are:
•
ZSDBMM3K
•
ZSDADMM8
For more information about subvolume naming, see the SQL/MX Reference Manual.
SQL/MX Data File Naming Guidelines
•
The file name must end with the digits “00” (zero zero).
•
The file name must be exactly eight characters long.
•
The file name must match the designated schema subvolume name for the
schema in which the object is being created. Otherwise, an error is generated.
Examples of valid names for SQL/MX files are:
•
WDE6TI00
•
HEPQTI00
•
SS8BSI00
For more information about file naming, see the SQL/MX Reference Manual.
Resource Forks
NonStop SQL/MX maintains substantial information about data files in companion files
known as resource forks. Resource forks are located in the same volume and
subvolume as data files and have the same name as their corresponding data file, with
the final “0” (zero) changed to “1” (one).
Resource forks contain similar information to Guardian file labels, but have the
capacity to store a much greater variety and quantity of information. Examples of data
fork/resource fork pairs are:
•
$DATA.ZSDADMM8.WDE6TI00 / $DATA.ZSDADMM8.WDE6TI01
•
$DATA.ZSDADMM8.HEPQTI00 / $DATA.ZSDADMM8.HEPQTI01
•
$DATA.ZSDADMM8.SS8BSI00 / $DATA.ZSDADMM8.SS8BSI01
Data files are sometimes referred to as data forks to distinguish them from resource
forks. Under normal circumstances, you are not expected or permitted to refer explicitly
to resource forks by name. The one significant exception is TMF recovery using
Guardian file names.