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

6. Select an SQL/MP alias.
In the right pane, the following tabs related to the procedure appear:
•
Attributes
•
DDL
Figure 25 (page 72) shows the properties of an SQL/MP alias.
Figure 25 SQL/MP alias properties
Viewing attributes of the SQL/MP alias
To view the attributes of a SQL/MP alias:
1.
In the navigation tree, select the SQL/MP alias.
2. In the right pane, click Attributes.
The following details related to attributes appear:
•
Name — The name of the SQL/MP alias.
•
Metadata UID — A unique ID number of the SQL/MP alias.
•
SQL/MP table: — The Guardian location of the SQL/MP table associated with the alias.
Viewing DDL information of a SQL/MP alias
To view DDL information related to the SQL/MP alias:
1.
In the navigation tree, select the SQL/MP alias.
2. In the right pane, click DDL.
The DDL tab displays a statement that you can use to create the SQL/MP Alias.
Viewing table statistics and their properties
MXDM enables you to view table statistics. You can use the table statistics to troubleshoot and to
create additional indexes. To view table statistics, the default catalog (
NONSTOP_SYSTEM_NSK )
and the default schema ( PUBLIC_ACCESS_SCHEMA ) are required. If the default catalog and
schema are not available, table statistics are not displayed. For information on creating the default
catalog and schema, see the HP NonStop SQL/MX Connectivity Service Manual for SQL/MX
Release 3.2.
To view information related to table statistics:
1.
Log on to the HP NonStop SQL/MX Database Manager.
72 Viewing database objects