• System Administrator Guide
•  1. Introducing Vector System Administration
  • Audience
  • System Administrator Responsibilities
  • System Administration Summary
  • Special Considerations
  • Query Language Used in this Guide
  • Terminology Used in this Guide
  • Syntax Conventions Used in this Guide
•  2. 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
  •  Administration Tools
    • Actian Director
    • Visual Tools (Windows)
  •  Logging and Locking Systems
    • Log Files
•  3. 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
  • History of Configuration Changes
•  4. Setting Environment Variables
  • Scope of Environment Variables
  • Symbol Table
  • 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
      • Change the Value of the ING_ABFDIR Variable
    • Change an Installation Location with Unloading
    • Use of Symbolic Links
•  5. Managing Cluster Resources
  •  How VectorH Interacts with YARN
    •  YARN Required Settings
      • Additional YARN Settings when Using Kerberos
    • Configure YARN Integration
    • Configure Resource Allocation in the Cluster
    • How the Set of Slave Nodes Is Determined
    •  Preemption Support
      • How VectorH Preemption Support Works
      • Configuring VectorH for Preemption Support
  • YARN Configuration Settings
  • How to Add and Remove Slave Nodes
•  6. Configuring and Managing the X100 Engine
  • X100 Configuration File (vectorwise.conf)
  • X100 Per-node Configuration File
  • X100 Configuration File Format
  •  X100 Configuration Parameters
    • [memory] Settings
    • [system] Settings
    • [server] Settings
    • [cbm] Settings
    • [engine] Settings
    • [dbagent] Settings
  • When to Change the Default Configuration Values
  •  Memory Settings
    • Memory Configuration Guidelines
  • I/O Settings
  •  OS Settings
    • Virtual Address Space Allocation
    • Increase max_map_count Kernel Parameter
    •  Using Large Pages
      • Requirements for Huge Pages on Linux
      • Designate Memory for Huge Pages on Linux
    • Using NUMA Optimization
    • User Processes Limit in RHEL
    • RLIMIT_MEMLOCK (Linux)
  •  Using Multiple Databases
    • Closing an Active Database
  • SQL Settings
  •  Performance Tips
    • Creating Indexes
  • Per-query Parallelism Level
  • Data Size Consideration for Some Queries
  •  X100 Write-Ahead Log
    • Old WAL Files
    • WAL Condensation
    • wal_backups Directory
  •  Error Reporting--vectorwise.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
    • Changing Error Log Configuration Settings Dynamically
    •  Logging for Startup of the X100 Server
      • Configure x100errlog.log Rotation
  • Identifying Unused Table Files
  • Configure the Checking of Free Disk Space
  • How to Free Disk Space
  • Configure MPI Runtime
•  7. Customizing Vector
  •  Archiver Exit Script (acpexit)
    • Customization of Archiver Exit Script
    • Archiver Exit Script Parameters
•  8. 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
      • Ingbuild on Linux
      • Detect Vector Startup Problems
    • Detect Vector Startup Problems on System Reboot
    • Check Shutdown Problems
  •  Vector Processes
    •  Name Server Errors
      • Check for Name Server Errors
    • Check for Communications Server Process Errors
    • Check for Bridge Server Process Errors
    •  Recovery Process Errors
      • Check for Recovery Process Errors
    • Check for Remote Command Process
    •  Archiver Process
      • Check for Archiver Process Errors
    • Check for DBMS Server Process Errors
    • Check for Data Access Server Process
  •  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
•  9. Using Monitoring and Tracing Tools
  • Supported Monitoring and Tracing Tools
  • System Utilities
  •  Operating System Utilities
    •  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 (WAL)
    • Ingres Transaction Log File
    • X100 Error Log (vectorwise.log)
    • DBMS Error Log (error.log)
    • Archiver Log
    • Recovery Log
    • Primary Configuration Log Files
    • Optional Configuration Log Files
    • 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 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
    •  Query Tracing
      • SC930 Output Files
      • Set SC930 Output Directory
      • Enabling and Disabling SC930
      • SC930 Message Format
      • Example Trace Output
    • Error Tracing
  •  Linux Trace Facilities
    •  Bourne Shell -x Option
      • Linux Trace Command
•  10. Managing Your System
  • Managing the Installation with Actian Director
  • Managing the Installation with Visual Manager on Windows
  • Grant Access to Remote Users
  •  Session Management
    • Determine How Long a Query Has Been Running
    • Remove a Vector Session
•  A. 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
  • 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_VNODE_PATH
  • II_WORK
  • IIDLDIR
  • ING_SET
  • ING_PRINT
  • ING_SET_DBNAME
  • ING_SYSTEM_SET
  • INGRES_KEYS
  • ING_SHELL
  • TERM_INGRES
  • VWLOG

System Administrator Guide

II_APP_NO_SIG_HANDLE (Linux)