DBMS Server Installation Parameters
The parameter settings when installing the Ingres DBMS Server are as follows (environment variables are shown in parentheses):
Database location (II_DATABASE)
Defines the location for the Ingres master database (iidbdb) and the default location for database files.
Checkpoint files location (II_CHECKPOINT)
Defines the location for the checkpoint files that serve as a static backup of the database.
Journal files location (II_JOURNAL)
Defines the location for the journal files, which provide a dynamic record of changes made to Ingres databases since the last checkpoint.
Dump files location (II_DUMP)
Defines the location for the dump files used to perform online backups.
Temporary work files location (II_WORK)
Defines the location for temporary files created during external sorts and other DBMS Server operations.
Transaction log location (II_LOG_FILE)
Defines the location of the transaction log file.
Dual transaction log location (II_DUAL_LOG)
Defines the location of the backup transaction log file.
Transaction log file size (II_LOG_FILE_SIZE_MB)
Defines the default size of the transaction log file. The default size (256 MB per file) is adequate for most instances. You should change the file size only if you have an existing application that requires a larger transaction log file.
Connection Limit (II_CONNECT_LIMIT)
Specifies the maximum number of concurrent users.
Time zone (II_TIMEZONE_NAME)
Specifies the region and time zone.
Character set (II_CHARSET)
Specifies the character set.
Date Alias (II_DATE_TYPE_ALIAS)
Specifies whether date columns should use ANSI date or Ingres date data type.
Configuration type (II_CONFIG_TYPE)
Specifies a configuration type, which determines Ingres configuration parameter settings based on how Ingres will be used.