Creating a Database and Loading Data
Create a Database
To create a database, you must have the createdb privilege, which is granted by default to the installation owner. You can create a database through a command on the command line, or through Actian Director.
To create a database
Issue this command at the command line:
createdb dbname
where dbname is the name of the database.
The database is created in the default locations for the installation, uses the UTF8 character set, and is Unicode enabled with Normalization Form C (NFC).
To create a database with its data and checkpoint files on different devices
createdb bigdb -ddb_vw -cnewckp_vw
The bigdb database is created in a new default location db_vw; its checkpoint files are created in the newckp_vw location. The locations were defined previously with CREATE LOCATION statements.
Database Default Configuration
Unless you changed the defaults during the installation, the database will configure 50% of the total system memory for processing and 25% of the total system memory for the data buffer.
Last modified date: 12/06/2024