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

2. In the right pane, click Partitions.
The following details related to table index partitions appear:
•
Partition Number: — The name of the column (string).
•
System: — This attribute specifies the sort order as Ascending or Descending .
•
Name: — This attribute specifies whether the column was added by the system or a user.
•
File: — The physical file where the partition is located.
•
Percent allocated: — The percentage of the partition used.
•
Row count: — The number of rows in the partition.
•
Rows Inserted Since Last Update Stats: — The number of rows inserted after the Update
Statistics command was last run.
•
Rows Deleted Since Last Update Stats: — The number of rows deleted after the Update
Statistics command was last run.
•
Rows Updated Since Last Update Stats: — The number of rows updated after the Update
Statistics command was last run.
•
Primary Extents: — The size of the primary extent in pages.
•
Secondary Extents: — The size of the secondary extents in pages.
•
Max Extents: — The maximum number of extents.
•
Allocated Extents: — The number of extents allocated.
•
Max Size: — The maximum size of the partition.
•
Current EOF: — The space used in the partition.
Displaying table triggers and their properties
A trigger is a mechanism that resides in the database and specifies that when a particular action—an
insert, delete, or update occurs on a table, SQL/MX should automatically perform one or more
additional actions.
To view the table triggers:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. Under the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. In the navigation tree, expand the contents of the system .
The list of catalogs appears.
4. Expand the contents of a catalog.
The list of schemas appears.
5. Expand the contents of a schema.
The Tables folder appears.
6. Expand the contents of a table.
The Indexes and Triggers folders appear.
Viewing table properties 61