• System Administrator Guide
  • Introducing Vector System Administration
    • Audience
    • System Administrator Responsibilities
    • System Administration Summary
    • Special Considerations
    • Query Language Used in this Guide
    • System-specific Text in this Guide
    • Path Notation in this Guide
    • Terminology Used in this Guide
    • Syntax Conventions Used in this Guide
  • Understanding Vector Components
    • Components of a Vector Installation
    • Vector Architecture
    • DBMS Server
    • X100 Engine
    • Query Processing
      • The Tool or Application Process
      • DBMS Server Process
      • Relationship Between DBMS Server and X100 Engine
      • Query Environment
    • DBMS Server Facilities
      • Abstract Data Type Facility
      • Compatibility Library Facility
      • Data Manipulation Facility
      • Optimizer Facility
      • Parser Facility
      • Query Execution Facility
      • Query Storage Facility
      • System Control Facility
      • Relation Description Facility
    • General Communication Facility
      • Name Server
      • Name Server Maintenance Utility
      • Communications Server
      • Data Access Server
      • Bridge Server
      • General Communications Architecture
    • Querying and Reporting Tools
    • Actian Director
      • Grant Access to Remote Users
    • Logging and Locking Systems
      • Log Files
        • X100 Write-ahead Log (WAL)
        • X100 Error Log
        • Ingres Transaction Log File
        • DBMS Error Log
        • Archiver Log
        • Recovery Log
        • Primary Configuration Log Files
        • Optional Configuration Log Files
      • Optional Log Files
        • Process Logs
        • Optional Log Facility
  • Configuring Vector
    • Configurable Components
    • Configuration Tools
      • Access Configuration-By-Forms Utility
        • How You Navigate in CBF
    • Component Configurations
      • Configurable Properties for a Component
      • Configuration Snapshot
    • Configuration Parameters
      • Setting Parameter and Derived Parameter Values
        • Using VCDA to Restore Configuration Parameter
        • Protecting or Recalculating Derived Parameters
      • Components That Use Derived Parameters
    • DBMS Server Configuration
    • X100 Engine Configuration
    • Data Access Server Configuration
    • Communications Server Configuration
    • Bridge Server Configuration
    • Name Server Configuration
    • Recovery Server Configuration
    • Security Configuration
    • Locking System Configuration
    • Logging System Configuration
      • Multiple Log Partition Configuration
      • Primary Transaction Log and Dual Transaction Log
    • Non-Configurable Components
  • Setting Environment Variables
    • Scope of Environment Variables
    • Symbol Table
    • Windows Environment Variables
    • Linux Environment Variables
    • Installation-Wide Environment Variables
      • View Environment Variables
      • User-definable Environment Variables
      • Environment Variables that Can be Reset Locally
      • Environment Variables that Cannot Be Reset
    • Customization of Query Runtime Environment
      • Syntax Rules for Startup Files and Environment Variables
      • Dayfile
      • DBNAME_SQL_INIT
      • II_SQL_INIT
      • ING_SET
      • ING_SET_DBNAME
      • ING_SYSTEM_SET
      • Startsql
    • Installation Locations
      • When Not to Change Installation Locations
        • Allocation of Space for Future Growth
      • Location Variables that Do and Do Not Require Unloading (Linux and Windows)
        • Change the Value of the ING_ABFDIR Variable
      • Change an Installation Location with Unloading (Windows)
      • Change an Installation Location with Unloading (Linux)
      • Use of Symbolic Links (Linux)
  • Configuring and Managing the X100 Engine
    • X100 Configuration File (vectorwise.conf)
    • X100 Configuration File Format
    • X100 Configuration Parameters
      • [memory] Settings
      • [system] Settings
      • [server] Settings
        • [cbm] Settings
      • [engine] Settings
    • When to Change the Default Configuration Values
    • Memory Settings
      • Memory Configuration Guidelines
    • I/O Settings
    • OS Settings
      • Virtual Address Space Allocation (Linux)
      • Increase max_map_count Kernel Parameter (Linux)
      • RLIMIT_MEMLOCK (Linux)
      • Using Large Pages
        • Requirements for Huge Pages on Linux
        • Designate Memory for Huge Pages on Linux
      • Using NUMA Optimization
    • Using Multiple Databases
      • Closing an Active Database
    • SQL Settings
    • Performance Tips
    • Per-query Parallelism Level
    • Query Result Caching
    • Data Size Consideration for Some Queries
    • X100 Write-Ahead Log
      • Old WAL Files
      • WAL Condensation
      • wal_backups Directory
    • Error Reporting--vectorwise.dbname.log
      • Configuring X100 Error Reporting
      • X100 Error Log Record Format
      • X100 Error Log Configuration File
        • X100 Error Log Configuration File Format
        • Example X100 Error Log Configurations
      • VWLOG Environment Variable--Configure Error Reporting
      • Rotating the X100 Error Log
      • Automatic Log Rotation in X100
        • Persistent Change
        • Changes during Runtime
        • Changing Error Log Configuration Settings Dynamically
    • Identifying Unused Table Files
    • Configure the Checking of Free Disk Space
    • How to Free Disk Space
  • Configuring User-defined Functions
    • UDF Runtime Modes
    • Setting up Containerized UDFs
      • udf_engines.conf Example
    • Configuration to Use UDFs
    • UDF Engines Configuration File (udf_engines.conf)
      • udf_engines.conf Section Header
      • udf_engines.conf Fields
    • UDF Logging
    • Sending UDF output to the process log
    • Query cancel support
    • Python module imports
      • Containerized Python UDFs
      • Non-containerized Python UDFs
    • JavaScript module imports
      • Containerized JavaScript UDFs
      • Non-containerized JavaScript UDFs
    • UDF Container Memory Limit
    • Out-Of-Memory Condition
    • Linux Out-of-Memory Killer
      • Restarting the UDF container
  • Configuring Machine Learning Models (MLM)
    • MLM using Tensorflow
    • Setting up MLMs
  • Customizing Vector
    • Archiver Exit Script (acpexit)
      • Customization of Archiver Exit Script
      • Archiver Exit Script Parameters
  • Troubleshooting Vector
    • Process of Troubleshooting
    • Tools for Troubleshooting
    • Determine the Problem Area
      • Error Log Files
      • View List of Log Files
      • Check the Error Log Files
      • Find Your Problem Category
    • Troubleshoot Startup, Shutdown, or Configuration Problems
      • Check Vector Installation on Windows
        • Detect Vector Startup Problems on Windows
      • Check Vector Installation on Linux
        • Ingbuild on Linux
        • Detect Vector Startup Problems on Linux
      • Detect Vector Startup Problems on System Reboot (Windows)
      • Detect Vector Startup Problems on System Reboot (Linux)
      • Check Shutdown Problems on Windows
      • Check Shutdown Problems on Linux
    • Vector Processes on Windows
      • Check for Name Server Errors on Windows
      • Check for Communications Server Process Errors on Windows
      • Check for Remote Command Process Errors on Windows
      • Check for Recovery Process Errors on Windows
      • Check for Archiver Process Errors on Windows
      • Check for DBMS Server Process Errors on Windows
      • Check for Data Access Server Errors on Windows
    • Vector Processes on Linux
      • Name Server Errors on Linux
        • Check for Name Server Errors on Linux
      • Check for Communications Server Process Errors on Linux
      • Check for Bridge Server Process Errors on Linux
      • Recovery Process Errors on Linux
        • Check for Recovery Process Errors on Linux
      • Check for Remote Command Process on Linux
      • Archiver Process on Linux
        • Check for Archiver Process Errors on Linux
      • Check for DBMS Server Process Errors on Linux
      • Check for Data Access Server Process on Linux
    • Problems with Tools Startup
      • DBMS Server Stopped
      • Database Connection Problems
        • No Database Connections
        • Individual Database Connection Failure
    • Inconsistent Databases and Recovery
      • Automatic Recovery
        • Recovery During Normal Operation
        • Recovery at Shutdown
        • Recovery at Startup
        • Recovery Process Monitoring
      • Inconsistent Database
        • Diagnose an Inconsistent Database
        • Common Causes of Inconsistent Databases
        • Recover an Inconsistent Database
    • Performance Problems
      • Flow Diagram for Troubleshooting Performance Problems
      • Diagnose Logging System Problems
        • Logstat Status Fields
        • How to Avoid Logfull Abort
    • Resource and Maintenance Problems
      • Identifying Operating System Resource Problems
        • Check System Resources
    • What You Need Before Contacting Actian Support
      • Windows Installations
      • Linux Installations
  • Using Monitoring and Tracing Tools
    • Supported Monitoring and Tracing Tools
    • System Utilities
    • Operating System Utilities
      • Windows Operating System Utilities
        • Windows Diagnostics
        • Windows Performance Monitor
        • Windows Event Viewer
        • Windows Registry Editor
        • Windows Task Manager
      • Linux Operating System Utilities
        • ps
        • iostat
        • vmstat
    • Vendor Utilities
    • Error Messages
      • X100 Error Message Format
      • DBMS Server Error Message Format
      • Message Help Files
      • Fatal Errors
      • Non-Fatal Errors
      • Facility Codes
        • Facility Codes for Primary Components
        • Server-Only Components
        • Tools-Only Components
        • Components for Stream File Management
        • Components for Utility Routines
        • Miscellaneous Components
    • Log Files
      • X100 Write-ahead Log
      • Ingres Transaction Log File
      • X100 Error Log (vectorwise.dbname.log)
      • DBMS Error Log (error.log)
      • Archiver Log
      • Recovery Log
      • Primary Configuration Log Files
      • Optional Configuration Log Files
      • Other Optional Log Files
      • Configure Log Rotation
    • Trace Utilities
      • ODBC Call-level Interface
      • SET Statement
        • Environment Variables Commonly Used with SET
        • Example: Set Statement Entered Directly
        • Example: Set Statements in an Include File
        • SET Statements in Startup Files
      • SET Options for Tracing Queries
        • The SET SERVER_TRACE and SET SESSION_TRACE Options
        • The SET PRINTQRY Option
        • Example: Turn Query Display On Using ING_SET
        • Example: Turn Query Display On Using II_EMBED_SET
        • The SET QEP Option
        • The SET JOINOP NOTIMEOUT Option
        • The SET TRACE POINT OP207 Option
      • Canceling SET Options
        • The SET SESSION WITH ON_ERROR Option
      • I/O Tracing
        • Lock Tracing
        • Event Tracing
      • User-Server Communications
        • Trace Communication Using printgca
        • Example: Level 2 Tracing Using GCA Trace Utiltiy
      • Error Tracing
    • Linux Trace Facilities
      • Bourne Shell -x Option
        • Linux Trace Command
  • Managing Your System
    • Managing the Installation with Actian Director
  • B. Environment Variables
    • DBNAME_SQL_INIT
    • II_APP_NO_SIG_HANDLE (Linux)
    • II_AUTH_STRING
    • II_CHECKPOINT
    • II_CLIENT
    • II_CONFIG
    • II_DATABASE
    • II_DATE_FORMAT
    • II_DBMS_LOG
    • II_DBMS_SERVER
    • II_DECIMAL
    • II_DISABLE_SYSCHECK
    • II_DUMP
    • II_EMBED_SET
    • II_ERSEND (Linux)
    • II_FORCE_HET
    • II_GC_REMOTE
    • II_GCD_LOG
    • II_GCN_LOG
    • II_GCNxx_PORT
    • II_GCx_TRACE
    • II_INSTALLATION
    • II_JOURNAL
    • II_LANGUAGE
    • II_LOG
    • II_MONEY_FORMAT
    • II_MONEY_PREC
    • II_MSGDIR
    • II_MTS_JAVA_HOME
    • II_NULL_STRING
    • II_NUM_OF_PROCESSORS
    • II_PRINTSCREEN _FILE
    • II_RCP_STATS
    • II_SQL_INIT
    • II_SYSTEM
    • II_TEMPORARY
    • II_TERMCAP_FILE
    • II_TIMEZONE_NAME
    • II_TM_EXIT_ON_ERROR
    • II_TM_ON_ERROR
    • II_UUID_MAC (Windows)
    • II_VNODE_PATH
    • II_WORK
    • IIDLDIR
    • ING_SET
    • ING_PRINT
    • ING_SET_DBNAME
    • ING_SYSTEM_SET
    • INGRES_KEYS
    • ING_SHELL (Linux)
    • TERM_INGRES
    • UDF_PYTHONHOME (Windows)
    • VWLOG

System Administrator Guide

II_APP_NO_SIG_HANDLE (Linux)