• Administrator Guide
  • Introduction
    • In This Guide
      • System-specific Text in this Guide
    • The Enterprise Access Solution
      • Structured Query Language (SQL)
      • Possible Gateway Configurations
        • Local Gateway Configuration
        • Mixed Gateway Configuration
        • Remote Gateway Configuration
    • Connect to the Host DBMS through the Gateway
    • Your Support Options
      • Before Calling Technical Support
        • Windows Installation Information
        • UNIX Installation Information
  • DBMS Setup Requirements
    • How Gateway Access Works
      • Microsoft SQL Server Access Requirements
        • Gateway Configurations When Using OS Authentication
        • DSN Setup for Windows
        • Microsoft SQL Server Gateway and II_DECIMAL
      • Oracle Access Requirements
        • Oracle Instant Client Support
        • Grant User Permissions (Oracle)
      • ODBC Access Requirements
  • Gateway Alias Configuration
    • How a Gateway Alias Works
      • gwalias Command—Create Gateway Alias
    • Alias Parameters
      • How the Gateway Handles the iidbdb Alias
      • Alias Parameter Descriptions
      • Host Dbname Parameter Table
      • Username Parameter Variation Table
      • Password Parameter Variation Table
    • gwsetlogin Utility
      • Create an Alias with an Encrypted Connection
  • Gateway Catalog Setup
    • Gateway Catalog Build Utility
      • Run the Catalog Build Utility
    • Gateway Catalog Parameters
    • Special Considerations for Microsoft SQL Server
    • Special Considerations for ODBC Data Sources
    • iigwcat Utility (Windows Only)
      • Create or Upgrade Standard and Extended Catalogs
      • Upgrade Standard and Extended Catalogs or Migrate OR Catalogs
      • Upgrade Standard and Reset Extended Catalogs
      • Destroy All Catalogs
  • Basic Troubleshooting and Tracing
    • Check Individual Enterprise Access Processes on Windows
      • Check the Name Server on Windows
      • Check the Enterprise Access Server on Windows
      • Check the Communications Server on Windows
    • Check Individual Enterprise Access Processes on UNIX
      • Check the Name Server on UNIX
      • Check the Enterprise Access Server on UNIX
      • Check the Communications Server on UNIX
    • Common Errors when Connecting to an Enterprise Access Server
    • Check Character Set Compatibility
      • Check the Ingres Character Set
      • Check the Oracle DBMS Character Set
      • Check ODBC Host DBMS Code Page
      • Check the MS SQL Server DBMS Translation Setting
    • How to Debug with the Tracing Facility
      • Trace Identifiers
      • Tracing Methods
      • How to Trace a Gateway Server
        • Trace Output File
      • SET [NO]TRACE Statement—Trace Individual Gateway Sessions
        • Trace Output File
        • SET TRACE Examples
        • Disable Tracing
      • Native DBMS Tracing
    • How to Access Error Information
      • Examine the SQLCA Fields
      • Use the inquire_sql Statement
    • How You Can Look Up the Gateway Listen Address in the Error Log
  • Gateway Configuration Variables
    • How Gateway Parameters are Configured
      • iisetres Utility—Set Configuration Parameters
      • Configuration Parameter Descriptions
      • Microsoft SQL Only
      • Oracle Only
      • DB2 UDB Only

Administrator Guide

DB2 UDB Only