Creating an In-Memory Device

Use a wizard to create an in-memory device—or a cache device—in a cache created for an in-memory database. This device resides on an in-memory storage cache, and allows you to create in-memory databases.

1. In the Administration Console view, select ASE Servers > Space Management > Devices.
2. Click the arrow on In-Memory Devices and select New.
3. (Adaptive Server version 15.5 and later only) Select the server on which to create the in-memory device. If you do not select a valid server
   Note:In-Memory Device wizard is only available for ASE 155 and later release. If no valid server user selected. The wizard will be disabled and error message shows up in the bottom of the Sever selection page.
4. On the Device Name wizard page, enter the logical device name, which Adaptive Server uses in its create database and alter database commands.
5. The In-Memory Storage wizard page displays a list of caches on which to create your in-memory device. On this screen, you can:
   • Add – displays the Specify Cache Device and Size wizard page, and lets you choose a cache to create the device in. The default size of an in-memory device is 6MB. If the in-memory storage is smaller than 6MB, the device size automatically matches the in-memory storage size.
   • Edit – allows the in-memory device to require more space from the in-memory storage. You cannot, however, increase the size of the storage itself.
   • Remove – removes the selected cache.