Skip Headers

Oracle® Transparent Gateway for iWay Installation and User's Guide
10g Release 1 (10.1) for IBM z/OS (OS/390)
Part No. B13682-01
  Go To Index
Index

Next
Next
 

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Related Documents
Conventions Used in this Guide
SQL*Plus Prompts
Storage Measurements
Switches

1 Introduction

1.1 Version 10 Gateways
1.1.1 Advantages of the Gateway
1.1.1.1 Transparency at All Levels
1.1.1.2 Extends Database Services
1.1.1.3 Extends Advanced Networking, Internet, and Intranet Support
1.1.1.4 Dynamic Dictionary Mapping
1.1.2 SQL
1.1.3 Stored Procedures
1.1.3.1 Oracle Stored Procedures
1.1.3.2 Native Stored Procedures with iWay Server
1.1.4 Applications
1.1.4.1 Oracle Developer
1.1.4.2 Oracle Discoverer
1.1.4.3 SQL*Plus
1.1.4.4 Oracle Database Server Technology and Tool
1.2 Two-Phase Commit and Multi-Site Transactions
1.3 Site Autonomy
1.4 Migration and Coexistence
1.5 Security
1.6 Protection of Current Investment
1.7 Gateway Architecture
1.7.1 Ease of Implementation
1.8 Components and Requirements
1.9 How the Gateway Works
1.10 SQL Differences

2 Release Information

2.1 Product Set
2.2 Changes and Enhancements in ReleaseĀ 10.1.0.2.0
2.3 Known Problems and Known Restrictions
2.3.1 Known Problems
2.3.1.1 Advanced Network Option, Bug Number 661051
2.3.1.2 Number of Rows Updated
2.3.1.3 Interrupting Queries
2.3.2 Known Restrictions
2.3.2.1 Encrypted Format Logon
2.3.2.2 iWay Server Security Considerations
2.3.2.3 Write Support
2.3.2.4 SQL Support with INSERT, UPDATE, and DELETE
2.3.2.5 Fixed Character 255 Maximum Length
2.3.2.6 iWay Server DATE Columns Mapped as CHAR(8)
2.3.2.7 Programmatic Limitations
2.3.2.8 SQL Limitations
2.3.2.9 Oracle Schema Names and iWay Server
2.3.2.10 Oracle User Data Dictionary Limitations
2.3.2.11 Oracle Fast Refresh Snapshots
2.3.2.12 64-Character Synonym Support with iWay Server

3 System Requirements

3.1 Resource Requirements
3.1.1 CPU
3.1.2 Disk Space
3.1.3 Virtual Memory
3.2 Software Requirements
3.3 Operating System
3.3.1 UNIX System Services (USS)
3.3.2 IBM Maintenance
3.3.3 Additional Software Requirements
3.4 Oracle Database Server Requirements
3.5 Oracle Net Requirements
3.6 Distribution Kit

4 Installation

4.1 Installation Checklists
4.2 Installation Steps for the Gateway Software
4.2.1 Step 1: Running the Oracle Universal Installer (OUI)
4.2.1.1 Refer to Database Installation Guide
4.2.1.2 Return From Database Installation Guide
4.2.2 Step 2: Installing the Gateway
4.2.2.1 Reviewing Product-Specific Installation Guidelines
4.2.2.2 Running the Oracle Universal Installer
4.2.3 Step 3: Running the Generated Installation Job
4.2.4 Step 4: Downloading and Installing Patches
4.2.5 Step 5: Adding Program Properties
4.2.6 Step 6: Authorizing the Gateway Load Library
4.2.7 Step 7: Using Dynamic z/OS Commands (to Avoid IPL)
4.2.8 Step 8: Installation Summary

5 Configuring the Gateway

5.1 Checklists
5.1.1 Pre Configuration Checklist
5.1.2 Configuration Checklist
5.1.3 Post Configuration Checklist
5.2 Overview
5.3 Configuration Introduction
5.4 Pre Configuration
5.4.1 iWay Server Installation
5.4.2 iWay Server Configuration
5.4.2.1 Client-Side Network Configuration File
5.4.2.2 Example:
5.5 Gateway Service Definition
5.5.1 DEFINE Parameter Considerations
5.5.1.1 Service Name
5.5.1.2 TYPE
5.5.1.3 PROC
5.5.1.4 PARM
5.5.1.5 MAXAS
5.5.1.6 JOBNAME
5.5.1.7 SID
5.6 Gateway Region JCL
5.6.1 DD Statements Needed to Change JCL Procedure of a Service
5.6.1.1 ORA$ENV
5.6.1.2 ORA$FPS
5.6.1.3 Example
5.6.1.4 ORA$LIB
5.6.1.5 SQLNET
5.6.1.6 SQLNETLG
5.6.1.7 STEPLIB
5.6.1.8 SYSPRINT
5.6.1.9 Sample Database Region JCL Procedure
5.7 Gateway Region Parameters
5.7.1 Database Region Parameter Descriptions
5.7.1.1 ALERT_DSNAME | ADSN
5.7.1.2 DEDICATED_TCB | DEDTCB
5.7.1.3 DSN_PREFIX_DB | ORAPREFD
5.7.1.4 IDLE_TIMEOUT | TIMEOUT
5.7.1.5 INIT_ADR_SPACES | INTADSPC
5.7.1.6 INIT_STACK_SIZE | INTSTKSZ
5.7.1.7 PRIMARY_ASC_MODE | PRIMASCM
5.7.1.8 REGION_MEM_RESERVE | REGMRES
5.8 Creating a Gateway Instance
5.8.1 Creating a Database Instance with the Configuration Utility
5.8.1.1 Step 1: Run the Configuration Utility
5.8.1.2 Step 2: Customize JCL Procedures and Parameter Files
5.8.1.3 Step 3: Copy the Subsystem PROCs to a System PROCLIB
5.8.1.4 Step 4: Define and Start OSDI Services
5.9 Configuration Steps
5.9.1 Step 1: OSDI Parameters
5.9.2 Step 2: Re-IPL z/OS or Use Dynamic z/OS Commands
5.9.3 Step 3: Associate Userids with Services
5.9.4 Step 4: Start the Gateway
5.10 Post Configuration Steps
5.10.1 Step 1: Move Reentrant Modules to z/OS Link Pack Areas
5.10.2 Step 2: Examine Oracle Dump Data Sets and Modify as Necessary
5.10.3 Step 3: Examine Oracle Trace Data Sets and Modify as Necessary

6 Oracle Net

6.1 Oracle Net Overview
6.2 OSDI Listener Architecture
6.3 OSDI Listener Filenames
6.4 Configuring the OSDI Listener
6.4.1 Network Service Definition
6.4.2 Service Name
6.4.3 TYPE
6.4.4 PROC
6.4.5 PARM
6.4.5.1 Example of Network Service Definition
6.4.6 OSDI Listener Region JCL
6.4.6.1 Example of Network Service Procedure JCL
6.4.6.2 Example of NETLOG output
6.4.7 TCP/IP Network Considerations
6.4.8 Client-Server Access Using the OSDI Listener
6.4.8.1 Remote Clients
6.4.8.2 Name Server
6.4.8.3 LDAP Server
6.5 Operating the OSDI Listener
6.6 Formatting OSDI Listener Trace Files
6.7 Oracle Advanced Security Option Encryption
6.7.1 Setting Up ASO Encryption for Test
6.7.1.1 Checklist for Setting Up ASO Encryption
6.7.1.2 Step 1: Set ASO Encryption Parameters for the Server
6.7.1.3 Step 2: Set ASO Encryption Parameters for the Client
6.7.2 Testing ASO Encryption
6.7.2.1 Checklist for Testing ASO Encryption
6.7.2.2 Step 1: Connect Client and Server
6.7.2.3 Step 2: Reset Configuration Parameters on Server

7 Administering the Gateway

7.1 Operation of the Gateway Subsystem with OSDI
7.1.1 START
7.1.2 STOP
7.2 Controlling Access to OSDI Subsystem Commands
7.3 Controlling Access to OSDI Services
7.4 Gateway Security
7.4.1 iWay Server Security Considerations

8 Using the Gateway

8.1 Introduction
8.2 Database Link Behavior
8.2.1 Creating Database Links
8.2.2 Creating Database Links Using Oracle Net
8.2.3 Guidelines for Database Links
8.2.4 Accessing Data Through a Database Link
8.2.5 Dropping a Database Link
8.2.6 Examining Available Database Links
8.2.7 Limiting the Number of Active Database Links
8.3 Using the Synonym Feature
8.4 Performing Distributed Queries
8.4.1 Example of a Distributed Query
8.5 Copying Data
8.6 Streams Replication

9 Developing Applications

9.1 Gateway Appearance to Application Programs
9.2 Array Processing
9.2.1 Fetch Reblocking
9.3 SQL Functions
9.4 Data Type Conversion
9.4.1 Performing Date and Time Operations
9.4.2 Date Considerations in SQL Coding
9.4.3 Dates in the 21st Century
9.4.4 Oracle TO_DATE Function
9.4.5 Date Arithmetic
9.4.6 Oracle ROWID Column
9.5 Oracle Server and iWay Server Differences
9.5.1 Handling Binary Data
9.5.2 USER and UID SQL Functions
9.5.3 Oracle Bind Variables
9.6 Using Oracle Stored Procedures with the Gateway
9.7 Using Focus Stored Procedures with the Gateway
9.7.1 Running Oracle Applications with Focus Stored Procedures
9.7.2 Defining Stored Procedures in iWay Server SYSRPC Dynamic Catalog Table

10 Error Messages, Diagnosis, and Reporting

10.1 Message and Error Code Processing
10.1.1 Interpreting Message Formats
10.1.1.1 Example:
10.1.2 Messages Generated by Oracle Transparent Gateway for iWay
10.1.2.1 Example
10.1.3 Diagnosing Errors Detected by the Oracle Server
10.2 Oracle Support Services
10.3 Providing Error Documentation
10.3.1 Tape Format
10.3.2 Tape Return
10.4 General Documentation Requirements
10.5 Error Diagnosis
10.5.1 Components
10.6 Error Categories
10.6.1 Documentation Errors
10.6.2 Incorrect Output
10.6.3 Oracle External Error
10.6.4 ABEND
10.6.5 Program Loop
10.6.6 Performance
10.6.7 Missing Functionality
10.7 System Dumps
10.7.1 System Dump Data Sets
10.7.2 Operator Initiated Dumps

11 Migration and Coexistence with Existing Gateways

11.1 OSDI Differences
11.1.1 Summary of Changes
11.1.1.1 OSDI Subsystems
11.1.1.2 Gateway Service
11.1.1.3 Oracle Net or Network Service
11.1.1.4 Commands and Messages
11.1.1.5 Error Diagnosis and Reporting
11.1.2 Configuring and Initializing an OSDI Subsystem
11.1.3 Configuring a Gateway Service
11.1.3.1 SID
11.1.3.2 Gateway Instance JCL
11.1.3.3 Oracle Net Access
11.1.4 File Processing Considerations
11.1.5 Operating a Gateway Service
11.1.6 Oracle Net or Network Service
11.1.6.1 Configuring Network Service
11.1.6.2 Operating Network Service
11.1.6.3 Computer Associates or Interlink SNS/TCPaccess Support
11.1.6.4 IXCF Support
11.1.6.5 Using Network Service
11.2 Migration and Upgrade
11.2.1 Release Incompatibilities
11.2.1.1 Local Database Links
11.2.2 Migration and Upgrade Steps
11.2.2.1 Step 1: Create and Configure an OSDI Subsystem
11.2.2.2 Step 2: Create an OSDI Gateway Service
11.2.2.3 Step 3: Create and Configure OSDI Net Service
11.2.2.4 Step 4: Establish Security
11.2.2.5 Step 5: Start the OSDI Services
11.2.2.6 Step 6: Test the Gateway
11.2.3 Configuring Multiple OSDI Gateway Services
11.2.4 MPM/TNS and OSDI Coexistence
11.2.4.1 TNS and OSDI NET Communication

A OSDI Subsystem Command Reference

A.1 Command Types and Processing
A.2 System Symbols in Commands
A.3 Definition Commands
A.4 Structures
A.5 Service Group Definition Commands
A.5.1 DEFINE
A.5.1.1 Define Parameters
A.5.2 ALTER
A.5.2.1 Alter Parameters
A.5.3 SHOW
A.6 Service Definition Commands
A.6.1 DEFINE
A.6.1.1 Define Parameters
A.6.2 ALTER
A.6.2.1 Alter Parameters
A.6.3 SHOW
A.6.3.1 Show Parameters
A.7 Operating Commands
A.8 Available Commands
A.9 Commands
A.9.1 START
A.9.1.1 START Parameters
A.9.2 DISPLAY
A.9.2.1 DISPLAY Parameters
A.9.3 DRAIN
A.9.3.1 DRAIN Parameters
A.9.4 RESUME
A.9.4.1 RESUME Parameters
A.9.5 STOP
A.9.5.1 STOP Parameters
A.9.6 KILL
A.9.6.1 Example:
A.10 OSDI Command Keyword Abbreviations

B National Language Support

B.1 Overview
B.2 Default Character Set Changes
B.3 Oracle Database for z/OS
B.4 Gateway Configuration
B.4.1 NLS Parameters in sidENV
B.4.2 iWay Server Configuration
B.5 Supported Character Sets
B.5.1 Supported Languages and Territories
B.6 Oracle Server and Client Configuration
B.7 Message Availability

C The Oracle SMF Interface

C.1 Activating SMF Records
C.1.1 Specifying the Record Type
C.1.1.1 Using the OSDI SMF_STAT_RECNO Parameter
C.1.2 Starting SMF Recording
C.1.3 Stopping SMF Recording
C.2 Events Generating SMF Records
C.3 Interpreting SMF Records
C.3.1 SMF Header Section
C.3.2 SMF Correlation Section
C.3.3 SMF OSDI Data Section
C.3.4 SMF Database Engine Data Section
C.3.5 Oracle Net Data Section
C.4 ORAFMTO Sample Formatting Program

D Data Dictionary Views

D.1 ALL_CATALOG
D.2 ALL_COL_COMMENTS
D.3 ALL_INDEXES
D.4 ALL_OBJECTS
D.5 ALL_TAB_COLUMNS
D.6 ALL_TAB_COMMENTS
D.7 ALL_TABLES
D.8 ALL_USERS
D.9 USER_CATALOG
D.10 USER_COL_COMMENTS
D.11 USER_INDEXES
D.12 USER_TAB_COLUMNS
D.13 USER_TAB_COMMENTS
D.14 USER_TABLES
D.15 USER_USERS

E Quick Reference to Oracle SQL Functions

F Installation Reference

F.1 Choosing Data Set Name Qualifiers

Index