In the Administration Console view, select ASE Servers > Space Management > Devices.
Click the arrow on Database Devices and select New.
Select the server in which to create the database device.
On the Device Name and Path wizard page, enter:
Device name – the logical device name used in the create database and alter database commands.
Device path – the physical device name, usually in the form of a full path for the new file, or in UNIX, a raw device partition. If you do not specify a device path, the wizard fills this field with the device name with a .dat file extension.
On the Advanced Options wizard page, specify:
The device size in megabytes
The device number – a unique number that identifies this device on the server, Lookup to see what devices use what device numbers on the server. The default in this field is the wizard's recommended number.
Starting address – The virtual starting address, or the offset, for Adaptive Server to begin using the database device. Defines the starting address for this device, and is a virtual offset in 2KB blocks. The default is 0. See Other optional parameters for disk init in the System Administration Guide for information about vstart.
Skip initialization of device – select to speed up the resizing of the device.
Select a write option:
Data sync – Ensures that writes to the database device occur on the physical storage medium. This allows Adaptive Server to recover data from the device when a system failure occurs.
Direct IO – Transfers the data directly to disk, bypassing the operating system's buffer cache.
Cached IO – Turns off the data sync option, and any writes to the database device are buffered into the file system. During system failures, Adaptive Server does not recover any data that has not been updated to the physical medium.
(Optional) On the Mirroring wizard page, you can click Mirror the database device and specify the path for the duplicate device.
Note: If the server is not configured to enable disk mirroring, the options for the Mirroring wizard page are grayed out.