Skip Headers

Table of Contents Image Oracle Access Manager Installation and User's Guide
Release 9.2.0.1.0 for IBM AS/400

Part Number A97616-01
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

About this Guide
Intended Audience
Documentation Accessibility
Product Name
Documents Referenced in this Guide
Conventions Used in this Guide
Storage Measurements

1 Introduction

Overview
Architecture for Oracle Access Manager for AS/400
Components
Features
Powerful SQL Language
Leverage Existing Applications
Universal Access
Datatype Conversions
Support for Distributed Applications
Calling Oracle Access Manager for AS/400
IBM Distributed Relational Databases
Activation Groups

2 Release Information

Product Set
Changes and Enhancements
Release 9.2.0.1.0
Release 9.2.0.1.0
Known Problems and Restrictions
Problems
Restrictions

3 System Requirements

Hardware Requirements
Processor
CD-ROM Drive
Disk Space
Software Requirements
Operating System
Communications
Oracle Server
PTF Requirements
Additional Software
Recommended Documentation

4 Installing Oracle Access Manager

Installation
Checklist for Installation
Step 1: Mount the Product CD
Step 2: Start the Installation Process
Step 3: Select the Installation Library Name
Step 4: Verify Installation Parameters
Step 5: Finish the Installation
Post-Installation
Checklist for Post-Installation
Step 1: Add Oracle Access Install Library to Library List
Step 2: Change Password for User Profile
Step 3: Configure Oracle Net
Step 4: Test Connectivity to Oracle Server
Step 5: Configure Oracle Access Manager
Step 6: Configure Two-Phase Commit (Optional)
Step 7: Retest Connectivity to Oracle Server

5 Oracle Net

Oracle Net File name Structure
Oracle Net Tracing Members
Connecting to Oracle through Oracle Net
Defining Oracle Access Manager to the Oracle Server
ORA(TNSNAMES)
Remote Database Directory Entry
TCP/IP Entries
Oracle Net for TCP/IP AS/400 Configuration
Checklist for TCP/IP AS/400 Configuration
Step 1: Define a Physical Line
Step 2: Define TNSNAMES Entry
Step 3: Create Relational Database Directory Entry

6 Configuring Oracle Access Manager

Oracle Access Manager Commands
CHGSQLDFLT
CHGSQLNET
CHGSQLDBG
CRTORAPKG
CHG2PCPRM

7 Distributed Transaction Coordination

Two-Phase Commit Overview
Terminology
Two-Phase Commit and Oracle Access Manager for AS/400
Two-Phase Commit Process
Phase 1: Prepare
Phase 2: Commit
In-Doubt Transactions
Resolving In-Doubt Transactions
Enabling Two-Phase Commit Processing
Checklist for Enabling Two-Phase Commit
Step 1: Change Oracle Access Manager Two-Phase Commit Default
Step 2: Change the AM400_RID Options
Step 3: Add or Remove AM400_COM Privileged Userids
Step 4: Start the Subsystem that Runs the AM400_RID Program
Step 5: Start the AM400_COM Program (Optional)
Oracle Required Privileges
AM400_COM Program
AM400_COM Commands

8 Using Oracle Access Manager

Connecting to the Oracle Server
Connecting through the STRSQL (Interactive SQL) Commands
Connecting from an AS/400 Precompiled Application
Connection Management
Describing Tables
Stored Procedures
Advantages of Stored Procedures
Stored Procedure Parameters
Declaring Procedures
Conversion of Oracle Datatypes to DB2/400 Datatypes
Message and Error Code Processing

A Sample Programs

Sample Oracle Access Manager C Program
Sample Oracle Access Manager COBOL Program
Sample Oracle Access Manager RPG Program

B National Language Support

Oracle Access Manager NLS Support
Oracle Character Set Names
Oracle NLS_LANG Specifications

Index


Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Index
Index