Summary information |
|
|---|---|
Default value |
10 |
Range of values |
1–2,147,483,647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System administrator |
Configuration groups |
Disk I/O, Memory Use |
number of devices controls the number of database devices Adaptive Server can use. It does not include devices used for database or transaction log dumps.
When you execute disk init, you can also assign the virtual device number (the vdevno), although this value is optional. If you do not assign the vdevno, Adaptive Server assigns the next available virtual device number.
If you do assign the virtual device number, each device number must be unique among the device numbers used by Adaptive Server. The number 0 is reserved for the master device. You can enter any unused device number that falls in the valid range of values.
To determine which numbers are currently in use, enter:
select vdevno from master..sysdevices where status & 2 = 2
Here, “status 2” specifies physical disk.
On UNIX platforms: If you are using a large number of
devices, Sybase recommends that you set the appropriate number of
devices and user connections in the configuration file and then
restart Adaptive Server. Attempting to configure a large number
of devices dynamically using sp_configure may
fail.
