• 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 Microsoft SQL Server Considerations
  •  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