SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—640325-001
12-29
Identifying Problem Data and Objects
Resource Fork Run-Time Metadata
Table 12-2 on page 12-29 describes the run-time metadata that is stored in the
resource fork for SQL/MX format objects.
Maximum packed
record length
The maximum byte-length of packed records.
Flags Flags that indicate whether the object is an SQL/MX format object,
and whether the object is a resource fork, audited, in the middle of a
DDL operation, left in the crash-open state, broken, offline, or SQL-
secured.
High-level SQL
version (HLSQLV)
SQL/MX version identifier.
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.
Table 12-1. Label Data Associated With SQL/MX Objects (page2of2)
Label Field Contents