17
CREATE DATABASE failed. Could not allocate enough disk space for a new database on the disks named in the command. Total space allocated must be at least %d Mbytes (%ld 2048-byte pages) to accommodate copy of Model Database.
When you issue a create database command, Adaptive Server:
Assigns space to the database on the specified database devices. If you use the default keyword or if you omit the on clause altogether, Adaptive Server puts the database on one or more of the default database devices specified in master..sysdevices.
Makes a copy of the model database in the new database space, creating the new database’s system tables. The new database thus inherits all the changes you have made to the model database, including the addition of user names and objects.
Error 1803 is raised when Adaptive Server is unable to allocate the space required for the model database on the specified devices.
Make sure that the available space on the database device you specified (or the available space on the default device) will accommodate the model database.
To check the size of model, use the following command:
1> sp_helpdb model 2> go
To check the space available on the device, first use the following commands to check the space already allocated to other databases on the device:
1> use master 2> go
Then enter the following commands, depending on the version of Adaptive Server Enterprise you are using:
Versions earlier than 15.0:
1> select dbid, size, phyname "physical device" 2> from sysusages, sysdevices 3> where name = '<device_name>' 4> and vstart between low and high 5> compute sum(size) 6> go
For example:
1> select dbid, size, phyname "physical device" 2> from sysusages, sysdevices 3> where name = 'sd5f' 4> and vstart between low and high 5> compute sum(size) 6> go
dbid size physical device ------ ------- --------------- 15 17920 /dev/rsd5f 16 20480 /dev/rsd5f 17 7680 /dev/rsd5f 18 20480 /dev/rsd5f 21 5120 /dev/rsd5f sum ======= 71680
Version 15.0 and later:
1> select a.dbid, a.size, b.phyname 2> from sysusages a, sysdevices b 3> where b.name = "testdev" 4> and a.vdevno = b.vdevno 5> compute sum(size) 6> go
Subtract the sum from the total space on your physical device to determine the available space on the database device.
Refer to “model database” in the System Administration Guide: Volume 1 and “create database” in the Reference Manual: Commands for more information.
All versions
