Creating an In-Memory Temporary Database

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

Prerequisites

Consider these database attributes:

Task
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Click In-Memory Temporary Databases.
  3. Click the drop-down arrow and select New.
    You see the Add In-Memory Temporary Database wizard.
  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. (Optional) 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) On the Temporary Database Group screen, select the database group that the temporary database belongs to.
  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 Database
Creating a Temporary Database Group
Mounting an SAP ASE Database
Related reference
Database Properties