Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

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

1 Introduction

• 1.1 Introduction to the Oracle Database Gateway for DRDA
• 1.2 Release 11g Gateways
• 1.3 Gateway Capabilities
  • 1.3.1 Transparency at All Levels
  • 1.3.2 Extended Database Services
  • 1.3.3 Extended Advanced Networking, Internet and Intranet Support
  • 1.3.4 Dynamic Dictionary Mapping
  • 1.3.5 SQL
  • 1.3.6 Data Definition Language
  • 1.3.7 Data Control Language
  • 1.3.8 Passthrough and Native DB2 SQL
  • 1.3.9 Stored Procedures
  • 1.3.10 Languages
  • 1.3.11 Oracle Database Technology and Tools
  • 1.3.12 SQL*Plus
  • 1.3.13 Two-Phase Commit and Multi-Site Transactions
  • 1.3.14 Site Autonomy
  • 1.3.15 Migration and Coexistence
  • 1.3.16 Security
  • 1.3.17 DRDA UDB Server Encryption support
• 1.4 Terms
• 1.5 Architecture
• 1.6 Implementation
• 1.7 How the Gateway Works
• 1.8 Oracle Tools and the Gateway
  • 1.8.1 SQL*Plus
• 1.9 Features

2 Release Information

• 2.1 Product Set
• 2.2 Changes and Enhancements
  • 2.2.1 Gateway Password Encryption Tool
  • 2.2.2 CHAR Semantics
  • 2.2.3 Multi-byte Character Sets Ratio Suppression
  • 2.2.4 IPv6 Support
  • 2.2.5 Gateway Session IDLE Timeout
  • 2.2.6 Result Sets and Stored Procedures
• 2.3 Product Migration
• 2.4 Known Problems
• 2.5 Known Restrictions
  • 2.5.1 DB2 Considerations
    • 2.5.1.1 DD Basic Tables and Views
    • 2.5.1.2 SUBSTR Function Post-Processed
    • 2.5.1.3 Data type Limitations
    • 2.5.1.4 Null Values and Stored Procedures
    • 2.5.1.5 String Concatenation of Numbers
    • 2.5.1.6 GLOBAL_NAMES Initialization Parameter
    • 2.5.1.7 DRDA Package and DB2 considerations
    • 2.5.1.8 Date Arithmetic
    • 2.5.1.9 Row Length Limitation
    • 2.5.1.10 LONG Data type in SQL*Plus
    • 2.5.1.11 Stored Procedures and Transaction Integrity
  • 2.5.2 SQL Limitations
    • 2.5.2.1 Oracle SQL Command INSERT
    • 2.5.2.2 Oracle ROWID Column
    • 2.5.2.3 Oracle Bind Variables
    • 2.5.2.4 CONNECT BY Is Not Supported
    • 2.5.2.5 CALLBACK links

3 Using the Oracle Database Gateway for DRDA

• 3.1 DRDA Gateway Features
  • 3.1.1 CHAR Semantics
  • 3.1.2 Multi-byte Character Sets Ratio Suppression
  • 3.1.3 IPv6 Support
  • 3.1.4 Gateway Session IDLE Timeout
• 3.2 Processing a Database Link
  • 3.2.1 Creating Database Links
  • 3.2.2 Dropping Database Links
  • 3.2.3 Examining Available Database Links
  • 3.2.4 Limiting the Number of Active Database Links
• 3.3 Accessing the Gateway
• 3.4 Accessing i5/OS File Members
• 3.5 Using the Synonym Feature
• 3.6 Performing Distributed Queries
  • 3.6.1 Two-Phase Commit Processing
  • 3.6.2 Distributed DRDA Transactions
• 3.7 Replicating in a Heterogeneous Environment
• 3.8 Copying Data from Oracle Database to DRDA Server
• 3.9 Copying Data from DRDA Server to Oracle Database
• 3.10 Tracing SQL Statements

4 Developing Applications

• 4.1 Gateway Appearance to Application Programs
  • 4.1.1 Fetch Reblocking
• 4.2 Using Oracle Stored Procedures with the Gateway
• 4.3 Using DRDA Server Stored Procedures with the Gateway
  • 4.3.1 Oracle Application and DRDA Server Stored Procedure Completion
  • 4.3.2 Procedural Feature Considerations with DB2
  • 4.3.3 Result Sets and Stored Procedures
    • 4.3.3.1 OCI Program Fetching from Result Sets in Sequential Mode
    • 4.3.3.2 PL/SQL Program Fetching from Result Sets in Sequential Mode
• 4.4 Database Link Behavior
• 4.5 Oracle Database SQL Construct Processing
  • 4.5.1 Compatible SQL Functions
  • 4.5.2 Translated SQL Functions
  • 4.5.3 Compensated SQL Functions
    • 4.5.3.1 Post-Processing
  • 4.5.4 Native Semantic SQL Functions
  • 4.5.5 DB2 UDB for z/OS SQL Compatibility
  • 4.5.6 DB2 UDB for Unix, Linux, and Windows Compatibility
  • 4.5.7 DB2 UDB for iSeries Compatibility
• 4.6 Native Semantics
  • 4.6.1 SQL Functions That Can Be Enabled
  • 4.6.2 SQL Functions That Can Be Disabled
  • 4.6.3 SQL Set Operators and Clauses
• 4.7 DRDA Data type to Oracle Data type Conversion
  • 4.7.1 Performing Character String Operations
  • 4.7.2 Converting Character String Data types
  • 4.7.3 Performing Graphic String Operations
  • 4.7.4 Performing Date and Time Operations
    • 4.7.4.1 Processing TIME and TIMESTAMP Data
    • 4.7.4.2 Processing DATE Data
    • 4.7.4.3 Performing Date Arithmetic
  • 4.7.5 Dates
  • 4.7.6 NLS_DATE_FORMAT Support
  • 4.7.7 Oracle TO_DATE Function
  • 4.7.8 Performing Numeric data type Operations
  • 4.7.9 Mapping the COUNT Function
  • 4.7.10 Performing Zoned Decimal Operations
• 4.8 Passing Native SQL Statements through the Gateway
  • 4.8.1 Processing DDL Statements through Passthrough
  • 4.8.2 Using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
    • 4.8.2.1 Examples
  • 4.8.3 Retrieving Results Sets Through Passthrough
    • 4.8.3.1 Example
• 4.9 Oracle Data Dictionary Emulation on a DRDA Server
  • 4.9.1 Using the Gateway Data Dictionary
  • 4.9.2 Using the DRDA Catalog

5 Error Messages, Diagnosis, and Reporting

• 5.1 Interpreting Gateway Error Messages
  • 5.1.1 Errors Detected by the Gateway
  • 5.1.2 Errors Detected in the DRDA Software
  • 5.1.3 Errors Detected by the DRDA Server
• 5.2 Mapped Errors
• 5.3 SQL Tracing and the Gateway
  • 5.3.1 SQL Tracing in the Oracle Database

A Oracle DB2 Data Dictionary Views

• A.1 Supported Views
• A.2 Data Dictionary View Tables
  • A.2.1 ALL_CATALOG
  • A.2.2 ALL_COL_COMMENTS
  • A.2.3 ALL_CONS_COLUMNS
  • A.2.4 ALL_CONSTRAINTS
  • A.2.5 ALL_INDEXES
  • A.2.6 ALL_IND_COLUMNS
  • A.2.7 ALL_OBJECTS
  • A.2.8 ALL_SYNONYMS
  • A.2.9 ALL_TABLES
  • A.2.10 ALL_TAB_COLUMNS
  • A.2.11 ALL_TAB_COMMENTS
  • A.2.12 ALL_USERS
  • A.2.13 ALL_VIEWS
  • A.2.14 COLUMN_PRIVILEGES
  • A.2.15 DICTIONARY
  • A.2.16 DUAL
  • A.2.17 TABLE_PRIVILEGES
  • A.2.18 USER_CATALOG
  • A.2.19 USER_COL_COMMENTS
  • A.2.20 USER_CONSTRAINTS
  • A.2.21 USER_CONS_COLUMNS
  • A.2.22 USER_INDEXES
  • A.2.23 USER_OBJECTS
  • A.2.24 USER_SYNONYMS
  • A.2.25 USER_TABLES
  • A.2.26 USER_TAB_COLUMNS
  • A.2.27 USER_TAB_COMMENTS
  • A.2.28 USER_USERS
  • A.2.29 USER_VIEWS

B Initialization Parameters

• B.1 Initialization Parameter File Syntax
• B.2 Oracle Database Gateway for DRDA Initialization Parameters
• B.3 Initialization Parameter Description
  • B.3.1 HS_CALL_NAME
  • B.3.2 HS_DB_DOMAIN
  • B.3.3 HS_DB_INTERNAL_NAME
  • B.3.4 HS_DB_NAME
  • B.3.5 HS_DESCRIBE_CACHE_HWM
  • B.3.6 HS_LANGUAGE
    • B.3.6.1 Character Sets
    • B.3.6.2 Language
    • B.3.6.3 Territory
  • B.3.7 HS_LONG_PIECE_TRANSFER_SIZE
  • B.3.8 HS_OPEN_CURSORS
  • B.3.9 HS_RPC_FETCH_REBLOCKING
  • B.3.10 HS_RPC_FETCH_SIZE
  • B.3.11 HS_TRANSACTION_MODEL
  • B.3.12 IFILE
  • B.3.13 HS_FDS_CONNECT_INFO
  • B.3.14 HS_FDS_RECOVERY_ACCOUNT
  • B.3.15 HS_FDS_RECOVERY_PWD
  • B.3.16 HS_FDS_DEFAULT_OWNER
  • B.3.17 HS_FDS_FETCH_ROWS
  • B.3.18 HS_FDS_TRACE_LEVEL
  • B.3.19 HS_FDS_TRANSACTION_LOG
  • B.3.20 HS_IDLE_TIMEOUT
  • B.3.21 HS_FDS_MBCS_TO_GRAPHIC
  • B.3.22 HS_FDS_GRAPHIC_TO_MBCS
  • B.3.23 HS_FDS_TIMESTAMP_MAPPING
  • B.3.24 HS_FDS_QUOTE_IDENTIFIER
  • B.3.25 HS_FDS_CAPABILITY
  • B.3.26 HS_FDS_ISOLATION_LEVEL
  • B.3.27 HS_FDS_PACKAGE_COLLID
  • B.3.28 HS_NLS_LENGTH_SEMANTICS
  • B.3.29 HS_KEEP_REMOTE_COLUMN_SIZE
  • B.3.30 HS_FDS_RESULTSET_SUPPORT
  • B.3.31 HS_FDS_REMOTE_DB_CHARSET
  • B.3.32 HS_FDS_SUPPORT_STATISTICS
  • B.3.33 HS_FDS_RSET_RETURN_ROWCOUNT
  • B.3.34 HS_FDS_AUTHENTICATE_USER
  • B.3.35 HS_FDS_ENCRYPT_SESSION
  • B.3.36 HS_FDS_TRUSTSTORE_FILE
  • B.3.37 HS_FDS_TRUSTSTORE_PASSWORD
  • B.3.38 HS_FDS_SQLLEN_INTERPRETATION

Index