Creating .dat files for database devices

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:

  1. If the /devices directory does not exist, create it from the command prompt:

     mkdir devices
  2. 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
  3. 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.