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.
If 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.