• Introducing Actian Ingres 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 Actian Ingres Components
  • Components of an Actian Ingres Installation
  • Actian Ingres Architecture
  • DBMS Server
  • X100 Engine
  • Query Processing
    • The Tool or Application Process
    • DBMS Server Process
    • 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)
    • Visual Manager
    • Visual Performance Monitor
    • Visual DBA
    • Remote Command Server
      • Grant Access to Remote Users
      • How Remote Commands Are Executed
    • Configuration Manager
    • Network Utility
    • Export Assistant
    • Import Assistant
    • Journal Analyzer
    • Visual SQL
    • Visual Configuration Differences Analyzer
    • Visual Database Objects Differences Analyzer
  • Logging and Locking Systems
    • Lock Manager
    • Logging Facility
      • Log Buffers
      • How the Logging Facility Works
    • Recovery Process
      • Data Manipulation Facility Recovery Process (dmfrcp)
      • Recovery Modes
    • Archiver Process
      • Data Manipulation Facility Archiver Process (dmfacp)
      • Journal Files
      • Disaster Recovery Command
    • Transactions Recovery
      • Types of Transaction Recovery
        • Redo Operation in a Cluster Environment
    • Actian Ingres Log Files
      • Transaction Log File
      • DBMS Server Error Log
      • Archiver Log
      • Recovery Log
      • Primary Configuration Log Files
      • Optional Configuration Log Files
    • Optional Log Files
      • Process Logs
      • Optional Log Facility
    • X100 Log Files
• Configuring Actian Ingres
  • Configurable Components
  • Configuration Tools
    • Access Configuration-By-Forms Utility
      • How You Navigate in CBF
    • Access Configuration Manager Utility
    • Access Visual Configuration Differences Analyzer Utility
  • 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
    • Fast Commit Option
    • Write Behind Option
  • Data Access Server Configuration
  • Communications Server Configuration
  • Bridge Server Configuration
  • Star 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
  • Transaction Log File Encryption
  • X100 Engine Configuration
  • Non-Configurable Components
  • History of Configuration Changes
  • Query Result Caching
• Sizing the X100 System
  • Determine the Core Count
    • Hyper-threading
  • How Much Memory Do I Need?
    • Sizing Execution Memory
    • Sizing the Column Buffer Manager (CBM) Memory
• Configuring and Managing X100
  • 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)
    • Using Large Pages
      • Requirements for Huge Pages on Linux
      • Designate Memory for Huge Pages on Linux
    • Using NUMA Optimization
  • Using Multiple Databases
  • SQL Settings
  • X100 Write-Ahead Log
    • Old WAL Files
    • WAL Condensation
    • wal_backups Directory
  • Error Reporting--vectorwise.log
    • Configuring Error Reporting
    • Error Log Record Format
    • Error Log Configuration File
      • Error Log Configuration File Format
      • Example Error Log Configurations
    • VWLOG Environment Variable--Configure Error Reporting
    • Rotating the X100 Error Log
    • Changing Error Log Configuration Settings Dynamically
    • 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
• Setting Environment Variables
  • Scope of the Environment Variables
    • Symbol Table
  • Windows Environment Variables
  • Linux Environment Variables
  • Installation-Wide Environment Variables
    • View Environment Variables in Windows and Linux
    • Example: Set the ING_EDIT Variable
    • User-Definable Environment Variables
      • Example: Set an Environment Variable in the Local Environment
      • Display Current Value for 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_ING
      • Example: Set DBNAME_ING
    • DBNAME_SQL_ INIT
      • Example: Set DBNAME_SQL_INIT
    • II_SQL_INIT
      • Example: Set II_SQL_INIT
    • ING_SET
      • Example: Set ING_SET
    • ING_SET_DBNAME
      • Example: Set ING_SET_DBNAME
    • ING_SYSTEM_SET
      • Example: Set ING_SYSTEM_SET
    • Startsql
  • Installation Locations
    • When Not to Change Installation Locations
      • Allocation of Space for Future Growth
      • Allocation of Additional Space for Existing Tables
    • Location Variables that Do and Do Not Require Unloading
      • 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)
• Containerized Services
  • Services
  • The dockman Tools
    • Spark_provider Configuration File
  • The iipodmanwd Tool (Podman Watch Dog Service)
    • System Wide Service
    • Instance Wide Service
  • Configuration File for dockman Tools
    • Sample Configuration File
  • Dockman Tools Environment Variables
  • Docker Image Name Specification
  • Docker container name specification
  • Running Linux Containers
    • Limitations Running Podman under Hyper-V
  • Starting/Stopping/Status of container services
    • TensorFlow
    • Spark
    • UDF
• Configuring User-defined Functions
  • UDF Runtime Modes
  • Configure the Use of UDFs
  • Setting up Containerized UDFs
  • UDF Engines Configuration File (udf_engines.conf)
    • udf_engines.conf Section Header
    • udf_engines.conf Fields
    • Updating udf_engines.conf for Containerized UDFs
      • udf_engines.conf Example
  • 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
  • Predefined UDFs for ML Preprocessing
• Customizing Actian Ingres
  • Actian Ingres Character Sets
    • Default Character Sets
  • Local Collation Sequences
    • Supported Collation Sequences
      • Multi Collation Sequence
      • Spanish Collation Sequence
      • Unicode_french Collation Sequence
      • Custom Collation Sequence for NCS Installation
      • Custom Collation Sequence for UTF8 Installation
  • Archiver Exit Script (acpexit)
    • Customization of Archiver Exit Script
    • Archiver Exit Script Parameters
  • How to Use a Custom Mapping File for Unicode Coercion
• Troubleshooting Actian Ingres
  • Process of Troubleshooting
  • Tools for Troubleshooting
  • Determine the Problem Area
    • Error Log Files
    • Optional Error Log Files
    • Display Value for II_CONFIG
    • View List of Log Files
    • Check the Error Log Files
    • Find Your Problem Category
  • Troubleshoot Startup, Shutdown, or Configuration Problems
    • Check Actian Ingres Installation on Windows
      • Detect Actian Ingres Startup Problems on Windows
    • Check Actian Ingres Installation on Linux
      • Ingbuild on Linux
      • Detect Actian Ingres Startup Problems on Linux
    • Detect Actian Ingres Startup Problems on System Reboot (Windows)
    • Detect Actian Ingres Startup Problems on System Reboot (Linux)
    • Check Shutdown Problems on Windows
    • Check Shutdown Problems on Linux
  • Actian Ingres Processes on Windows
    • Check for Name Server Errors on Windows
    • Check for Communications Server Process Errors on Windows
    • Check for Bridge Server 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
  • Actian Ingres 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
    • 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
    • Transaction Log File
    • 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
    • Query Tracing
      • SC930 Output Files
      • Set SC930 Output Directory
      • Enabling and Disabling SC930
      • SC930 Message Format
      • Example Trace Output
    • Error Tracing
  • Linux Trace Facilities
    • Bash Shell -x Option
      • Linux Trace Command
• Understanding IngresSync
  • IngresSync Tool
  • Setup Considerations for IngresSync
  • Prerequisites for using IngresSync
    • Initial Synchronization of Source and Target Database
    • Synchronization Phase
    • Setting up the Target Database as the new Source
    • Using the Target Database as a Read-only Copy
    • Using IngresSync on Windows
      • Setting up the SSH server on the Target Machine(s)
      • Setting up Passwordless SSH
• Managing Workload
  • Workload Management Overview
    • Setting up workload management
  • Workload Queues
    • Queue Guidelines
    • System Queues
    • Queue Ratios
    • Queue Configurations
  • Workload Configuration
  • How to Configure Workload Management
    • iiwlm_config Catalog
    • iiwlm_queue Catalog
    • iiwlm_queueauth Catalog
  • DBA Workload Management Tasks
  • Workload Management Limitations
  • Monitoring the Workload Management System
    • IMA Tables for Workload Management
    • ima_wlm_queues Table
    • ima_wlm_queueauths Table
    • ima_wlm_sessions Table
  • Auditing Workload Management
    • iiwlm_log Table
• Managing Your System and Monitoring Performance
  • Managing the Installation with Visual Manager
    • Functions of Visual Manager
    • Visual Manager Window
    • System and User Parameter Configuration Through IVM
    • Set Parameter Configuration Through IVM
    • Message and Notification Management Through IVM
    • Event Monitoring Management Through IVM
    • Alert Events Notification Settings in IVM
    • View Message Explanations in IVM
    • Component Monitoring Through IVM
    • Server Monitoring Through IVM
    • Logging System Monitoring Through IVM
    • Locking System Monitoring Through IVM
    • Access to Visual Tools Through IVM
  • Monitoring and Managing Actian Ingres with Visual Performance Monitor
    • Visual Performance Monitor Window
  • Comparing Configurations with Visual Configuration Differences Analyzer
    • Configuration Snapshot File
    • Comparison of Configuration Snapshots
      • Comparison of Remote Installation Snapshots
    • Restoration of Configuration Parameters Through VCDA
    • How VCDA Handles Concatenated config.dat Files
• Monitoring X100
  • View Information about a Database
    • vwinfo Statistics Display
    • vwinfo Transactions Display
    • vwinfo PDT Usage Display
  • View Query Profile Information
    • iivwquery View
    • iivwprof View
      • Interpreting I/O Information in IIVWPROF View
    • iivwprof_last View
    • Examples of Using Query Profiling Information
    • Configure Query Profiling
    • System Catalogs for X100 Query Profiling Views
      • iivwprof_query Catalog
      • iivwprof_op Catalog
      • iivwprof_io Catalog
      • iivwprof_stage Catalog
      • iivwprof_expr Catalog
      • iivwprof_parse_tree Catalog
      • iivwprof_vwload_load_status Catalog
      • iivwprof_vwload_result_status Catalog
• Nagios Compatible Plug-ins
  • About the Plug-ins
  • ema_check_disk
  • ema_check_disk_perf
  • ema_check_hvr
  • ema_check_ingres
  • ema_check_ingres_lock
  • ema_check_ingres_lrq
  • ema_check_ingres_perf
  • ema_check_load
  • ema_check_memory
  • ema_ingres_checkpoint
  • ema_os_version
• Analyzing and Recovering Journaled Transactions
  • Journal Analyzer
  • Start Journal Analyzer
  • Journal Analyzer Window
  • Transaction Views
    • Database Level Journaled Transactions
      • Group Changes by Transaction
    • Table Level Journaled Transactions
    • Select Transactions and Row Changes
  • Recover Transactions or Individual Row Changes
    • Recover “Whole” Transactions or Individual Rows
    • Rules, Constraints, and Integrities
      • Scan Journals to End Option
    • Order of Transactions and Statements in Transactions
    • How to Check If Rows Have Changed After the Transaction
    • Users of Transactions
    • Number of Rows Affected by Each Individual “Reverse Statement”
    • Recover Immediately or Generate External Scripts Option
  • Redo Transactions and Individual Row Changes
• Setting up Actian Spark for Use with Ingres
  • Setting up Actian Spark Connector
  • Starting and Stopping the Actian Spark Connector
  • Actian Spark Connector Log
    • Configuring Logging
  • How to Securely Manage S3 Credentials
• Understanding Ingres Management Architecture
  • IMA Audience
  • IMA Overview
  • Components of IMA
  • Management Information Base
    • MIB Object Model
      • Classid
      • Location
      • Instances
  • MIB Creation
    • Registration of IMA Tables
      • REGISTER TABLE Statement--Register IMA Table
      • IMA Table Types
      • REMOVE TABLE Statement--Remove Table Registrations
  • IMA DBMSINFO Constants
  • Management Domains
    • Extending the Domain in the Local Instance
    • Extending the Domain to a Remote Instance
    • Removing a Remote Instance Domain
    • Restoring the Domain
  • Control Objects
  • Restrictions in IMA Use
  • REGISTER TABLE Examples
    • Examples: Domain Tables
    • Example: Table of SCF Sessions
    • Example: Lock Tables
    • Example: Logging Tables
  • Query Examples on IMA Tables
    • Example: What Are User Sessions Doing?
    • Example: Removing User Sessions using IMADB
    • Example: Who Is Waiting for a Lock?
    • Example: Who Is Holding Locks?
    • Example: Who Is Holding a Lock that Other Sessions Need?
    • Example: When Did a Query Start?
    • Example: Shutting Down a DBMS Server
  • Class ID Objects
    • IMA_STATUS_LOOKUP
• B. Environment Variables
  • In This Appendix
  • DBNAME_ING
  • DBNAME_SQL_INIT
  • DD_RSERVERS
  • II_4GL_DECIMAL
  • II_ABF_ASSUME_VALUE
  • II_AFD_TIMEOUT
  • II_APPLICATION_LANGUAGE
  • II_APP_NO_SIG_HANDLE (Linux)
  • II_BIND_SVC_xx
  • II_CHARSETxx
  • II_CHECKPOINT
  • II_CLIENT
  • II_COLLATION
  • II_CONFIG
  • II_CONNECT_RETRIES
  • II_DATABASE
  • II_DATE_CENTURY_ BOUNDARY
  • II_DATE_FORMAT
  • II_DBMS_LOG
  • II_DBMS_SERVER
  • II_DECIMAL
  • II_DIRECT_IO (Linux)
  • II_DISABLE_SYSCHECK
  • II_DML_DEF
  • II_DUMP
  • II_EMBED_SET
  • II_ERSEND (Linux)
  • II_FRS_KEYFIND
  • II_GC_REMOTE
  • II_GCA_REMOTE
  • II_GCA_LOG
  • II_GCx_TRACE
  • II_GCD_LOG
  • II_GCN_LOG
  • II_GCNxx_PORT
  • II_HALF_DUPLEX
  • II_HELP_EDIT
  • II_INSTALLATION
  • II_ITM_QUITPROMPT
  • II_JOURNAL
  • II_LANGUAGE
  • II_LP32_ENABLED
  • II_MONEY_FORMAT
  • II_MONEY_PREC
  • II_MSGDIR
  • II_MTS_JAVA_HOME
  • II_NULL_STRING
  • II_NUMERIC_LITERAL
  • II_NUM_OF_PROCESSORS
  • II_NUM_SLAVES (Linux)
  • II_OLD_VCH_MNY_FMT
  • II_OO_TABLE_SIZE
  • II_PATTERN_MATCH
  • II_PF_NODE
  • II_proto_PKT_SIZE
  • II_POST_4GLGEN
  • II_PRINTSCREEN _FILE
  • II_PRINT_UTF8ALIGN
  • II_RCP_STATS
  • II_REPORT_STRIPPED_CHARS
  • II_SQL_INIT
  • II_STAR_LOG
  • II_SYSTEM
  • II_TEMPORARY
  • II_TERMCAP_FILE
  • II_TFDIR
  • II_TIMEZONE_NAME
  • II_TM_EXIT_ON_ERROR
  • II_TM_HEADER_STYLE
  • II_TM_ON_ERROR
  • II_TUXEDO_LOC
  • II_TUX_SHARED
  • II_TUX_AS_MAX
  • II_TUX_XN_MAX
  • II_UNICODE_CONVERTER
  • II_UUID_MAC (Windows)
  • II_VNODE_PATH
  • II_WORK
  • II_XA_TRACE_FILE
  • IIDLDIR
  • ING_ABFDIR
  • ING_ABFOPT1
  • ING_EDIT
  • ING_PRINT
  • ING_SET
  • ING_SET_DBNAME
  • ING_SHELL (Linux)
  • ING_SYSTEM_SET
  • INGRES_KEYS
  • INIT_INGRES
  • TERM (Linux)
  • TERM_INGRES
  • VWLOG

Introducing Actian Ingres System Administration

VWLOG