HP Integrity NonStop J-Series - Manual (Page 50)

2. In the right pane, click Registrations.
The following details appear:
•
System: — The system where this catalog is registered.
•
Location: — The physical volume where the catalog is registered.
•
Rule: — The replication rule. The rule can be automatic or manual.
Viewing schemas within a catalog
To view the schemas in the catalog:
1.
In the navigation tree, select the catalog.
2. In the right pane or the Schemas folder within the catalog, click Schemas.
The following details appear:
•
Name: — The name of the schema.
•
Owner: — The user who created the schema.
•
Version: — The schema version.
•
Location: — The physical volume where the schema is located.
•
Metadata UID: — The Internal UID number of the schema.
Viewing catalog DDL
To view the catalog DDL:
1.
In the navigation tree, select the catalog.
2. In the right pane, click DDL.
The DDL statement appears.
Viewing schemas
To view the schemas in a catalog:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. In the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. Expand the contents of the system in the navigation tree.
The list of catalogs appear.
4. Expand the contents of a catalog.
The list of schemas appear.
50 Viewing database objects