• System Administrator Guide
•  1. 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
•  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
  • Actian Director
  •  Visual Tools (Windows)
    • 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
•  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
  • 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)
•  5. 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
  • 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
  • Identifying Unused Table Files
  • Configure the Checking of Free Disk Space
  • How to Free Disk Space
•  6. Customizing Vector
  •  Archiver Exit Script (acpexit)
    • Customization of Archiver Exit Script
    • Archiver Exit Script Parameters
•  7. 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
•  8. 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.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 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
•  9. Managing Your System
  • Managing the Installation with Actian Director
  • Managing the Installation with Visual Manager on Windows
•  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 (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
  • VWLOG

System Administrator Guide

II_APP_NO_SIG_HANDLE (Linux)