Configuring and Managing Vector
X100 Configuration File (vectorwise.conf)
The Vector engine uses its own configuration file called vectorwise.conf.
A configuration file is not required. If no configuration file exists, default values are used.
Per-installation configuration file
II_DATABASE/ingres/data/vectorwise/vectorwise.conf
This file is installed by default. It contains examples of available configuration parameters.
Per-database configuration file
II_DATABASE/ingres/data/vectorwise/vectorwise.dbname.conf
or
$DATABASE_ROOT_AREA/ingres/data/vectorwise/dbname/vectorwise.conf
where dbname is the name of the database, and
$DATABASE_ROOT_AREA is the area associated with the data location specified with the createdb -v option, or -d if no -v was given, or II_DATABASE if neither was given.
No per-database configuration file is installed automatically, but there is a template in $II_SYSTEM/ingres/files/vectorwise.db.conf_TMPL that can be used as a guide if a per-database configuration is needed.
Important! If you want to configure settings for a single database that influence the database creation process (for example: [cbm] block_size), you must create the vectorwise.dbname.conf file with the desired settings before creating the database.
The order of precedence of the various configuration files is as follows (#1 overrides #2, which overrides #3):
1. vectorwise.conf in the vectorwise/dbname directory
2. vectorwise.dbname.conf in the vectorwise directory
3. vectorwise.conf (the installation wide configuration)