Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Product Name
• Platform Name
• Related Documents
• Conventions
• Storage Measurements

1 Introduction

• Overview
• Architecture of Oracle Access Manager for AS/400
  • Components
• Features
  • Powerful Oracle SQL Language
  • Leverage Existing Applications
  • Universal Access
  • Data Type 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 10.2.0.1.0
    • CURSOR WITH HOLD
  • Bugs Fixed for Release 10.2.0.1.0
• Known Problems and Restrictions
  • Known Problems
    • STRSQL on Columns of Type NUMBER
    • General Limitations
    • Stored Procedure Limitations
  • Known Restrictions
    • PREPARE with a COMMIT or ROLLBACK Command
    • RDBCNNMTH Parameter set to *DUW
    • Non-DML SQL Statements
    • COMMIT HOLD
    • LONG and LONG RAW Data Types
    • Installation into an IASP

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 Access Manager

• Checklists
  • Installation Checklist
  • Post-Installation Checklist
• Installation
  • Steps for Installation
  • Step 1: Mount the Product CD-ROM
  • 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
  • Steps for Post-Installation
  • Step 1: Add Oracle Access Installation 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 Access Manager
  • Step 6: Configure Two-Phase Commit (Optional)
  • Step 7: Retest Connectivity to Oracle Server (Optional)

5 Oracle Net

• Oracle Net File Name Structure
• Connecting to Oracle through Oracle Net
• Defining the Oracle Server to Oracle Access Manager
  • Remote Database Directory Entry
  • ORA(TNSNAMES)
  • Configuration Entries
• Oracle Net for TCP/IP AS/400 Configuration
  • Steps for TCP/IP AS/400 Configuration
  • Step 1: Create Relational Database Directory Entry
  • Step 2: Define TNSNAMES Entry

6 Configuring Access Manager

• 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 Access Manager Two-Phase Commit Default
  • Step 2: Change the AM400_RID Options
  • Step 3: Add or Remove AM400_COM Privileged User IDs
  • 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 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 Data Types to DB2/400 Data Types
• Message and Error Code Processing

9 Error Diagnosis and Reporting

• Trace Files from the Access Manager
• Trace Files for Oracle Net
• Contacting Oracle Support Services
• Error categories
  • Documentation Error
  • Incorrect Output
  • Oracle External Error
  • Performance
  • Missing Functionality
• How to Provide Items for Problem Diagnosis

A Sample Programs

• Sample Access Manager C Program
• Sample Access Manager COBOL Program
• Sample Access Manager RPG Program

B Globalization Support

• Access Manager Globalization Support
• Oracle Character Set Names
• Oracle NLS_LANG Specifications

Index