• Introducing Actian Ingres Commands
  • Commands and Utilities
  • Audience
  • Special Considerations
  • System-specific Text in this Guide
  • Path Notation in this Guide
  • Linux Shell Used in this Guide
  • Query Language Used in this Guide
  • Syntax Conventions Used in this Guide
  • Where to Issue Commands
  • General Command Syntax
  • Standard Flags and Parameters
    • Dynamic Vnode Specification--Connect to Remote Node
    • Uppercase Flags
    • Schema Qualifier--Specify Ownership
    • Delimited Identifiers on the Command Line
      • Examples: Delimited Identifiers
• Using Actian Ingres Commands
  • abf Command--Invoke Applications-By-Forms
  • accessdb Command--Authorize User Access
  • aducompile Command--Install Customized Collation Sequence
  • alterdb Command--Set Database Characteristics
  • arcclean Command--Purge Records from Replicator Shadow and Archive Tables
    • arclean Example
  • auditdb Command--Audit a Database
    • auditdb Examples
  • blobstor Command--Copy a BLOB from a File to a Database
    • blobstor Examples
  • cacheutil Command--Show or Destroy Buffer Caches
  • catalogdb Command--List Databases That You Own
    • catalogdb Examples
  • cbf Command--Start Configuration-By-Forms
  • ckpdb Command--Checkpoint a Database
    • ckpdb Examples
  • clonedb Command--Clone a Database
    • clonedb Example
  • compform Command--Compile a Form
    • compform Example
  • convrep Command--Upgrade the Replicator Data Dictionary
  • convtohyb Command--Migrate Ingresdate and Character Data to X100 Types
    • convtohyb Examples
  • convtouni Command--Convert Character Data to Unicode
    • convtouni Examples
  • copyapp Command--Copy an Application to Another Database
    • copyapp Example
  • copydb Command--Copy and Restore a Database
    • copydb Example on Windows
    • copydb Example on Linux
  • copyform Command--Copy a Form to Another Database
    • copyform Examples
  • copyrep Command--Copy a Report to a Text File
    • copyrep Example
  • createdb Command--Create a Database
    • Create a Read-only Database
    • createdb Examples
  • cscleanup Command--Deallocate Shared Memory
  • csreport Command--Display Shared Memory Information
    • csreport Output
    • csreport Example: Show Server Connect IDs
  • dclgen Command--Generate Structure
    • dclgen Example
  • delobj Command--Delete Objects from Database
    • Object Specification for delobj Command
    • delobj Examples
  • dereplic Command--Remove Objects from Replicated Database
  • destroydb Command--Destroy a Database
    • destroydb Examples
  • eqc Command--Invoke Embedded QUEL Preprocessor for C
    • eqc Examples
  • esqla Command--Invoke Embedded SQL Preprocessor for Ada
  • esqlb Command--Invoke Embedded SQL Preprocessor for BASIC
  • esqlc Command--Invoke Embedded SQL Preprocessor for C
  • esqlcbl Command--Invoke Embedded SQL Preprocessor for COBOL
  • esqlcc Command--Invoke Embedded SQL Preprocessor for C++
  • esqlf Command--Invoke Embedded SQL Preprocessor for Fortran
  • extenddb Command--Extend Database to New Location
    • extenddb Examples
  • fastload Command--Load Binary Files into Database
    • fastload Example
  • genxml Command--Export Tables Into XML Format
    • genxml Examples
  • iea Command--Start the Export Assistant
    • iea Example
  • iia Command--Start the Import Assistant
  • iichkemail--Verify Email Setup
    • iichkemail Example
  • iigcfid Command--Display Server ID
    • iigcfid Example
  • iigenres Command--Generate CONFIG.DAT File
    • iigenres Example
  • iigetres Command--Get the Value of a Resource
  • iiinitres Command--Install Parameter into CONFIG.DAT
  • iijdbcprop Command--Generate Sample JDBC Driver Properties File
    • iijdbcprop Examples
  • iilink Command--Install User-defined Data Type
  • iimklog Command--Generate Transaction Log File
  • iimonitor Command--Administer DBMS, Recovery, and GCF Servers
    • iimonitor Utility Commands
      • Help Command
      • Show Server Command
      • Show Sessions Command
      • Format Sessions Command
      • Set Server Command
      • Stop Server Command
      • iimonitor Commands That Perform Actions on Sessions
      • dmtstatrcpstats Command
      • Quit Command
      • iimonitor Commands Specific to GCF Servers
  • iinamu Command--Administer the Name Server
    • iinamu Example: Show All Registered Servers
    • iinamu Example: Show All DBMS Servers for the Server Class Ingres
    • iinamu Example: Show Communications Server Registrations
    • iinamu Example: Add a DBMS Server to the Name Server Registry
    • iinamu Example: Delete a DBMS Server from the Name Server Registry
    • iinamu Example: Stop the Name Server
  • iinethost Command--Echo Full Network Name of Local Host
  • iiodbcadmin Command--Run ODBC Administrator
    • iiodbcadmin Examples
  • iiodbcinst Command--Create ODBC Configuration File
    • iiodbcinst Example
  • iipmhost Command--Echo Name of Host
  • iiremres Command--Remove Parameter from CONFIG.DAT
    • iiremres Example
  • iisetres Command--Set Configuration Parameter
    • iisetres Examples
  • iishowres Command--Display Memory Used by Locking and Logging
  • iisugetudflib Command--Download predefined UDFs
  • iisuitz Command--Install IANA Time Zone Files
  • iisuremotefs Command--Set up and Configure Remote File Systems Support
  • iisuspark Command--Download Spark Container Image and Configure Scala UDF Container Image
  • iisutensorflow Command--Manage TensorFlow UDF Container Image
  • iisuodbc Command--Run iiodbcinst Utility
  • iisuudfc Command--Download UDF Container Image from Repository
  • iivalres Command--Validate Configuration Resource
    • iivalres Example
  • imageapp Command--Build ABF or Vision Application Image
  • import_udflib Command--import predefined UDFs
    • Excluding functions from being imported
  • infodb Command--Display Database Information
    • Infodb Command Output – Database Information Section
    • Infodb Command Output – Journal Information Section
    • Infodb Command Output – Dump Information Section
    • Infodb Command Output – Checkpoint History for Journal Section
    • Infodb Command Output – Checkpoint History for Dump Section
    • Infodb Command Output – Cluster Journal History Section
    • Infodb Command Output – Extent Directory Section
  • inglogs Utility--Collects Ingres or Vector and Operating System information
  • ingmenu Command--Start Ingres Menu
    • ingmenu Examples
  • ingnet Command--View and Define Ingres Net Node Definitions
  • ingresSync Command - synchronize changes between copies of a database
  • ingstart Command--Start an Ingres Instance
    • ingstart Examples
  • ingstop Command--Stop an Ingres Instance
  • ingprenv Command--Display Environment Variable Value
    • ingprenv Example
  • ingsetenv Command--Set Ingres Environment Variable
    • ingsetenv Example
  • ingstatus Command--Show Server Status
  • ingunset Command--Delete Environment Variable
  • ipm Command--Start the Interactive Performance Monitor
  • iquel Command--Start Interactive QUEL Terminal Monitor
    • iquel Example
  • isql Command--Start Interactive SQL Terminal Monitor
    • isql Examples
  • ivm Command--Start Ingres Visual Manager
  • lartool Command--Start Logging, Archiving, and Recovery Utility
    • lartool Example
  • lockstat Command--Display Locking Status
    • Lockstat Command Output
    • Lockstat Command Output – Locking System Summary
    • Lockstat Command Output – Locking System Statistics
    • Lockstat Command Output – Statistics by Lock Type
    • Lockstat Command Output – Locks by Lock List
    • Lockstat Command Output – Locks by Resource
    • Lockstat Command Output – DLM Locks
  • logstat Command--Display Logging Status
    • Logstat Command Output – Logging System Summary
    • Logstat Command Output – Current Log File Header
    • Logstat Command Output – List of Active Processes
    • Logstat Command Output – List of Active Databases
    • Logstat Command Output – List of Transactions
    • logstat Example: Determine Databases that Are Active
    • logstat Example: Determine Proximity to FORCE-ABORT-LIMIT
  • mkrawarea Command--Make a Raw Area File
  • mkrawlog Command--Make a Raw Log File
  • mkrc Command--Generate System Service Script
  • modifyfe Command--Modify Storage Structure of Catalog
  • movedb Command--Copy Data Locations to Another Machine
    • movedb Example
  • netutil Command--Start Net Management Utility
    • netutil Examples
  • optimizedb Command--Generate Statistics for the Query Optimizer
    • Optimizedb -z Flags
    • optimizedb Example: Generate Full Statistics for a Database
    • optimizedb Example: Generate Statistics for Certain Columns
    • optimizedb Example: Generate Statistics for Certain Columns and Values, in Verbose Mode
    • optimizedb Example: Allow Unique Values from Each Column in a Table
  • printform Command--Print a Form to a File
    • printform Example
  • qbf Command--Start Query-By-Forms
    • qbf Examples
  • quel Command--Start the Line-based QUEL Terminal Monitor
    • quel Examples
  • query Command--Invoke QBF Query Execution
    • query Examples
  • rbf Command--Start Report-By-Forms
    • rbf Examples
  • rcpconfig Command--Control Logging and Locking System
  • rcpstat Command--Display Logging System Status
  • reconcil Command--Assist in Recovering Lost Data
    • reconcil Example: Perform Disaster Recovery
  • relocatedb Command--Move a Location to a New Location
    • relocatedb Example: Relocate Checkpoint Files
    • relocatedb Example: Relocate Journal Files
    • relocatedb Example: Relocate Dump Files
    • relocatedb Example: Relocate the Work Area
    • relocatedb Example: Copy Database to a New Database
  • repcat Command--Create and Load Replicator Catalogs
    • repcat Examples
  • repcfg Command--Configure Replicator
    • repcfg Examples
  • repdbcfg Command--Configure Multiple Mobile Databases
    • repdbcfg Examples
  • repinst Command--Create or Remove Replicator Servers and Windows Services
    • repinst Examples
  • repmgr Command--Start Replicator Manager
    • repmgr Example
  • repmod Command--Modify Replicator System Tables Storage Structure
  • report Command--Run a Report on a Table
    • report Examples
  • repstat Command--Display Replicator Transaction Statistics
  • rmcmdgen Command--Generate VDBA Remote Command Catalogs
  • rmcmdrmv Command--Remove VDBA Remote Command Catalogs
  • rmcmdstp Command--Stop the Remote Command Process
  • rollforwarddb Command--Recover a Database
    • rollforwarddb Examples
  • rpserver Command--Start Replicator Server
  • rsstatd Command--Display Replicator Server Statistics
  • sql Command--Start the Line-based SQL Terminal Monitor
    • sql Examples
    • Terminal Monitor Command Summary
  • sreport Command--Store Report Definition in a Database
    • sreport Example
  • starview Command--Start StarView
    • starview Example
  • statdump Command--Print Statistics in iistats and iihistogram Catalogs
    • statdump Examples
  • syscheck Command--Display and Verify System Resources
  • sysmod Command--Modify System Catalogs to Current Storage Structure
  • tables Command--Start the Tables Program
    • tables Example
  • unextenddb Command--Unextend a Database Location
  • unloaddb Command--Create Command Files for Unloading and Reloading a Database
    • unloaddb Examples
  • upgradedb Command--Upgrade a Database
  • upgradefe Command--Install and Upgrade Tool Catalog Definitions
    • upgradefe Examples
  • usermod Command--Modify Tables to Currently Defined Storage Structure
  • vcbf Command--Start Configuration Manager
  • vcda Command--Start the Visual Configuration Differences Analyzer
  • vdba Command--Start Visual DBA
    • vdba Examples
  • vdbamon Command--Start Visual Performance Monitor
  • vdbasql Command--Start Visual SQL
  • vdda Command--Start the Visual Database Objects Analyzer
  • verifydb Command--Clean Up Databases
    • verifydb Examples
  • verifylob Command--Analyze Long Data Types
  • vifred Command--Start the Visual Forms Editor
    • vifred Examples
  • vision Command--Start Vision
  • vwinfo Command--Display Information about a Database
  • vwload Command--Load Data into a Table
    • vwload Escape Sequences
    • vwload Date Format Settings
    • vwload Supported Character Sets
    • vwload in Parallel Mode
      • Requirements for Parallel vwload
      • Limitations of Parallel vwload
    • vwload from Remote System
    • vwload Examples
  • xmlimport Command--Import XML Data into Ingres
    • xmlimport Example
  • zdump Command--Display Time Zone Table Files
    • zdump Example
  • zic Command--Customize Time Zone Table Files

Introducing Actian Ingres Commands

zic Command--Customize Time Zone Table Files