If you choose to create a new device, use the disk init command to specify the drive, path, and file name of the database device.
To create a database device using the file /devices/user1.dat:
If the /devices directory does not exist, create it from the command prompt:
mkdir devices
Start isql and connect to Adaptive Server using the “sa” account:
/sybase/bin> isql -Usa -Ppassword -Sserver_name
On Mac OS X, enter:
$SYBASE/$SYBASE_OCS/bin> isql
Create the device using a disk init statement similar to the following example:
disk init name = "user_device1", physname = "/work/data/device1", size = 2048
The previous example creates a 4MB device, as measured in 2K pages, without an actual device number. To use a specific number, run sp_helpdevice to determine the number of an available device, and enter that number.
For more information about sp_helpdevice and disk init command, see the System Administration Guide and the Reference Manual.
For more information about device files, see the Performance and Tuning Guide.
