Response File Parameters
Parameters in the response file determine how Vector is to be installed and configured.
Some parameters are valid on certain operating systems only or generated by certain installation methods only.
CONNECT_LIMIT
Valid on Linux
CONNECT_LIMIT specifies the maximum number of concurrent users.
II_ADD_REMOVE_PROGRAMS
Valid on Windows
The II_ADD_REMOVE_PROGRAMS parameter defines whether Vector is added to the Programs and Features (or in Windows XP, Add/Remove Programs) folder in Windows.
This parameter has the following options:
YES
(Default) Add the product to the Programs and Features folder in Windows.
NO
Do not add the product to the Programs and Features folder in Windows.
II_ADD_TO_PATH
Valid on Windows
The II_ADD_TO_PATH parameter defines whether to add Vector to the Windows PATH.
This parameter has the following options:
YES
(Default) Add the product to the Windows PATH.
NO
Do not add the product to the Windows PATH.
II_AUTH_STRING
The II_AUTH_STRING parameter defines the authorization string required for an evaluation version of the product. The authorization string is emailed to you when you download the product.
II_CHARSET
The II_CHARSET parameter defines the character set. It cannot be changed.
Default: UTF8
II_CHECKPOINT
The II_CHECKPOINT parameter defines the location of the checkpoint files that serve as a static backup of the database. This parameter cannot be changed, even during installation updates. Specific databases can designate alternate locations for checkpoints as a parameter to the createdb command.
Default: Same as II_SYSTEM
II_COMPONENT_CORE
Valid on Linux
The II_COMPONENT_CORE parameter defines whether the core package for Linux is included in the installation. The core package is required by all other optional packages and must always be included in the installation.
This parameter has the following options:
YES
(Default) Include the core package.
NO
Do not include the core package.
II_COMPONENT_DBMS
Valid on Windows
The II_COMPONENT_DBMS parameter defines whether the DBMS Server package is included in the installation.
This parameter has the following options:
YES
(Default) Include the DBMS Server package.
NO
Do not include the DBMS Server package.
II_COMPONENT_DOCUMENTATION
Valid on Windows
The II_COMPONENT_DOCUMENTATION parameter defines whether the documentation package is included in the installation.
This parameter has the following options:
YES
(Default) Include the documentation package.
NO
Do not include the documentation package.
II_COMPONENT_DOTNET
Valid on Windows
The II_COMPONENT_DOTNET parameter defines whether the .NET Data Provider package is included in the installation.
This parameter has the following options:
YES
(Default) Include the .NET Data Provider package.
NO
Do not include the .NET Data Provider package.
II_COMPONENT_FRONTTOOLS
Valid on Windows
The II_COMPONENT_FRONTTOOLS parameter defines whether the Front Tools package is included in the installation. This package contains the following components:
• Embedded SQL/C
• Embedded SQL/COBOL
• Embedded SQL/FORTRAN
• Querying and Reporting Tools
• Visual DBA
This parameter has the following options:
YES
(Default) Include the Front Tools package.
NO
Do not include the Front Tools package.
II_COMPONENT_JDBC_CLIENT
Valid on Windows
The II_COMPONENT_JDBC_CLIENT parameter defines whether the JDBC driver is included in the installation.
This parameter has the following options:
YES
(Default) Include the JDBC driver.
NO
Do not include the JDBC driver.
II_COMPONENT_NET
Valid on Windows
The II_COMPONENT_NET parameter defines whether the Ingres Net package is included in the installation. This package includes the following items:
• Name Server
• Communications Server
• Data Access Server
• ODBC and JDBC drivers
• Terminal Monitors
This parameter has the following options:
YES
(Default) Include the Ingres Net package.
NO
Do not include the Ingres Net package.
II_CONNECT_LIMIT
Valid on Windows
II_CONNECT_LIMIT parameter specifies the maximum number of concurrent users.
II_DATABASE
The II_DATABASE parameter defines the location of the master database (iidbdb) and the default location for database files.
Default: Same as II_SYSTEM
II_DATE_FORMAT
Valid on Windows, Linux
The II_DATE_FORMAT parameter defines the format used to display date values.
The following are valid II_DATE_FORMAT settings and their output formats:
For valid input formats, see the SQL Language Guide.
II_DBMS_AUTHENTICATION
The II_DBMS_AUTHENTICATION parameter enables or disables the DBMS authentication feature. Valid values are YES and NO.
Default: "YES"
II_DBMS_PASSWORD
Valid on Windows
The II_DBMS_PASSWORD parameter defines the DBMS password for the instance owner.
Default: ""
II_DEMODB_CREATE
The II_DEMODB_CREATE parameter defines whether to install the demonstration program and create the demonstration database.
This parameter has the following options:
YES
(Default) Install the demonstration program and create the demonstration database.
NO
Do not install the demonstration program.
Note: The demonstration program requires both the DBMS and .NET Data Provider components. If only the DBMS is installed, the demonstration database (demodb) will be created, but the demonstration program will not be installed.
II_DUAL_LOG
The II_DUAL_LOG parameter defines the location of the backup (secondary) transaction log file. By default, dual transaction logging is disabled (parameter is set to blank ("")). If you desire dual logging, configure the II_SYSTEM location value for this parameter setting.
Default: ""
II_DUMP
The II_DUMP parameter defines the location of dump files used to store changes made during an online checkpoint.
Default: Same as II_SYSTEM
II_ENABLE_SQL92
The II_ENABLE_SQL92 parameter defines whether the SQL92 standard setting is enabled.
This parameter has the following options:
YES
Enable the SQL92 standard.
NO
(Default) Do not enable the SQL92 standard.
II_ENABLE_TCPIP
Valid on Windows
The II_ENABLE_TCPIP parameter defines whether the TCP_IP networking protocol is initialized when the Communications Server starts.
This parameter has the following options:
YES
(Default) Initialize the TCP_IP networking protocol when the Communications Server starts.
NO
Do not initialize the TCP_IP networking protocol when the Communications Server starts.
II_GROUPID
Valid on Linux
The II_GROUPID parameter specifies the group ID to which the current user's user ID belongs and that owns the installation. The ID is added to the system if it does not exist.
Default: Current user's group ID
II_INSTALL_ALL_ICONS
Valid on Windows
The II_INSTALL_ALL_ICONS parameter defines whether to create the Vector program group and associated icons during the installation.
This parameter has the following options:
YES
(Default) Create the program group and its associated icons.
NO
Do not create the program group and its associated icons.
II_INSTALLATION
The II_INSTALLATION parameter defines the Vector instance ID (also known as an installation code). The instance ID is a two-character code that identifies a specific installation on a node, and allows all processes and images to be installed and shared successfully.
If you have more than one installation on the same node, each installation on that node must have a unique instance ID.
The first character of the installation code must be a letter; the second character can be a letter or numeral.
Default: VW
II_JOURNAL
The II_JOURNAL parameter defines the location of the journal files, which provide a dynamic record of changes made to Vector databases since the last checkpoint. This parameter cannot be changed, even during installation updates. Specific databases can designate alternate locations for journals as a parameter to the createdb command.
Default: Same as II_SYSTEM
II_LOCATION_DOCUMENTATION
Valid on Windows
The II_LOCATION_DOCUMENTATION parameter defines the location of the documentation set.
Default: C:\Program Files\Actian\product Documentation version
II_LOCATION_DOTNET
Valid on Windows
The II_LOCATION_DOTNET parameter defines the location of the .NET Data Provider files.
Default: C:\Program Files\Actian\Ingres .NET Data Provider
II_LOCATION _DIRECTOR
Valid on Windows
The II_LOCATION_DIRECTOR parameter defines the location of the Actian Director files.
Default: C:\Program Files\Actian\Director
II_LOG_FILE
The II_LOG_FILE parameter defines the location of the transaction log file.
Default: Same as II_SYSTEM
II_LOG_FILE_SIZE_MB
The II_LOG_FILE_SIZE_MB parameter defines the size of the Ingres primary transaction log in MB.
Minimum: 32
Default: 512
II_MONEY_FORMAT
Valid on Windows, Linux
The II_MONEY_FORMAT parameter defines the format of monetary outputs. The symbol to the left of the colon indicates the location of the currency symbol--L for a leading currency symbol or T for a trailing currency symbol. The symbol to the right of the colon is the currency symbol you want displayed. Currency symbols can contain up to 4 physical characters.
If no currency symbol is required, set the value to NONE (case insensitive).
For example:
Default: L:$
II_MTS_JAVA_HOME
Valid on Windows, Linux
The II_MTS_JAVA_HOME parameter defines the location of the Java Runtime Environment required to run the Remote Manager Service for Actian Director.
II_REMOVE_ALL_FILES
Valid on Linux
The II_REMOVE_ALL_FILES parameter defines whether all Vector files are removed during an un-install of Vector.
This parameter has the following options:
YES
Remove all files during un-install.
NO
(Default) Do not remove all files during un-install.
II_SERVICE_START_AUTO
Valid on Windows
The II_SERVICE_START_AUTO parameter defines whether the Vector Service is started automatically when the machine on which Vector is installed is started.
This parameter has the following options:
YES
(Default) Start the Vector Service automatically
NO
Do not start the Vector Service automatically.
II_SERVICE_START_USER
Valid on Windows
The II_SERVICE_START_USER parameter defines the user who can start Vector as a service.
Default: Current user
II_SERVICE_START_USERPASSWORD
Valid on Windows
The II_SERVICE_START_USERPASSWORD parameter defines the password required to start Vector as a service.
Default: Password of current user
II_START_ON_BOOT
Valid on Linux
The II_START_ON_BOOT parameter defines whether Vector starts when the Linux server starts up.
This parameter has the following options:
YES
(Default) Start Vector when the Linux server starts up.
NO
Do not start Vector when the Linux server starts up.
II_SYSTEM
The II_SYSTEM parameter defines the location of the Vector system (executable) files.
Defaults:
Windows: C:\Program Files\Actian\VectorVW\
Linux: /opt/Actian/VectorVW/
II_TERMINAL
Valid on Windows, Linux
The II_TERMINAL parameter defines the terminal type.
This parameter has the following options:
Defaults:
Windows: IBMPCD
Linux: konsolel
II_TIMEZONE_NAME
The II_TIMEZONE_NAME parameter defines the time zone for the installation.
Default: America-Los_Angeles
II_UPGRADE_USER_DB
The II_UPGRADE_USER_DB parameter defines whether the existing user databases are upgraded automatically.
This parameter has the following options:
YES
Upgrade the existing user databases automatically.
NO
(Default) Do not upgrade the existing user databases automatically.
II_USERID
Valid on Linux
The II_USERID parameter defines the user ID of the user that owns the installation. The ID is added to the system if it does not exist.
Default: User ID of the user who installs Vector
II_VWCFG_BLOCK_SIZE
II_VWCFG_BLOCK_SIZE sets the value of the block_size configuration parameter in vectorwise.conf.
II_VWCFG_BUFFERPOOL
II_VWCFG_BUFFERPOOL sets the value of the bufferpool_size configuration parameter in vectorwise.conf.
II_VWCFG_GROUP_SIZE
II_VWCFG_GROUP_SIZE sets the value of the group_size configuration parameter in vectorwise.conf.
II_VWCFG_MAX_MEMORY
II_VWCFG_MAX_MEMORY sets the value for the max_memory_size configuration parameter in vectorwise.conf.
II_VWCFG_MAX_PARALLELISM
II_VWCFG_MAX_PARALLELISM sets the value of the max_parallelism_level configuration parameter in vectorwise.conf.
II_WORK
The II_WORK parameter defines the location of temporary work files created during external sorts, table modifies and other DBMS Server operations.
Default: Same as II_SYSTEM
KRB5_KEYTAB_FILE
KRB5_KEYTAB_FILE specifies the Kerberos keytab file to pass to the actian user during installation.
KRB5_PRINCIPAL
KRB5_PRINCIPAL specifies the Kerberos principal to pass to the actian user during installation.
SILENT_INSTALL
Valid on Linux
SILENT_INSTALL quiets installation messages except those from RPM.