default database size

Summary information

Default value

Logical page size

Range of values

2a –10000a. Minimum determined by server’s logical page size.

Status

Dynamic

Display level

Intermediate

Required role

System Administrator

default database size sets the default number of megabytes allocated to a new user database if the create database statement is issued without any size parameters. A database size given in a create database statement takes precedence over the value set by this configuration parameter.

If most of the new databases on your Adaptive Server require more than one logical page size, you may want to increase the default.

NoteIf you alter the model database, you must also increase the default database size, because the create database command copies model to create a new user database.