• Command Reference Guide
  • Introducing Ingres Commands
    • Commands and Utilities
    • Audience
    • Special Considerations
    • System-specific Text in this Guide
    • Path Notation in this Guide
    • UNIX Shells 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 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 UNIX
      • copydb Example on VMS
    • 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
      • 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
    • iimkcluster Command--Convert Ingres Instance to Cluster Node
    • 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
    • iisuitz Command--Install IANA Time Zone Files
    • iisunode Command--Set Up Node in a Cluster
    • iisuodbc Command--Run iiodbcinst Utility
    • iiuncluster Command--Convert Cluster to Standalone Instance
    • iivalres Command--Validate Configuration Resource
      • iivalres Example
    • imageapp Command--Build ABF or Vision Application Image
    • 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
    • ingmenu Command--Start Ingres Menu
      • ingmenu Examples
    • ingnet Command--View and Define Ingres Net Node Definitions
    • 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 Network 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
    • vmsinstal Command--Install Ingres on OpenVMS
    • 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

Command Reference Guide

zic Command--Customize Time Zone Table Files