Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Processors
• Documentation Accessibility
• Related Documents
• Conventions
• SQL*Plus Prompts
• Storage Measurements

1 Introduction

• Introduction to the Oracle Transparent Gateway
• Release 10g Gateways
• Gateway Capabilities
• • Transparency at All Levels
  • Extended Database Services
  • Extended Advanced Networking, Internet and Intranet Support
  • Dynamic Dictionary Mapping
  • SQL
  • Data Definition Language
  • Data Control Language
  • Passthrough and Native DB2 SQL
  • Stored Procedures
  • Languages
  • Oracle Database Technology and Tools
  • SQL*Plus
  • Two-Phase Commit and Multi-Site Transactions
  • Site Autonomy
  • Migration and Coexistence
  • Security
• Terms
• Architecture
• Implementation
• How the Gateway Works
• Oracle Tools and the Gateway
• • SQL*Plus
• Features

2 Release Information

• Product Set
• Changes and Enhancements
• Product Migration
• Bugs Fixed in Release 10.2.0
• Known Problems
• Known Restrictions
• • DB2 Considerations
  • SQL Limitations

3 System Requirements

• Hardware Requirements
• Software Requirements
• Documentation Requirements

4 Installing the Gateway

• Introduction
• Before You Begin
• Checklist for Gateway Installation
• Installation Overview
• Before Beginning Installation
• Installing the Gateway from CD-ROM
• Installation Complete
• Removing the Gateway

5 Configuring the DRDA Server

• Checklists for Configuring the DRDA Server
• DB2/OS390
• DB2/400
• DB2/UDB (Universal Database)
• DB2/VM

6 Configuring SNAP-IX Interfaces

• Checklist for Configuring the Communications Interfaces
• Before You Begin
• SNAP-IX Configuration Tool
• Creating SNAP-IX Profiles for the Gateway
• Independent Versus Dependent LUs
• Creating SNA Definitions for the Gateway
• • Sample SNAP-IX Definitions
  • Configuring SNAP-IX
• Using SNA Session Security Validation
• SNA Conversation Security
• • SNA Security Option SECURITY=PROGRAM
  • SNA Security Option SECURITY=SAME
• Testing the Connection

7 Configuring IBM Communication Server

• Checklist for Configuring the Communications Interfaces
• • Step 1: Configuring Communication Server Profiles
  • Step 2: Creating Communication Server Profiles for the Gateway
  • • Sample Profile Definitions
    • Profile Types
  • Step 3: Testing the Connection
• Using SNA Session Security Validation
• SNA Conversation Security
• • SNA Security Option SECURITY=PROGRAM
  • SNA Security Option SECURITY=SAME

8 Configuring SNAPlus2

• Checklist for Configuring the Communications Interfaces
• Before You Begin
• SNAPlus2 Configuration Tool
• Creating SNAPlus2 Profiles for the Gateway
• Independent Versus Dependent LUs
• Creating SNA Definitions for the Gateway
• • Sample SNAPlus2 Definitions
  • Configuring SNAPlus2
  • Invoking xsnapadmin
• Using SNA Session Security Validation
• • SNA Conversation Security
• Testing the Connection

9 Configuring TCP/IP

• Before You Begin
• Configuring TCP/IP under UNIX

10 Oracle Net

• Checklists for Oracle Net
• • Configuring Oracle Net
  • Advanced Security Encryption
  • • Setting Up Advanced Security Encryption for Test
    • Testing Advanced Security Encryptions
• Oracle Net Introduction
• Oracle Net Overview
• Configuring Oracle Net
• Advanced Security Encryption
• Setting Up Advanced Security Encryption for Test
• Testing Advanced Security Encryptions

11 Configuring the Gateway

• Configuration Checklists
• Choosing a Gateway System Identifier
• • Enter the SID on the Worksheet
• Configurating the Gateway
• Configuring the Host
• • Binding the DRDA Gateway Package
  • Binding Packages on DB2/Universal Database (DB2/UDB)
• DRDA Gateway Package Considerations
• • Before Binding the DRDA Gateway Package
  • • Step 1: Check all DRDA parameter settings
    • Step 2: If using DB2/UDB, then create ORACLE2PC table
  • Sample SQL scripts
  • • Step 1:  If server is DB2/OS390, DB2/400, or DB2/UDB, then run data dictionary scripts
• Backup and Recovery of Gateway Configuration
• Configuring the Oracle Integrating Server
• • Step 1: Create a database link
  • Step 2: Create synonyms and views
• Accessing the Gateway from Other Oracle Databases
• Accessing Other DRDA Servers
• Gateway Installation and Configuration Complete

12 Using the Oracle Transparent Gateway for DRDA

• Processing a Database Link
• • Creating Database Links
  • Dropping Database Links
  • Examining Available Database Links
  • Limiting the Number of Active Database Links
• Accessing the Gateway
• Accessing AS/400 File Members
• Using the Synonym Feature
• Performing Distributed Queries
• • Two-Phase Commit Processing
  • Distributed DRDA Transactions
• Read-Only Gateway
• Replicating in a Heterogeneous Environment
• Copying Data from Oracle Database 10g to DRDA Server
• Copying Data from DRDA Server to Oracle Database 10g Server
• Tracing SQL Statements

13 Developing Applications

• Gateway Appearance to Application Programs
• • Fetch Reblocking
• Using Oracle Stored Procedures with the Gateway
• Using DRDA Server Stored Procedures with the Gateway
• • Oracle Application and DRDA Server Stored Procedure Completion
  • Procedural Feature Considerations with DB2
• Database Link Behavior
• Oracle Database SQL Construct Processing
• • Compatible SQL Functions
  • Translated SQL Functions
  • Compensated SQL Functions
  • • Post-Processing
  • Native Semantic SQL Functions
  • DB2/OS390 SQL Compatibility
  • DB2/Universal Database SQL Compatibility
  • DB2/400 SQL Compatibility
  • DB2/VM SQL Compatibility
• Native Semantics
• • SQL Functions That Can Be Enabled
  • SQL Functions That Can Be Disabled
  • SQL Set Operators and Clauses
• DRDA Data type to Oracle Data type Conversion
• • Performing Character String Operations
  • Converting Character String Data types
  • Performing Graphic String Operations
  • Performing Date and Time Operations
  • • Processing TIME and TIMESTAMP Data
    • Processing DATE Data
    • Performing Date Arithmetic
  • Dates
  • HS_NLS_DATE_FORMAT Support
  • Oracle TO_DATE Function
  • Performing Numeric data type Operations
  • Mapping the COUNT Function
  • Performing Zoned Decimal Operations
• Passing Native SQL Statements through the Gateway
• • Using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
  • • Examples
  • Retrieving Results Sets Through Passthrough
  • • Example
• Oracle Data Dictionary Emulation on a DRDA Server
• • Using the Gateway Data Dictionary
  • Using the DRDA Catalog
• Defining the Number of DRDA Cursors

14 Security Considerations

• Security Overview
• Authenticating Application Logons
• Defining and Controlling Database Links
• • Link Accessibility
  • Links and CONNECT Clauses
• TCP/IP Security
• Processing Inbound Connections
• • User ID Mapping
  • • DB2/OS390
    • DB2/VM
    • DB2/400
    • DB2/Universal Database
• Passwords in the Gateway Initialization File

15 Migration and Coexistence with Existing Gateways

• Migrating Existing V4, V8, or V9 Gateway Instances to New Release
• Backout Considerations When Migrating to New Releases
• New and Changed Parameters When Migrating to Release 10g
• • New Parameters
  • Parameters That Have Been Changed in Usage
  • Parameters That Have Been Renamed
  • Obsolete Parameters
• DRDA Server Considerations
• Oracle Net Considerations

16 Error Messages, Diagnosis, and Reporting

• Interpreting Gateway Error Messages
• • Errors Detected by the Oracle Integrating Server
  • Errors Detected by the Gateway
  • Errors Detected in the DRDA Software
  • Communication Errors
  • Errors Detected by the Server Database
• Mapped Errors
• Gateway Error Codes
• SQL Tracing and the Gateway
• • SQL Tracing in the Oracle Database
  • SQL Tracing in the Gateway

A Oracle DB2 Data Dictionary Views

• Supported Views
• Data Dictionary View Tables
• • ALL_CATALOG
  • ALL_COL_COMMENTS
  • ALL_CONS_COLUMNS
  • ALL_CONSTRAINTS
  • ALL_INDEXES
  • ALL_IND_COLUMNS
  • ALL_OBJECTS
  • ALL_SYNONYMS
  • ALL_TABLES
  • ALL_TAB_COLUMNS
  • ALL_TAB_COMMENTS
  • ALL_USERS
  • ALL_VIEWS
  • COLUMN_PRIVILEGES
  • DICTIONARY
  • DUAL
  • TABLE_PRIVILEGES
  • USER_CATALOG
  • USER_COL_COMMENTS
  • USER_CONSTRAINTS
  • USER_CONS_COLUMNS
  • USER_INDEXES
  • USER_OBJECTS
  • USER_SYNONYMS
  • USER_TABLES
  • USER_TAB_COLUMNS
  • USER_TAB_COMMENTS
  • USER_USERS
  • USER_VIEWS

B Sample Files

• Sample Gateway Initialization File
• Sample Oracle Net tnsnames.ora File
• Sample Oracle Net listener.ora File

C DRDA-Specific Parameters

• Modifying the Gateway Initialization File
• Setting Parameters in the Gateway Initialization File
• Syntax and Usage
• Gateway Initialization File Parameters
• • DRDA_CACHE_TABLE_DESC
  • DRDA_CAPABILITY
  • DRDA_CODEPAGE_MAP
  • DRDA_COMM_BUFLEN
  • DRDA_CONNECT_PARM (SNA format)
  • DRDA_CONNECT_PARM (TCP/IP format)
  • DRDA_CMSRC_CM_IMMEDIATE
  • DRDA_DEFAULT_CCSID
  • DRDA_DESCRIBE_TABLE
  • DRDA_DISABLE_CALL
  • DRDA_FLUSH_CACHE
  • DRDA_GRAPHIC_CHAR_SIZE
  • DRDA_GRAPHIC_PAD_SIZE
  • DRDA_GRAPHIC_LIT_CHECK
  • DRDA_GRAPHIC_TO_MBCS
  • DRDA_ISOLATION_LEVEL
  • DRDA_LOCAL_NODE_NAME
  • DRDA_MBCS_TO_GRAPHIC
  • DRDA_OPTIMIZE_QUERY
  • DRDA_PACKAGE_COLLID
  • DRDA_PACKAGE_CONSTOKEN
  • DRDA_PACKAGE_NAME
  • DRDA_PACKAGE_OWNER
  • DRDA_PACKAGE_SECTIONS
  • DRDA_READ_ONLY
  • DRDA_RECOVERY_PASSWORD
  • DRDA_RECOVERY_USERID
  • DRDA_REMOTE_DB_NAME
  • DRDA_SECURITY_TYPE
  • FDS_CLASS
  • FDS_CLASS_VERSION
  • FDS_INSTANCE
  • HS_FDS_FETCH_ROWS
  • HS_LANGUAGE
  • HS_NLS_NCHAR
  • LOG_DESTINATION
  • ORA_MAX_DATE
  • ORA_NLS10
  • ORACLE_DRDA_TCTL
  • ORACLE_DRDA_TRACE
  • TRACE_LEVEL

D National Language Support

• Overview of NLS Interactions
• Client and Oracle Integrating Server Configuration
• Gateway Language Interaction with DRDA Server
• • Gateway Configuration
  • NLS Parameters in the Gateway Initialization File
  • • HS_LANGUAGE
    • HS_NLS_NCHAR
    • HS_NLS_DATE_FORMAT
    • HS_NLS_DATE_LANGUAGE
• Gateway Codepage Map Facility
• Multi-Byte and Double-Byte Support in the Gateway
• Message Availability
• Example of NLS Configuration

E Configuration Worksheet

F Quick Reference to Oracle SQL Functions

G Sample Applications

• DB2INS
• ORAIND

Index