Table of Contents

• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Documentation Accessibility
  • Conventions
• 1 Introduction to Oracle Database Provider for DRDA
  • 1.1 What is Oracle Database Provider for DRDA?
  • 1.2 Release Information
  • 1.3 DB2 Client Applications
    • 1.3.1 Remote DB2 Applications
    • 1.3.2 Native DB2 Applications
  • 1.4 Usage Scenarios for Oracle Database Provider for DRDA
• 2 Architecture of Oracle Database Provider for DRDA
  • 2.1 Protocol Considerations
  • 2.2 Two-Phase Commit and Transaction Recovery
  • 2.3 Autonomy of Service
  • 2.4 Packages
  • 2.5 SQL Dialect
• 3 Installation and Configuration of Oracle Database Provider for DRDA
  • 3.1 About Installing Oracle Database Provider for DRDA
    • 3.1.1 Installing Oracle Database Provider for DRDA
  • 3.2 Configuring Oracle Database Provider for DRDA
    • 3.2.1 Updating the drdaas.ora Configuration File
      • 3.2.1.1 DATA_PORT Considerations
      • 3.2.1.2 RDB_MAP Considerations
      • 3.2.1.3 Oracle Database Provider for DRDA Instance Considerations
    • 3.2.2 Installing Database Objects
      • 3.2.2.1 About Global Objects
      • 3.2.2.2 Creating a SYSIBM tablespace
      • 3.2.2.3 Installing Oracle Database Provider for DRDA Catalogs
      • 3.2.2.4 Installing DB2 SQL translator
      • 3.2.2.5 Designating Oracle Database Provider for DRDA Administrative Role
    • 3.2.3 SQL Translation Profile
      • 3.2.3.1 Prerequisites for Creating a SQL Translation Profile
      • 3.2.3.2 Creating a SQL Translation Interface Package and Translation Profile
    • 3.2.4 Configuration File: drdaas.ora
  • 3.3 Authorizing Oracle Database Provider for DRDA
    • 3.3.1 Administrator Role
      • 3.3.1.1 Granting DRDAAS_ADMIN_ROLE
      • 3.3.1.2 Adding DRDAA_ADMIN_ROLE
      • 3.3.1.3 Dropping ORACLE.MYPACKAGE by Administrator
      • 3.3.1.4 Dropping ORACLE.MYPACKAGE by User
      • 3.3.1.5 Maintaining DRDA Packages
    • 3.3.2 DRDA Package Authorization
      • 3.3.2.1 Managing a User’s Package Privileges
      • 3.3.2.2 Managing DRDA Package Translation Profile
    • 3.3.3 User Role
      • 3.3.3.1 Granting the DRDAAS_USER_ROLE
      • 3.3.3.2 Adding DRDAAS_USER_ROLE
  • 3.4 Uninstalling Oracle Database Provider for DRDA
    • 3.4.1 Removing the Database Objects
    • 3.4.2 Uninstalling Oracle Database Provider for DRDA software
  • 3.5 Configuration Parameters
    • 3.5.1 DATA_PORT
    • 3.5.2 RDB_MAP
    • 3.5.3 PROTOPROC_TRACE
    • 3.5.4 PROTOPROC_OPTIONS
• 4 SQL Translation and Examples for Oracle Database Provider for DRDA
  • 4.1 Overview of SQL Translation Process
    • 4.1.1 Implementing SQL Translation
    • 4.1.2 Requirements for SQL Translation
  • 4.2 Specifics of Translating DB2-Specific SQL Syntax
    • 4.2.1 DB2 Special Registers
    • 4.2.2 DB2 SQL Functions and Procedures
    • 4.2.3 DB2 Named Datatypes
    • 4.2.4 DB2 Syntactic Statements
  • 4.3 SQL Translator Interface Package
    • 4.3.1 About SQL Translator Interface Package
    • 4.3.2 Creating a SQL Translator Interface Package
    • 4.3.3 Granting EXECUTE Access to SQL Translator Interface Package
    • 4.3.4 Creating a SQL Translation Profile
      • 4.3.4.1 Granting Translation Authority Through Administrator Role
      • 4.3.4.2 Granting Translation Authority Through User Role
      • 4.3.4.3 Creating and Managing SQL Translation Profile
  • 4.4 Using Third-Party SQL Translators
    • 4.4.1 Using a Third-Party SQL Translator, Loaded as a Single Object
    • 4.4.2 Using a Third-Party SQL Translator, Loaded as Multiple Objects
  • 4.5 Using a Translator Management Script
  • 4.6 Verifying the SQL Translator Profile
  • 4.7 Altering the SQL Translation Profile
• 5 Administration and Customization of Oracle Database Provider for DRDA
  • 5.1 Migration Steps using Oracle Database Provider for DRDA
  • 5.2 Considerations for Using Oracle Database Provider for DRDA
  • 5.3 Prerequisites to Installing Oracle Database Provider for DRDA
  • 5.4 Administering DRDA Package Authority
  • 5.5 Migrating DB2 Data
  • 5.6 Retargeting the Application to Use Oracle Database
    • 5.6.1 Re-targeting Native Applications
    • 5.6.2 Re-targeting Remote Applications
  • 5.7 Translating SQL Statement and Typing Datatypes
    • 5.7.1 Registering a SQL Substitution Statement
    • 5.7.2 Registering an On-Demand Datatype Conversion
• 6 Diagnostics and Maintenance of Oracle Database Provider for DRDA
  • 6.1 Diagnostics for Oracle Database Provider for DRDA
  • 6.2 Maintaining Oracle Database Provider for DRDA
• 7 Datatype Support and Conversion in Oracle Database Provider for DRDA
  • 7.1 Overview of Datatype Conversion
  • 7.2 Numerical Range Considerations; General
    • 7.2.1 Oracle NUMBER
    • 7.2.2 FLOAT (IBM HEX or S390)
    • 7.2.3 FLOAT (IEEE)
    • 7.2.4 DECFLOAT
  • 7.3 Numerical Range Considerations, for COBOL Users
    • 7.3.1 Constraining Oracle NUMBER
  • 7.4 Conversion between DRDA Datatypes to Oracle Datatypes
    • 7.4.1 INTEGER
    • 7.4.2 SMALLINT
    • 7.4.3 BIGINT
    • 7.4.4 float
    • 7.4.5 DOUBLE PRECISION or FLOAT(b)
    • 7.4.6 REAL or FLOAT(b)
    • 7.4.7 DECIMAL(p,s)
    • 7.4.8 DECIMAL(p,s) zoned
    • 7.4.9 NUMERIC(p,s)
    • 7.4.10 DECFLOAT(n=34)
    • 7.4.11 DECFLOAT(n=16)
    • 7.4.12 CHAR(n)
    • 7.4.13 CHAR(n) for Bit Data
    • 7.4.14 VARCHAR(n)
    • 7.4.15 VARCHAR(n)
    • 7.4.16 VARCHAR(n) for Bit Data
    • 7.4.17 VARCHAR(n)
    • 7.4.18 VARCHAR(n)
    • 7.4.19 VARCHAR(n) for Bit Data
    • 7.4.20 char(n+1)
    • 7.4.21 char(n+1)
    • 7.4.22 char(n) for Bit Data
    • 7.4.23 VARGRAPHIC(n)
    • 7.4.24 GRAPHIC(n)
    • 7.4.25 VARGRAPHIC(n)
    • 7.4.26 char(n) (Pascal L String)
    • 7.4.27 char(n) for Bit Data (Pascal L String)
    • 7.4.28 DATE
    • 7.4.29 TIME
    • 7.4.30 TIMESTAMP
    • 7.4.31 (datalink)
    • 7.4.32 BLOB
    • 7.4.33 CLOB
    • 7.4.34 DBCLOB
    • 7.4.35 BLOB LOCATOR
    • 7.4.36 CLOB LOCATOR
    • 7.4.37 DBCLOB LOCATOR
    • 7.4.38 boolean
    • 7.4.39 BINARY(n)
    • 7.4.40 VARBINARY(n)
    • 7.4.41 XML
  • 7.5 Conversion of Oracle Datatype to DRDA
    • 7.5.1 BINARY_FLOAT
    • 7.5.2 BINARY_DOUBLE
    • 7.5.3 VARCHAR2(n)
    • 7.5.4 LONG
    • 7.5.5 LONG RAW
    • 7.5.6 NVARCHAR2(n)
    • 7.5.7 CHAR(n)
      • 7.5.7.1 Shorter version
      • 7.5.7.2 Longer Version
    • 7.5.8 NCHAR(n)
      • 7.5.8.1 Shorter version
      • 7.5.8.2 Longer Version
    • 7.5.9 UROWID
    • 7.5.10 DATE
    • 7.5.11 TIMESTAMP
    • 7.5.12 TIMESTAMP WITH LOCAL TIME ZONE
    • 7.5.13 TIMESTAMP(p) WITH TIME ZONE
    • 7.5.14 RAW(n)
    • 7.5.15 NUMBER and FLOAT
  • 7.6 Datatype Equivalence and Remapping
    • 7.6.1 Applying Datatype Mapping
    • 7.6.2 Using TYPEMAP in Queries
    • 7.6.3 Using TYPEMAP in Functions
    • 7.6.4 Oracle NUMBER TYPEMAP
• 8 Data Dictionary for Oracle Database Provider for DRDA
  • 8.1 Data Dictionary Emulation in Oracle Database Provider for DRDA
    • 8.1.1 DB2 for z/OS
  • 8.2 Data Dictionary Views for Oracle Database Provider for DRDA
    • 8.2.1 ALL_DRDAASPACKAGE Data Dictionary View
    • 8.2.2 ALL_DRDAASPACKAUTH Data Dictionary View
    • 8.2.3 ALL_DRDAASPACKSIDE Data Dictionary View
    • 8.2.4 DBA_DRDAASPACKAGE Data Dictionary View
    • 8.2.5 DBA_DRDAASPACKAUTH Data Dictionary View
    • 8.2.6 DBA_DRDAASPACKSIDE Data Dictionary View
    • 8.2.7 DBA_DRDAASPACKSTMT Data Dictionary View
    • 8.2.8 DBA_DRDAASTRACE Data Dictionary View
    • 8.2.9 USER_DRDAASPACKAGE Data Dictionary View
    • 8.2.10 USER_DRDAASPACKAUTH Data Dictionary View
    • 8.2.11 USER_DRDAASPACKSIDE Data Dictionary View
    • 8.2.12 USER_DRDAASPACKSTMT Data Dictionary View
    • 8.2.13 USER_DRDAASTRACE Data Dictionary View
• 9 Error Codes Support in Oracle Database Provider for DRDA
  • 9.1 Oracle Error Codes
    • 9.1.1 Error Code Mapping, from Oracle to DRDA
• 10 Command-line Utility for Oracle Database Provider for DRDA
  • 10.1 Command-line Utility
    • 10.1.1 START
    • 10.1.2 STOP
    • 10.1.3 STATUS
    • 10.1.4 TRACE
    • 10.1.5 PAUSE
    • 10.1.6 RESUME
    • 10.1.7 RELOAD
    • 10.1.8 EXIT
• 11 Security and Storage Considerations for Oracle Database Provider for DRDA
  • 11.1 Overview of Security and Storage for Oracle Database Provider for DRDA
  • 11.2 Authentication and Encryption in Oracle Database Provider for DRDA
    • 11.2.1 Authentication Services
    • 11.2.2 Encryption Services
  • 11.3 Database Roles in Oracle Database Provider for DRDA
    • 11.3.1 DRDAAS_ADMIN_ROLE
    • 11.3.2 DRDAAS_USER_ROLE
  • 11.4 Storage in Oracle Database Provider for DRDA
    • 11.4.1 SYSIBM Tablespace
    • 11.4.2 SYSIBM User
• 12 Restrictions on Using Oracle Database Provider for DRDA
  • 12.1 Resynch Manager
  • 12.2 Cursor HOLD Attribute Semantics
  • 12.3 DB2 Password Blank Padding
  • 12.4 Restrictions on Datatypes
    • 12.4.1 DATE Datatype
    • 12.4.2 Oracle Object-Relational Datatypes
    • 12.4.3 TIMESTAMP Datatype
    • 12.4.4 TIMESTAMP WITH TIMEZONE Datatype
    • 12.4.5 XML Datatype
    • 12.4.6 SYS.XMLType Datatype
  • 12.5 Extended Length Mode
  • 12.6 DB2 for z/OS Log usage
  • 12.7 Other Restrictions
• 13 PL/SQL Packages Used by Oracle Database Provider for DRDA
  • 13.1 DBMS_DRDAAS_ADMIN Package
    • 13.1.1 DBMS_DRDAAS_ADMIN Privilege Constants
    • 13.1.2 GRANT_PRIVILEGE
    • 13.1.3 REVOKE_PRIVILEGE
    • 13.1.4 DROP_PACKAGE
    • 13.1.5 DROP_PACKAGE_VN
    • 13.1.6 DROP_PACKAGE_CT
    • 13.1.7 SET_PROFILE
    • 13.1.8 SET_LOCALDATE_FORMAT
    • 13.1.9 SET_LOCALTIME_FORMAT
    • 13.1.10 SET_TYPEMAP
  • 13.2 DBMS_DRDAAS Package
    • 13.2.1 DBMS_DRDAAS Privilege Constants
    • 13.2.2 BIND_PACKAGE
    • 13.2.3 BIND_STATEMENT
    • 13.2.4 END_BIND
    • 13.2.5 GRANT_PRIVILEGE
    • 13.2.6 REVOKE_PRIVILEGE
    • 13.2.7 DROP_PACKAGE
• 14 SQL Statement Support in Oracle Database Provider for DRDA
  • 14.1 Overview of SQL Statement Support
  • 14.2 SQL Clause Restrictions
    • 14.2.1 Internally Processed SQL Statements
    • 14.2.2 Removed SQL Clauses that Retain Semantic Effect
    • 14.2.3 Ignored SQL Clauses
    • 14.2.4 Translated SQL Clauses
  • 14.3 Support for Special Registers
    • 14.3.1 Retrieving Values from Special Registers
    • 14.3.2 Setting Special Registers
    • 14.3.3 Special Registers Supported by Oracle Database Provider for DRDA
      • 14.3.3.1 APPLICATION ENCODING SCHEME
      • 14.3.3.2 CLIENT_ACCTNG
      • 14.3.3.3 CLIENT_APPLNAME
      • 14.3.3.4 CLIENT_PROGRAMID
      • 14.3.3.5 CLIENT_USERID
      • 14.3.3.6 CLIENT_WRKSTNNAME
      • 14.3.3.7 DATE
      • 14.3.3.8 DBPARTITIONNUM
      • 14.3.3.9 DEBUG MODE
      • 14.3.3.10 DECFLOAT ROUNDING MODE
      • 14.3.3.11 DEFAULT TRANSFORM GROUP
      • 14.3.3.12 DEGREE
      • 14.3.3.13 EXPLAIN MODE
      • 14.3.3.14 EXPLAIN SNAPSHOT
      • 14.3.3.15 FEDERATED ASYNCHRONY
      • 14.3.3.16 IMPLICIT XMLPARSE OPTION
      • 14.3.3.17 ISOLATION
      • 14.3.3.18 LOCK TIMEOUT
      • 14.3.3.19 LOCALE LC_TYPE
      • 14.3.3.20 MAINTAINED TABLE TYPES FOR OPTIMIZATION
      • 14.3.3.21 MEMBER
      • 14.3.3.22 OPTIMIZATION HINT
      • 14.3.3.23 PACKAGE PATH
      • 14.3.3.24 PACKAGESET
      • 14.3.3.25 PATH
      • 14.3.3.26 PRECISION
      • 14.3.3.27 QUERY ACCELERATION
      • 14.3.3.28 QUERY OPTIMIZATION
      • 14.3.3.29 REFRESH AGE
      • 14.3.3.30 ROUTINE VERSION
      • 14.3.3.31 RULES
      • 14.3.3.32 SCHEMA
      • 14.3.3.33 SERVER
      • 14.3.3.34 SQL_CCFLAGS
      • 14.3.3.35 SQLID
      • 14.3.3.36 TIMESTAMP
      • 14.3.3.37 USER
      • 14.3.3.38 SESSION_USER
      • 14.3.3.39 SYSTEM_USER
      • 14.3.3.40 ENCRYPTION PASSWORD
• A Scripts for Creating and Maintaining Oracle Database Provider for DRDA
  • A.1 catdrdaas.sql
  • A.2 catnodrdaas.sql
  • A.3 drdapkg_db2.sql
  • A.4 drdasqtt_translator_setup.sql
  • A.5 drdasqt_set_profile_dd.sql
• B Package Binding Options in Oracle Database Provider for DRDA
• Glossary
• Index