Installation and Configuration › How to Prepare Your DBMS Environment › Tasks to Create a Sybase DBMS

Tasks to Create a Sybase DBMS

The DBA and the system administrator responsible for installing the software on a Sybase database management system perform the following tasks:

1. Use a graphical user interface (GUI) tool, ISQL (all versions), SQL Administrator, Sybase Central Java, or Enterprise Manager to create the mart database. If a GUI tool is not available, use ISQL to type the appropriate commands manually.

   Your database must meet the following criteria:

   • The size of the data device you create determines the size of the database. The minimum database size is 32 MB so there has to be at least one device that is 32 MB. Create the data device on a different disk (and disk controller) than the transaction log.
   • For optimum performance, verify that separate devices are used to store the data and the transaction log. For example, you can increase performance by creating a 50-MB data device and a 25-MB log device. A minimum of 40 MB of disk space (data and log) is required.
2. Add users.

   For users to access the mart, either add existing logins as users to the database, or create logins and add them as users. A login is an entity permitted to connect to the database server; a user gives a login the right to use a particular database. If you use Windows user names and passwords to secure database access (Windows Authentication), add the Windows users to your DBMS.

3. Verify the Stored Procedure Cache.

   Set the Stored Procedure Cache size to at least 8 MB. Setting it higher improves performance, especially when many users are accessing the server concurrently. Setting it lower results in fatal errors and rollbacks when the Stored Procedure Cache size is exceeded.

   Note: The installation creates more than 100 stored procedures. The client invokes these stored procedures to control changes to the data in the database.

4. Verify tempdb size.

   Significant temporary space is required for installation and use. The temporary segments need at least 16 MB of available space. Increase the available space as the number of concurrent users increase.

5. Verify the memory allocated to the database server.

   Allocate at least 32 MB of RAM to the database server. The amount of RAM allocated is ideally half of the available RAM on the server.