Extending the Scope of Segments

You may need to extend a segment if the database object or objects assigned to the segment run out of space. sp_extendsegment adds database devices to an existing segment.

Before you can extend a segment:

The database device must be listed in sysdevices,
The database device must be available to the database you are extending, and
The segment name must exist in the current database.

The following example adds the database device pubs_dev2 to an existing segment named bigseg:

sp_extendsegment bigseg, pubs2, pubs_dev2

To extend the default segment in your database, place the word “default” in quotes:

sp_extendsegment "default", mydata, newdevice

See the Reference Manual: Procedures.

Automatically Extending the Scope of a Segment
If you use alter database to add space on a database device that is new to the database, the system and default segments are extended to include the new space. Thus, the scope of the system and default segments is extended each time you add a new device to the database.

Parent topic: Changing the Scope of Segments