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

2. In the right pane, click Partitions.
The following details appear:
•
Partition Number: — The index number of the partition.
•
System: — The name of the NonStop system where this partition is located.
•
Name: — The partition name that is created by the system.
•
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 primary extent in pages.
•
Secondary Extents: — The size of 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.
Viewing information on related objects
To view information on related objects:
1.
In the navigation tree, select the table.
2. In the right pane, click Related Objects.
The following details appear:
•
Relationship: — This property specifies the relationship of the table with the object. The
available values for this field are
Uses , Used By , and Has .
•
Related Object Type: — This property specifies the type of the related object. The available
values are
Table and View .
•
Related Object Name: — This property specifies the three-part ANSI object name. The
object name is hyperlinked to the related object.
•
Metadata UID: — The internal UID number of the related object.
•
Creation Time: — The time and date when the related object 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 related object was last redefined. The
time and date are expressed in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing DDL information of a table
To view DDL information related to the table:
1.
In the navigation tree, select the table.
Viewing table properties 57