Getting Started
Installing Vector
Installation Considerations
Instance ID
System Administrator Account
Log Files Location (II_LOG) (Windows)
How to Move Logs to a New II_LOG Location
World Region and Time Zone
Time Zone Names
Character Set (II_CHARSET)
User Names
Directory Names
Java Requirement for Management Server
Set Up the Authorization String for Evaluation Version
Installing Docker for Containerized UDFs
Activate Docker Cgroup Version 2
Installing Vector for Linux
Install libaio
Import GPG Public Key (RPM and DEB Only)
install.sh Command--Install Vector
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
Set the II_RESPONSE_FILE Variable
Run iisystemd Specifying II_RESPONSE_FILE
How to Access the Instance on Linux
Virtual Address Space Allocation (Linux)
Configuring Vector High Availability for Linux
Installing Vector for Windows
Snap-in Components
Licensing
Upgrading Vector
Stop the Instance and Management Server
How You Upgrade Using the Upgradedb Utility
Disable User Access
Disable Remote Command Server
Clean the Database
Record Database Information
Checkpoint and Turn Off Journaling
Shut Down Vector and Back Up System
Preserve Site Modifications
Commonly Customized Files
Preserve Necessary Files
Visual DBA Configurations
(Optional) Delete Install Directory and Move Bin, Lib, Utility Directories (Linux)
Install Vector
How to Upgrade Using install.sh
How to Upgrade Using RPM
Create imadb Database
Restore Site Modifications
Carry Forward Checkpoint Template Modifications
Verify Vector Started
Run Upgradedb Utility
Encrypted Database
Review Vector Configuration
(Optional) [Each DB] Reapply optimizer statistics
Checkpoint the Database
Install Upgraded Applications
Troubleshooting Upgradedb Problems
Other Upgradedb Problems
Post-installation Tasks
Setting up Spark
View Installation Environment Settings
How You Safely Uninstall Vector
Uninstall Vector for Linux
uninstall Command--Uninstall Vector for Linux
Uninstall Vector for Windows
Uninstall Vector Containers
Accessing Vector
Startup and Shutdown
Start Vector as a Service (Linux)
Start Vector as a Service (Windows)
Command Prompt Shortcuts
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
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
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_DOWNLOAD_GCS_CONNECTOR
II_DOWNLOAD_HADOOP
II_DOWNLOAD_SPARK
II_DOWNLOAD_TENSORFLOW
II_DUAL_LOG
II_DUMP
II_EMAIL
II_ENABLE_TCPIP
II_GCS_CONNECTOR_LOCATION
II_GROUPID
II_HADOOP_LOCATION
II_INSTALL_ALL_ICONS
II_INSTALLATION
II_JOURNAL
II_LICENSE_DIR
II_LOCATION_DOCUMENTATION
II_LOCATION_DOTNET
II_LOCATION _DIRECTOR
II_LOG_FILE
II_LOG_FILE_SIZE_MB
II_MAILHOST
II_MAILPORT
II_MONEY_FORMAT
II_MTS_JAVA_HOME
II_REMOVE_ALL_FILES
II_SERVICE_START_AUTO
II_SERVICE_START_USER
II_SERVICE_START_USERPASSWORD
II_SPARK_LOCATION
II_START_ON_BOOT
II_SYSTEM
II_TERMINAL
II_TIMEZONE_NAME
II_DOWNLOAD_UDFC_REPO
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
Getting Started
II_SPARK_LOCATION