How to Alter the number of devices Parameter Manually

This step is necessary only if you are using a virtual device number (vdevno) that is greater than the default value for the number of devices configuration parameter (in this case, some of your devices will be inaccessible until you perform this step). The default value for number of devices is 10 on most platforms.

NotePerform this task only if the configuration file prior to an Adaptive Server crash is lost. If the configuration file is available, use that file to start up Adaptive Server or use the number of devices from the last configuration file.

To aid in the recovery process, determine whether this step will be needed before an actual disaster. Do this by examining the device_number column in the sp_helpdevice output.

If Adaptive Server is not up and running, check the start-up section of the most recent error log, which contains the device number.

If a virtual device number greater than the default is being used, increase the number of devices parameter in the configuration file before you start Adaptive Server. For example, if the highest vdevno in use is 30 and the default is 10, edit the configuration file to set the number of devices parameter to 31.