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.
- In the left pane of the Administration Console, expand .
- Click the drop-down arrow on In-Memory Devices and select New.
- (Adaptive Server version 15.5 and later only) Select the server on which to create the in-memory device.
Note: The In-Memory Device wizard is only available for Adaptive Server 15.5 and later releases. If a valid server user is not selected, the wizard will be disabled and error messages will be displayed at the bottom of the server selection page.
- On the Device Name screen, enter the logical device name, which Adaptive Server uses in its create database and alter database commands.
- 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.