Creating an In-Memory Device

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 left pane of the Administration Console, expand ASE Servers > Space Management > Devices.
  2. Click In-Memory Devices.
  3. Click the drop-down arrow and select New.
  4. Select the server on which to create the in-memory device.
    Note: The In-Memory Device wizard is available only in SAP ASE 15.5 and later. If you do not select a valid server, the wizard is disabled and you see error messages at the bottom of the server selection page.
  5. On the Device Name screen, enter the logical device name, which the server uses in its create database and alter database commands.
  6. The In-Memory Storage screen 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.