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

2. In the right pane, click Attributes.
The following details related to attributes appear:
•
Name: — The name of the sequence generator.
•
Metadata UID: — A unique ID number of the sequence generator.
•
Start With: — The first sequence number to be generated.
•
Increment By: — The increment value of the sequence generator.
•
Min Value: — The minimum value of the sequence generator.
•
Max Value: — The maximum value of the sequence generator.
•
Cycle Option: — This attribute specifies the behavior of the sequence generator on reaching
either the maximum or minimum value. The available values are Yes and No.
•
Location: — This attribute specifies a volume and optionally a node, subvolume, and the
filename of the SG table. For more information, see the SQL/MX 3.2.1 Reference Manual.
•
Creation Time: — The time and date when the sequence generator was created. The time
and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the sequence generator was last redefined.
The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing DDL information of a sequence generator
To view DDL information related to the sequence generator:
1.
In the navigation tree, select the sequence generator.
2. In the right pane, click DDL.
The DDL statement appears.
Viewing information related to sequence generator privileges
To view information related to the sequence generator privileges:
1.
In the navigation tree, select the sequence generator.
2. In the right pane, click Privileges.
The following details related to the sequence generator privileges appear:
•
Grantee: — The name of the user whose privilege is described. A grantee can be PUBLIC.
•
Grantor: — The name of the user who granted the privileges or the special SQL user
names SYSTEM. A grantor cannot be PUBLIC.
•
With Grant: — This attribute indicates whether the user has grant privileges.
•
Grant Level: — The level at which the permissions are visible.
•
Privileges: — The value is a list of granted privileges separated by commas. DDL and
DML privileges are grouped accordingly. For the list of privileges, see the HP NonStop
SQL/MX Release 3.2.1 Reference Manual.
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.1.
To view information related to table statistics:
Viewing table statistics and their properties 75