Administrator Guide : Administering solidDB® : Creating a new database
  
Creating a new database
solidDB® databases are created at solidDB® server startup.
When solidDB® is started, it checks if a database exists. If a database does not exist, solidDB® prompts you to create a database.
In Windows environments, a dialog window prompts you for the username and password of the database administrator, and a name for the default (system) catalog.
In Linux and UNIX environments, the following message appears:
Database does not exist. Do you want to create a new database (y/n)?
By answering “yes”, solidDB® prompts you for the username and password of the database administrator, and a name for the default (system) catalog.
Note You must remember your user name and password to be able to connect to solidDB®. There are no default user names. The administrator user name you enter when creating the database is the only user name available for connecting to the new database for the first time.
After accepting the username and password of the database administrator, solidDB® creates the database.
By default the database is created as one file (solid.db) in the solidDB® working directory.
The database size depends on the value of the block size that is set for the database (the value of the parameter IndexFile.BlockSize, see IndexFile section).
Block size
Database size
2Kb
1Mb
16Kb
8Mb
64Kb
32Mb
The size of the disk allocation is controlled by the IndexFile.ExtendIncrement parameter. This parameter and other parameters are discussed in Server-side configuration parameters.
The maximum database size is also controlled by the block size. The maximum database size is (4Gb - 1) * block size. Therefore, with the default 16Kb block size, the maximum database size is 64 TB - 1.
After the database has been created, solidDB® starts listening to the network for client connection requests. In Windows environments, a solidDB® icon appears, but in most environments solidDB® runs invisibly in the background as a daemon process.
See also
Usernames, passwords, and system catalog names
Unicode and partial Unicode database modes
Setting up database environment
solidDB® configuration file (solid.ini)
Setting database block size (BlockSize) and location (FileSpec)
Defining database objects
Administering solidDB®