Segment Wizard (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

This wizard lets you build and submit an sp_addsegment procedure call, optionally followed by sp_dbextend 'set’, 'database'... and sp_dbextend 'set', 'threshold'... calls. This defines a segment on a database device, and specifies the size by which to grow the database, its maximum size, and a free space level.

To create a new segment using a wizard:

  1. Opening an Object Wizard for a segment.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object. For more information, see Previewing the DDL Generated to Create the New Object.

The Segments Editor opens. You can extend the segment and see the objects stored in the segment. For more information, see Segments Editor (Sybase ASE).

Segments (Sybase ASE) - Properties

When creating or editing a segment, this tab/panel lets you work with the following settings:

Setting Description

Name

Provide a Name for the segment.

Grow By

Provide an sp_dbextend 'set', 'database'... growth rate parameter value, specifying the rate at which the segment grows each time threshold procedures are run.

Threshold Free Space

Provide an sp_dbextend 'set', 'threshold'... free space parameter value, specifying when the threshold procedure is installed on the segment.

Max Size

Provide an sp_dbextend 'set', 'database'... maximum segment size parameter value.

Segments (Sybase ASE) - Location

When creating a segment, this tab/panel lets you select the database device for the segment. Select a device from the Available Devices list and click Place to include the device in the Used Devices list.

Similarly, when editing a segment, this tab/panel lets you extend a segment by adding additional devices. Select a device from the Available Devices list and click Extend to include the device in the Used Devices list.