Getting Started
1. Installing Vector
Installation Considerations
Instance ID
Log Files Location (II_LOG) (Windows)
How to Move Logs to a New II_LOG Location
Character Set (II_CHARSET)
User Names
Directory Names
Java Requirement for Management Server
Changes to Installation Process in this Release
Evaluation Version Authorization String
Installing Vector for Linux
Install libaio
Import GPG Public Key (RPM and DEB Only)
install.sh Command--Install Vector
Install Vector for Linux Using the Graphical Installation Wizard
Install Vector at the Command Line
Examples of install.sh Command
Install Vector as a User Other than root
Install Vector Using RPM Commands
Installing Multiple RPM Package Instances
Configure and Start the Instance
How to Access the Instance on Linux
Virtual Address Space Allocation (Linux)
Configuring the High Availability Option for Red Hat Cluster Suite
Install the Cluster Service Script
Set up the Cluster Service
Installing Vector for Windows
Snap-in Components
Upgrading Vector
Upgrade User Databases After Installation
Post-installation Tasks
View Installation Environment Settings
How You Safely Uninstall Vector
Uninstall Vector for Linux
uninstall Command--Uninstall Vector for Linux
Uninstall Vector for Windows
2. Accessing Vector
Startup and Shutdown
Start Vector as a Service (Linux)
Start Vector as a Service (Windows)
Network Connections
User Authentication
User Password
Connecting to a Database
Connecting to a Local Server
Connecting to a Remote Server
Connecting to a Non-UTF8 Server that Does Not Support Transliteration
3. Creating a Database and Loading Data
Create a Database
Database Default Configuration
Connect to or Disconnect from a Database
Create a Table
Methods for Loading Data
Load Data with COPY Statement
Load Data with vwload Utility
Load Data with COPY VWLOAD Statement
Load Data with Spark SQL through the Spark-Vector Connector
Create Statistics
Optimize System Catalogs with sysmod
Run a Reporting Query
4. Installing Vector Using a Response File
Response File--Define Configuration for the Installation
Install Vector Using a Response File (Linux)
Example Response File on Linux
Install Vector Using a Response File (Windows)
Example Response File on Windows
Example Response File for Client Runtime for Windows
Response File Parameters
CONNECT_LIMIT
II_ADD_REMOVE_PROGRAMS
II_ADD_TO_PATH
II_AUTH_STRING
II_CHARSET
II_CHECKPOINT
II_COMPONENT_CORE
II_COMPONENT_DBMS
II_COMPONENT_DOCUMENTATION
II_COMPONENT_DOTNET
II_COMPONENT_FRONTTOOLS
II_COMPONENT_JDBC_CLIENT
II_COMPONENT_NET
II_CONNECT_LIMIT
II_DATABASE
II_DATE_FORMAT
II_DBMS_AUTHENTICATION
II_DBMS_PASSWORD
II_DEMODB_CREATE
II_DUAL_LOG
II_DUMP
II_ENABLE_SQL92
II_ENABLE_TCPIP
II_GROUPID
II_INSTALL_ALL_ICONS
II_INSTALLATION
II_JOURNAL
II_LOCATION_DOCUMENTATION
II_LOCATION_DOTNET
II_LOCATION _DIRECTOR
II_LOG_FILE
II_LOG_FILE_SIZE_MB
II_MONEY_FORMAT
II_MTS_JAVA_HOME
II_REMOVE_ALL_FILES
II_SERVICE_START_AUTO
II_SERVICE_START_USER
II_SERVICE_START_USERPASSWORD
II_START_ON_BOOT
II_SYSTEM
II_TERMINAL
II_TIMEZONE_NAME
II_UPGRADE_USER_DB
II_USERID
II_VWCFG_BLOCK_SIZE
II_VWCFG_BUFFERPOOL
II_VWCFG_GROUP_SIZE
II_VWCFG_MAX_MEMORY
II_VWCFG_MAX_PARALLELISM
II_WORK
KRB5_KEYTAB_FILE
KRB5_PRINCIPAL
SILENT_INSTALL
Actian Vector 5.0
SILENT_INSTALL