To create a pool of default database devices to be used by all Adaptive Server users for creating databases, use sp_diskdefault after the devices are initialized. sp_diskdefault marks these devices in sysdevices as default devices. Whenever users create (or alter) databases without specifying a database device, new disk space is allocated from the pool of default disk space.
The syntax for sp_diskdefault is:
sp_diskdefault logicalname, {defaulton | defaultoff}
You are most likely to use the defaultoff option to remove the master device from the pool of default space:
sp_diskdefault master, defaultoff
The following command makes sprocdev, the device that holds the sybsystemprocs database, a default device:
sp_diskdefault sprocdev, defaulton
Adaptive Server can have multiple default devices. They are used in the order in which they appear in the sysdevices table (that is, alphabetical order). When the first default device is filled, the second default device is used, and so on.
After initializing a set of database devices, you may
want to assign them to specific databases or database objects rather
than adding them to the default pool of devices. For example, you
may want to make sure a table never grows beyond the size of a particular
device.
