Create a user database using the Sybase 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. 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.
- In the left pane of the Administration Console, expand .
- Click User Databases.
- Click the drop-down arrow and select New.
You see the Add User 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.
- For load if you want the database to be used for loading a database dump.
- (Optional) On the Durability Level screen, choose one of these levels to increase the performance of the server by reducing the recoverability in case of a system crash:
- 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 crash.
Note: These options only apply to nonclustered Adaptive Server version 15.5 and later.
- (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 Guest User screen, select Create guest user to create a guest user who can access the database with limited privileges.
- (Optional) Click Summary to see the database options you have selected.