Segments Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Segments Editor lets you manage segment location, associated objects, segment space, and segment thresholds.

To edit a segment

  1. Open an editor on the segment. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


This tab lets you view the Name and Max Size settings you specified when creating the segment. It also lets you change the Grow By and Threshold Free Space settings. For information on these settings, see Segments (Sybase ASE) - Properties. This tab also displays a Hysteresis value, the global variable @@thresh_hysteresis, that controls threshold sensitivity to variations in free space.


Lets you Drop or Extend selected segments.


Lets you manage database objects associated with the segment. Objects are organized in a tree structure. You can open an object editor on a table, index, or constraint by double-clicking that object. For information on specific editors, see Sybase ASE Object Editors.


Displays a summary of segment space distribution, broken down into data, indexes, unused, and other. Also provides reserved, data, indexes, and unused space values for each object on the segment.


Displays a list of the free pages thresholds for the segment. For a selected threshold, the Property/Value list displays the associated procedure name. Optionally you can:

Click the Add button to specify the number of free pages and procedure name for a new segment threshold.

Select an existing threshold and modify the threshold’s procedure name value.

Select an existing threshold and click the Delete button to delete that threshold


For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.