Creating a User Database

Create a user 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 User 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. (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.

    If you created a database encryption key, you can select Encrypt this database, then specify the name of the database encryption key.

  8. (Optional) On the Durability Level screen, choose one of these levels to improve server performance by reducing the recoverability in case of a system failure:
    • NO_RECOVERY – there is no guarantee that, at runtime, committed transactions are written to the disk.
    • AT_SHUTDOWN – all committed transactions are written to disk during a normal server shutdown.
    • FULL – a complete recovery of committed transactions is possible after a system failure.
    Note: These options apply only to nonclustered version 15.5 and later.
  9. (Optional) On the Data Compression screen, select:
    • Data compression for the entire database – either page-level or row-level compression. If you choose neither option, then data is not compressed.
    • LOB compression – from levels 0 – 9, 100, or 101.
    • In-row LOB length – the length of the LOB column to be saved in-row. To disallow in-row LOB storage in the database, set the length to 0.
    Note: These options apply only to nonclustered version 15.7 and later.
  10. (Optional) Use the Guest User screen, to create a guest user who can access the database with limited privileges.
  11. (Optional) Click Summary to view your selected options.
Related tasks
Creating a Temporary Database
Creating a Proxy Database
Creating an Archive Database
Creating an In-Memory Database
Creating an In-Memory Temporary Database
Creating a Temporary Database Group
Mounting an SAP ASE Database
Creating a Database Encryption Key
Related reference
Database Properties