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.

WARNING! Do not place Adaptive Server devices on network drives, as this causes unpredictable system behavior. Also, if your Adaptive Server uses a network drive, you cannot start the server as an automatic NT service.

To create a database device using the file d:\devices\user1.dat:

  1. If the d:\devices directory does not exist, create it from the NT command-prompt:

    d:\> mkdir devices
  2. Start isql and connect to Adaptive Server using the “sa” account:

    d:\sybase\bin> isql -Usa -Ppassword -Sserver_name
  3. Create the device using a disk init statement similar to the following example:

    1> disk init
    2> name = "user_device1",
    3>physname = "d:\devices\user1.dat",
    4>size = 4M
    5> go

    This example creates a 4MB device, 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 using “vdevno = (number)”.

For more information about sp_helpdevice and the disk init command, see the System Administration Guide and the Adaptive Server Reference Manual.

For more information about device files, see the Performance and Tuning Guide.

NoteRaw partitions for database devices provide little performance advantage over files as database devices and might have been favored in past releases for cache coherence and security. However, because the Windows NT file system now addresses these concerns, it is recommended that you do not use raw partitions.