Summary information |
|
|---|---|
Default value |
10 |
Range of values |
1–256 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System Administrator |
The number of devices parameter 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 device number (the vdevno). although this value is optional. If you do not assign a vdevno, Adaptive Server assigns the next available virtual device number.
If you do assign a 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. Legal numbers are 1–256. However, the highest number must be 1 less than the number of database devices you have configured for Adaptive Server. For example, if you configured your server for 10 devices, the legal range of device numbers is 1–9.
To determine which numbers are currently in use, run sp_helpdevice and look in the device_number column of output.
If you want to lower the number of devices value after you have added database devices, you must first check to see what device numbers are already in use by database devices. The following command prints the highest value in use:
select max(low/power(2,24))+1 from master..sysdevices
WARNING! If you set the number of devices value too low in your configuration file, Adaptive Server cannot start. You can find the devices in use by checking the sysdevices system table.
