When you create a new database file, you can preallocate database space using the DATABASE SIZE clause of the CREATE DATABASE statement or by specifying the dbinit -dbs option. See CREATE DATABASE statement, and Initialization utility (dbinit).

As you use the database, SQL Anywhere automatically grows database files as needed. Rapidly-changing database files can lead to excessive file fragmentation on the disk, resulting in potential performance problems. As well, many small allocations are slower than one large allocation. If you are working with a database with a high rate of change, you can preallocate disk space for dbspaces or for transaction logs using either Sybase Central or the ALTER DBSPACE statement. See ALTER DBSPACE statement.

 Preallocate space (Sybase Central)

 Preallocate space (SQL)

 See also

 Examples

ALTER DBSPACE system
ADD 200;

ALTER DBSPACE system
ADD 400 MB;