Ingres DBMS Server Installation Parameters that Ingres database server products and their utilities use.
*
The parameter settings when installing the Ingres DBMS Server are as follows (environment variables are shown in parentheses):
II_DATABASE
Database location (II_DATABASE)
Defines the location for the Ingres master database (iidbdb) and the default location for database files.
II_CHECKPOINT
Checkpoint files location (II_CHECKPOINT)
Defines the location for the checkpoint files that serve as a static backup of the database
II_JOURNAL
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.
II_DUMP
Dump files location (II_DUMP)
Defines the location for the dump files used to perform online backups.
II_WORK
Temporary work files location (II_WORK)
Defines the location for temporary files created during external sorts and other DBMS Server operations.
II_LOG_FILE
Transaction log location (II_LOG_FILE)
Defines the location of the transaction log file.
II_DUAL_LOG
Dual transaction log location (II_DUAL_LOG)
Defines the location of the backup transaction log file
II_LOG_FILE_SIZE_MB
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
Start Ingres under….account (II_SERVICE_START_USER) (Windows only)
II_CONNECT_LIMIT
Connection Limit (II_CONNECT_LIMIT)
Specifies the maximum number of concurrent users.
II_TIMEZONE_NAME
Time zone (II_TIMEZONE_NAME)
Specifies the region and time zone.
II_CHARSET
Character set (II_CHARSET)
Specifies the character set.
II_DATE_TYPE_ALIAS
Date Alias (II_DATE_TYPE_ALIAS)
Specifies whether date columns should use ANSI date or Ingres date data type.
II_CONFIG_TYPE
Configuration type (II_CONFIG_TYPE)
Specifies a configuration type, which determines Ingres configuration parameter settings based on how Ingres will be used.