Creating a Temporary Database

Create a temporary database using the Administration Console of Sybase Control Center.

Prerequisites

Consider these database attributes:

Size :
- sp_estspace helps you estimate table and index space requirements based on the definition of a specific table. See the Adaptive Server Reference Manual .
- 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 – Sybase recommends that you store the transaction log on a different device than the data.

Task

Sybase Control Center provides a wizard to create a temporary database.

In the Administration Console view, select Server > Schema Objects > Databases.
Click Temporary Databases.
Select New.
You see the Create Temporary Database Wizard.
On the Introduction screen, select the server in which to create a database.
On the Database screen, enter the name of the database you want to create.
(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:
- With override to store the log and data on the same logical device - this is not recommended by Sybase.
(Optional) On the Data Compression screen, select:
- Data compression for the entire database – choose either page-level or row-level compression. If you choose neither option, then data is not compressed.
- LOB compression – choose from levels 0 – 9, 100, or 101.
- In-row LOB length – choose 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 only apply to nonclustered Adaptive Server version 15.7 and later.
(Optional) On the Temporary Database Group screen, select the database group that the temporary database belongs to.
(Optional) Click Summary to see the database options you have selected.