Creating an In-Memory Database

Create an in-memory database using the SAP Control Center Administration Console.


Consider these database attributes:

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Click In-Memory Databases.
  3. Click the drop-down arrow and select New.
  4. On the Introduction screen, select the server in which to create a database.
  5. On the Database screen, enter the name of the database you want to create.
  6. On the Devices screen, enter the size of the new database. If you do not enter a size, the default size allocated is 3MB. You can specify separately the amount of space to allocate to the log and data segments.
  7. (Optional) On the Options screen, select:
    • (Not recommended) With override to store the log and data on the same logical device.
    • For load to use the database for loading a database dump.
    • Specify a template database that is copied over to create the in-memory database.
  8. (Optional) Use the Guest User screen, to create a guest user who can access the database with limited privileges.
  9. (Optional) Click Summary to view your selected options.
Related tasks
Creating a User Database
Creating a Temporary Database
Creating a Proxy Database
Creating an Archive Database
Creating an In-Memory Temporary Database
Creating a Temporary Database Group
Mounting an SAP ASE Database
Related reference
Database Properties