Restrictions for create database

The SAP ASE server can manage as many as 32,767 databases.

  • The dbid should always be greater than zero and less than the maximum dbid of 32,767.

  • The SAP ASE server can create only one database at a time. If two database creation requests collide, one user sees this message:
    model database in use: cannot create new database
  • Each time you allocate space on a database device with create database or alter database, that allocation represents a device fragment, and the allocation is entered as a row in sysusages.

  • The maximum number of named segments for a database is 32. Segments are named subsets of database devices available to a particular SAP ASE server. For more information about segments, see the System Administration Guide.