Segment Properties

Use the Segment Properties wizard to modify database devices, tables, and thresholds.

Click Properties on your segment—the label that points to one or more database devices—to initiate the Properties wizard.

Wizard OptionSegment Properties
General
Displays the segment's summary information that appears in the segments list view, as well as the segment's hysteresis value. See Managing Free Space with Thresholds in the System Administration Guide for information about the hysteresis value.
Specify how to show the current size:
  • Pages
  • Kilobytes
  • (Default) Megabytes
  • Gigabytes
Devices
Displays the database devices used by the segment, and their sizes, in megabytes. You can also:
Contains
Displays:
  • Tables that use the segment – the list includes both the table name and its owner.
  • Indexes that use the segment – the list includes both the index name and the table the index uses.
Thresholds
Displays thresholds that are added to the segment in the form of system procedures and their owners. You can also add and remove thresholds. See Adding a Threshold to a Segment.
Parent topic: Manage Segments
Related tasks
Adding a Database Device to a Segment
Removing a Database Device from a Segment
Adding a Threshold to a Segment
Removing a Threshold from a Segment