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

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—523723-004
12-28
Identifying Problem Data and Objects
Table 12-2. Run-time metadata Stored in the Resource Fork
Run-time
metadata Contents
ANSI name A three-part name of the form catalog.schema.object, where each
part can be up to 128 characters long.
ANSI namespace Indicates the space the ANSI name belongs to. In NonStop SQL/MX,
tables and indexes have separate namespaces; indexes and tables in
the same schema can have the same ANSI names. The ANSI
namespace is a two-letter literal that indicates the namespace the
ANSI name belongs to (for example, “TA” for table namespace, “IX” for
index namespace, and so on).
System metadata
location
Indicates the location of system metadata tables and is of the form
$volume.subvolume, where subvolume is generally ZSD0.
Record descriptor Similar to SQL/MP format objects with respect to the information it
stores, but the format and possible data types are different.
Key descriptor Similar to SQL/MP format objects with respect to the information it
stores, but the format and possible data types are different.
Version
information
Includes the object feature version and object schema version for the
SQL/MX format object.
Partition array For SQL/MX format objects that are partitioned, contains the list of all
the partitions, along with the partitioning key. Note that SQL/MX
format objects can have multiple partitions on the same disk, which
means that the partition array entries must contain the fully qualified
partition name, not just the disk name, as is the case for SQL/MP
format objects.
Index map array Contains the list of all indexes on the SQL/MX format object (if the
object is a table), along with index key information and a list of
partitions associated with each index.
Constraint
information
Contains entries for droppable check constraints. This information is
needed for similarity-checking to determine whether plans need to be
recompiled because of a new or deleted check constraint.
Trigger information Indicates whether or not a trigger is enabled.
Key range
information
The low-key and high-key information for the partition of the SQL/MX
format object used by DP2 to do key-range checking, as is the case
for NonStop SQL/MP.
Logical partition
name information
Contains the logical name information that uniquely identifies the
partition of the SQL/MX format object.
Parent object
ANSI name
Contains the ANSI name associated with the parent SQL/MX format
object. This information is useful for ANSI indexes.
ANSI unique
identifiers
The unique IDs associated with the SQL/MX catalog and schema in
which the SQL/MX format object is registered, as well as the unique
ID of the SQL/MX format object itself.