Displaying table partition properties

To display the partition properties:

Procedure

  1. Select a table in the left pane.
  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 or can be created by the user.

    • File: The physical file where the partition is located.

    • First Key: This specifies the lowest values in the partition for columns stored in ascending order and the highest values in the partition for columns stored in descending order. It is displayed only if the table is range partitioned.

    • Percent allocated: The percentage of the partition used.

    • Primary Extents: The size of primary extents in pages.

    • Secondary Extents: The size of secondary extents in pages.

    • Max Extents: The maximum number of extents in the partition.

    • Allocated Extents: The number of extents allocated in the partition.

    • Max Size: The maximum size of the partition.

    • Current EOF: The space used in the partition.