Creating a Temporary Database

Create a temporary database using the SAP Control Center Administration Console.

Prerequisites

Consider these database attributes:

Size:
- sp_estspace helps you estimate table and index space requirements based on the definition of a specific table.
- Space for planned views, stored procedures, defaults, rules, and triggers.
- Size of the transaction log
- Space for anticipated expansion.
Database device location, and whether there is enough space on that device.
Transaction log location – SAP recommends that you store the transaction log on a different device than the data.

Task

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Click Temporary Databases.
Click the drop-down arrow and select New.
On the Introduction screen, select the server in which to create a database.
(Optional, cluster environment only) Click Create this as a local temporary database, then select the online instance on which to create the database.
You can create local user temporary databases on private devices, but you must create local system temporary databases on shared devices. You can use local file system devices (block devices) to manage the storage needs of temporary data in the cluster. These devices are added as private devices and can only be used by local user temporary databases.
On the Database screen, enter the name of the database you want to create.
(Optional, cluster environment only) On the Temporary Database Group screen, select the group to which to add the local temporary database.
You can add a local temporary database only to a temporary database group. You cannot add global temporary databases to a temporary database group.
(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.
(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.
(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.
If you created a database encryption key, you can select Encrypt this database, then specify the name of the database encryption key.
(Optional) On the Temporary Database Group screen, select the database group that the temporary database belongs to.
(Optional) Click Summary to view your selected options.