Skip Headers

Table of Contents Image Oracle Transparent Gateway for iWay Installation and User's Guide
Release 9.2.0.4 for IBM z/OS (OS/390)

Part Number B10580-01
Go To Index
Index

Go to next page

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

Version 9 Gateways
Advantages of the Gateway
SQL
Stored Procedures
Applications
Two-Phase Commit and Multisite Transactions
Site Autonomy
Migration and Coexistence
Security
Protection of Current Investment
Gateway Architecture
Ease of Implementation
Components and Requirements
How the Gateway Works
SQL Differences

2 Release Information

Product Set
Changes and Enhancements in Release 9.2.0.4
Known Problems, Restrictions, and Workarounds
Known Problems
Known Restrictions

3 System Requirements

Resource Requirements
CPU
Disk Space
Virtual Memory
Software Requirements
Operating System
UNIX System Services (USS)
IBM Maintenance
Additional Software Requirements
Oracle Database Server Requirements
Oracle Net Requirements
Distribution Kit

4 Installation

Installation Checklists
Setup and Initialization Checklist
Installation Checklist
Post-Installation Checklist
Setup and Initialization Steps
Step 1: Load the Oracle Installation JCL
Step 2: Create the ISPF Libraries
Step 3: Invoke the Product Installation and Customization Process
Step 4: Select Product Set from the Oracle Product Install Menu (Panel OR@PRIM)
Step 5: Select Options from the Oracle Primary Option Menu (Panel OR@INST)
Product Installation
Step 1: Modify Tape Unit and Library Index (Panel ORINIP00)
Step 2: Select Oracle Products for Installation (Panel ORPRODS)
Step 3: Select Language Message Modules (Panel ORLANG)
Step 4: INSTLIB/ISPSLIB File Tailoring Information (Panel ORINIP15)
Step 5: Define JOB Cards for Install Jobs (Panel ORINIP20)
Step 6: Define PROCs, CLISTs, Linklist, and Temporary Space (Panel ORINIP25)
Step 7: Review/Modify Space Specifications for Major Libraries (Panel ORDSN)
Step 8: Specify VOLSER for Other Libraries (Panel ORDSNO)
Step 9: Product Installation Definition Complete (Panel ORINIP60)
Step 10: Generate the Installation Job
Step 11: Run the Installation Job (ORIJA01)
Step 12: Run the Generated Installation Jobs
Post-Installation Steps
Step 1: Define OSDI Subsystem for Oracle Gateways
Step 2: Associate Userids with Services
Step 3: Add Program Properties
Step 4: Authorize the Gateway Load Library
Step 5: Re-IPL OS/390 or Use Dynamic OS/390 Commands

5 Configuring the Gateway

Introduction
Checklists
Pre Configuration Checklist
Configuration Checklist
Post Configuration Checklist
Pre Configuration
iWay Server Installation
iWay Server Configuration
Configuration Steps
Step 1: Configuring a Gateway Service Using ISPF Panels
Step 2: Run the sidJB00 Configuration Job
Step 3: Edit the PARMLIB Members
Step 4: Gateway Service Definition
Step 5: Setup Gateway JCL
Step 6: Start the Gateway
Post Configuration Steps
Step 1: Move Reentrant Modules to OS/390 Link Pack Areas
Step 2: Examine Oracle Dump Data Sets and Modify as Necessary
Step 3: Examine Oracle Trace Data Sets and Modify as Necessary

6 Oracle Net

Oracle Net Overview
OSDI Listener Architecture
OSDI Listener Filenames
Configuring the OSDI Listener
Network Service Definition
Service Name
TYPE
PROC
PARM
OSDI Listener Region JCL
TCP/IP Network Considerations
Client-Server Access Using the OSDI Listener
Operating the OSDI Listener
Formatting OSDI Listener Trace Files
Oracle Advanced Security Option Encryption
Setting Up ASO Encryption for Test
Testing ASO Encryption

7 Administering the Gateway

Operation of the Gateway Subsystem with OSDI
Controlling Access to OSDI Subsystem Commands
Controlling Access to OSDI Services
Gateway Security
iWay Server Security Considerations

8 Using the Gateway

Introduction
Database Link Behavior
Creating Database Links
Creating Database Links Using Oracle Net
Guidelines for Database Links
Accessing Data Through a Database Link
Dropping a Database Link
Examining Available Database Links
Limiting the Number of Active Database Links
Using the Synonym Feature
Performing Distributed Queries
Example of a Distributed Query
Copying Data
Streams Replication

9 Developing Applications

Gateway Appearance to Application Programs
Array Processing
Fetch Reblocking
SQL Functions
Data Type Conversion
Performing Date and Time Operations
Date Considerations in SQL Coding
Dates in the 21st Century
Oracle TO_DATE Function
Date Arithmetic
Oracle ROWID Column
Oracle Server and iWay Server Differences
Handling Binary Data
USER and UID SQL Functions
Oracle Bind Variables
Using Oracle Stored Procedures with the Gateway
Using Focus Stored Procedures with the Gateway
Running Oracle Applications with Focus Stored Procedures
Defining Stored Procedures in iWay Server SYSRPC Dynamic Catalog Table

10 Error Messages, Diagnosis, and Reporting

Message and Error Code Processing
Interpreting Message Formats
Messages Generated by Oracle Transparent Gateway for iWay
Diagnosing Errors Detected by the Oracle Server
Oracle Support Services
Providing Error Documentation
Tape Format
Tape Return
General Documentation Requirements
Error Diagnosis
Components
Error Categories
Documentation Errors
Incorrect Output
Oracle External Error
ABEND
Program Loop
Performance
Missing Functionality
System Dumps
System Dump Data Sets
Operator Initiated Dumps

11 Migration and Coexistence with Existing Gateways

OSDI Differences
Summary of Changes
Configuring and Initializing an OSDI Subsystem
Configuring a Gateway Service
File Processing Considerations
Operating a Gateway Service
Oracle Net or Network Service
Migration and Upgrade
Release Incompatibilities
Migration and Upgrade Steps
Configuring Multiple OSDI Gateway Services
MPM/TNS and OSDI Coexistence

A Data Set Names and Space Allocations

Using the NEWDSRPT CLIST
Oracle Default Data Sets
Oracle Data Sets

B OSDI Subsystem Command Reference

Command Types and Processing
System Symbols in Commands
Definition Commands
Structures
Service Group Definition Commands
DEFINE
ALTER
SHOW
Service Definition Commands
DEFINE
ALTER
SHOW
Operating Commands
Available Commands
Commands
START
DISPLAY
DRAIN
RESUME
STOP
KILL
OSDI Command Keyword Abbreviations

C National Language Support

Overview
Default Character Set Changes
Oracle for OS/390
Gateway Configuration
NLS Parameters in sidENV
iWay Server Configuration
Supported Character Sets
Supported Languages and Territories
Oracle Server and Client Configuration
Message Availability

D The Oracle SMF Interface

Activating SMF Records
Specifying the Record Type
Starting SMF Recording
Stopping SMF Recording
Events Generating SMF Records
Interpreting SMF Records
SMF Header Section
SMF Correlation Section
SMF OSDI Data Section
SMF Database Engine Data Section
Oracle Net Data Section
ORAFMTO Sample Formatting Program

E Data Dictionary Views

ALL_CATALOG
ALL_COL_COMMENTS
ALL_INDEXES
ALL_OBJECTS
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TABLES
ALL_USERS
USER_CATALOG
USER_COL_COMMENTS
USER_INDEXES
USER_TAB_COLUMNS
USER_TAB_COMMENTS
USER_TABLES
USER_USERS

F Quick Reference to Oracle SQL Functions

G Installation Reference

Choosing Data Set Name Qualifiers
Data Set Name Qualifier Rules
OR@INST Panel Options

Index


Go to next page
Oracle
Copyright © 1995, 2003 Oracle Corporation.

All Rights Reserved.
Go To Index
Index