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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-19
Locating System Defaults Schema Tables
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 563
AuditCompress: T
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has
failed)
CrashLabel: F
CrashOpen: F
IncompletePartBoundChg: F (If T, a Utility operation is in
progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress
or has failed)
Primary Extent Size: 128 Pages
Secondary Extent Size: 256 Pages
Max Extents: 512
Extents Allocated: 1
EOF: 12288
Index Levels: 2
•
This example is more complex. It uses a SELECT statement to access information
from the PARTITIONS, OBJECTS, SCHEMATA, and CATSYS tables to display the
partition that contains the SYSTEM_DEFAULTS table. Then it uses the ls
command on that volume and subvolume to get a list of the default schema table
names. The additional files in the subvolume $DATA08.ZSDA984F are the user
metadata tables that contain histogram information.
# mxci
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface
2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
>> set schema
nonstop_sqlmx_figaro.definition_schema_version_1200;
--- SQL operation complete.
>> select substring(object_name, 1, 23) as table_name,
substring(p.system_name, 1, 15) as system,
p.data_source,
p.file_suffix
from partitions p, objects o
where
o.object_type = 'BT' and
o.object_name = 'SYSTEM_DEFAULTS' and
o.object_uid = p.object_uid and
o.schema_uid =