User Guide > User Guide > Working with Databases > Creating and Deleting Databases > Creating a Database
Was this helpful?
Creating a Database
To create a new database, you specify a database name and then configure any required options.
The following conditions must be met before you can create a database:
• The Instance Explorer must be connected to the installation in which you want to create the database (see Connecting to an Ingres or Actian Vector Installation).
• A Database folder or database node in the connected instance must be selected in the Instance Explorer.
You can create a database in the following ways:
• From the Start Page: New Database
• From the context menu of a database node: New Database
• From the context menu of the Databases folder node: New Database
• On the main menu ribbon when a Databases folder node or a user database node is selected in the Instance Explorer: Database, Database, New Database (see Database Tab)
For more information, see Create a Database.
New Database Dialog
The New Database dialog contains the following pages:
• General—see General Page (New Database)
• Options—see Options Page (New Database) (not available for Actian Vector)
• Locations—see Locations Page (New Database)
• Output Log—see Output Log (New Database)
For more information, see Create a Database.
General Page (New Database)
The General page of the New Database dialog contains the following fields:
Name
Specifies the name of the database. For more information, see Object Naming Rules.
Effective User
Specifies the effective user name for the session. Valid only for a privileged user, DBA, or sessions that have the db_admin database privilege.
Some commands, including Backup Database (see Backup Database Dialog), Restore Database (see Restore Database Dialog), Verify Database (see Verify Database Dialog), Create Database (see General Page (New Database)), and Delete Database (see Delete Database Dialog) restrict the use of the effective user option to privileged users.
Note:  This option does not assume the group of the effective user.
Options Page (New Database)
The Options page contains a properties grid where you can configure options for creating the database. The properties grid has the following sections:
• General
• Front-End Catalogs
• Advanced
Note:  The Options page is not available for Actian Vector databases.
General Options
The General section contains the following fields:
Unicode
Specifies whether the new database can contain columns with Unicode data types (for example, NCHAR and NVARCHAR)
Normalization
Specifies the normalization to use when the database is Unicode-enabled. This can be one of the following:
NFD
Specifies Normalization Form D, more useful for internal processing
NFC
Specifies Normalization Form C, the best form for generated text
This option is enabled only if the Unicode option is selected.
Catalog Page Size
Specifies the page size for catalogs. Possible values are:
• Default
• 2K
• 4K
• 8K
• 16K
• 32K
• 64K
Collation
Specifies the collation to use for the database. The available collation values are dependent on whether Unicode is selected.
Front-End Catalogs Options
The Front-End Catalogs section contains the following fields:
Generate Front-End Catalogs
Specifies whether front-end catalogs should be generated in the database. If this option is not checked, then all other options in this category are disabled.
Legacy Front-End Catalogs
Specifies whether ABF, QBF, RBF, VIFRED, DBD, and Vision catalogs should be generated
OpenROAD Catalogs
Specifies whether OpenROAD catalogs should be generated
Advanced Options
The Advanced section contains the following fields:
No X100 Tables
Specifies that Ingres should not run an X100 engine for the database because there are no X100 tables in the database
Read Only
Specifies whether the database is read-only. Selecting this option enables the Read Only Database Location property. Clearing the field disables it.
Read Only Database Location
Specifies the CD-ROM, DVD, (or other read-only area) where the database resides. This option is enabled only if the Read Only option is checked.
Distributed (Star)
Specifies whether the database is a distributed Star database. You can override the default coordinator database name in the following field.
Coordinator Database
(Optional) Available only if the Distributed (Star) option is checked. Overrides the default coordinator database name stored in the Ingres Star catalogs. The default name of the coordinator database that is assigned is the database name you specified in the Name field on the General page, prefixed with ii.
Private
Specifies whether the database is private. A private database is accessible only to Ingres installation users who have been granted access to that database by the database creator or by a user with the necessary security rights.
Always Logged
Specifies whether all operations in this database are always logged
Locations Page (New Database)
The Locations page lets you assign alternate disk locations for the various types of database files. To specify an alternate location, you must have created it first; for more information, see Create a Location.
The Locations page contains the following selectable fields:
Database
The location used for the database files
Default: ii_database (displayed as [default])
Work
The location to use for work files
Default: ii_work (displayed as [default])
Dump
The location to use for dump files
Default: ii_dump (displayed as [default])
Journal
The location to use for journal files
Default: ii_journal (displayed as [default])
Checkpoint
The location to use for checkpoint files (database backups)
Default: ii_checkpoint (displayed as [default])
Output Log (New Database)
When you click OK on the New Database dialog, the Output Log page displays the contents of the output log as the database is created.
Create a Database
To create a new database, the Instance Explorer must be connected to the installation in which you want to create the database (see Connect to an Actian Database Instance). You must also have the Create Database privilege (see Privileges Page (User)).
To create a database
1. In the Instance Explorer, right-click the Databases folder for a connected installation and select New Database from the context menu.
The New Database dialog opens, displaying the General page (see General Page (New Database)).
2. Enter a unique name for the database.
For more information, see Object Naming Rules (see Object Naming Rules).
3. Click the link for the Options page (see Options Page (New Database)).
Note:  This page is not available for Actian Vector databases.
4. Specify any options for the database.
5. Click the link for the Locations page (see Locations Page (New Database)).
6. If you have configured more than one location for a location type, you can select the location in the Name column. (If not, all fields are read-only).
7. Click OK to create the database.
The Output Log page is displayed (see Output Log (New Database)), and creation progress is reported there.
8. Click Close to close the dialog.
The new database is listed under the Databases folder in the Instance Explorer.
Last modified date: 06/06/2024