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

• 1.1 Overview
• 1.2 Architecture of Oracle Access Manager for AS/400
  • 1.2.1 Components
• 1.3 Features
  • 1.3.1 Powerful Oracle SQL Language
  • 1.3.2 Leverage Existing Applications
  • 1.3.3 Universal Access
  • 1.3.4 Data Type Conversions
  • 1.3.5 Support for Distributed Applications
• 1.4 Calling Oracle Access Manager for AS/400
• 1.5 IBM Distributed Relational Databases
• 1.6 Activation Groups

2 Release Information

• 2.1 Product Set
• 2.2 Changes and Enhancements
  • 2.2.1 Release 10.2.0.1.0
    • 2.2.1.1 CURSOR WITH HOLD
  • 2.2.2 Bugs Fixed for Release 10.2.0.1.0
• 2.3 Known Problems and Restrictions
  • 2.3.1 Known Problems
    • 2.3.1.1 STRSQL on Columns of Type NUMBER
    • 2.3.1.2 General Limitations
    • 2.3.1.3 Stored Procedure Limitations
  • 2.3.2 Known Restrictions
    • 2.3.2.1 PREPARE with a COMMIT or ROLLBACK Command
    • 2.3.2.2 RDBCNNMTH Parameter set to *DUW
    • 2.3.2.3 Non-DML SQL Statements
    • 2.3.2.4 COMMIT HOLD
    • 2.3.2.5 LONG and LONG RAW Data Types
    • 2.3.2.6 Installation into an IASP

3 System Requirements

• 3.1 Hardware Requirements
  • 3.1.1 Processor
  • 3.1.2 CD-ROM Drive
  • 3.1.3 Disk Space
• 3.2 Software Requirements
  • 3.2.1 Operating System
  • 3.2.2 Communications
  • 3.2.3 Oracle Server
  • 3.2.4 PTF Requirements
  • 3.2.5 Additional Software
• 3.3 Recommended Documentation

4 Installing Access Manager

• 4.1 Checklists
  • 4.1.1 Installation Checklist
  • 4.1.2 Post-Installation Checklist
• 4.2 Installation
  • 4.2.1 Steps for Installation
  • 4.2.2 Step 1: Mount the Product CD-ROM
  • 4.2.3 Step 2: Start the Installation Process
  • 4.2.4 Step 3: Select the Installation Library Name
  • 4.2.5 Step 4: Verify Installation Parameters
  • 4.2.6 Step 5: Finish the Installation
• 4.3 Post-Installation
  • 4.3.1 Steps for Post-Installation
  • 4.3.2 Step 1: Add Oracle Access Installation Library to Library List
  • 4.3.3 Step 2: Change Password for User Profile
  • 4.3.4 Step 3: Configure Oracle Net
  • 4.3.5 Step 4: Test Connectivity to Oracle Server
  • 4.3.6 Step 5: Configure Access Manager
  • 4.3.7 Step 6: Configure Two-Phase Commit (Optional)
  • 4.3.8 Step 7: Retest Connectivity to Oracle Server (Optional)

5 Oracle Net

• 5.1 Oracle Net File Name Structure
• 5.2 Connecting to Oracle through Oracle Net
• 5.3 Defining the Oracle Server to Oracle Access Manager
  • 5.3.1 Remote Database Directory Entry
  • 5.3.2 ORA(TNSNAMES)
  • 5.3.3 Configuration Entries
• 5.4 Oracle Net for TCP/IP AS/400 Configuration
  • 5.4.1 Steps for TCP/IP AS/400 Configuration
  • 5.4.2 Step 1: Create Relational Database Directory Entry
  • 5.4.3 Step 2: Define TNSNAMES Entry

6 Configuring Access Manager

• 6.1 Access Manager Commands
• 6.2 CHGSQLDFLT
• 6.3 CHGSQLNET
• 6.4 CHGSQLDBG
• 6.5 CRTORAPKG
• 6.6 CHG2PCPRM

7 Distributed Transaction Coordination

• 7.1 Two-Phase Commit Overview
  • 7.1.1 Terminology
• 7.2 Two-Phase Commit and Oracle Access Manager for AS/400
• 7.3 Two-Phase Commit Process
  • 7.3.1 Phase 1: Prepare
  • 7.3.2 Phase 2: Commit
• 7.4 In-Doubt Transactions
  • 7.4.1 Resolving In-Doubt Transactions
• 7.5 Enabling Two-Phase Commit Processing
  • 7.5.1 Checklist for Enabling Two-Phase Commit
  • 7.5.2 Step 1: Change Access Manager Two-Phase Commit Default
  • 7.5.3 Step 2: Change the AM400_RID Options
  • 7.5.4 Step 3: Add or Remove AM400_COM Privileged User IDs
  • 7.5.5 Step 4: Start the Subsystem that Runs the AM400_RID Program
  • 7.5.6 Step 5: Start the AM400_COM Program (Optional)
• 7.6 Oracle Required Privileges
• 7.7 AM400_COM Program
  • 7.7.1 AM400_COM Commands

8 Using Access Manager

• 8.1 Connecting to the Oracle Server
  • 8.1.1 Connecting through the STRSQL (Interactive SQL) Commands
  • 8.1.2 Connecting from an AS/400 Precompiled Application
• 8.2 Connection Management
• 8.3 Describing Tables
• 8.4 Stored Procedures
  • 8.4.1 Advantages of Stored Procedures
  • 8.4.2 Stored Procedure Parameters
  • 8.4.3 Declaring Procedures
• 8.5 Conversion of Oracle Data Types to DB2/400 Data Types
• 8.6 Message and Error Code Processing

9 Error Diagnosis and Reporting

• 9.1 Trace Files from the Access Manager
• 9.2 Trace Files for Oracle Net
• 9.3 Contacting Oracle Support Services
• 9.4 Error categories
  • 9.4.1 Documentation Error
  • 9.4.2 Incorrect Output
  • 9.4.3 Oracle External Error
  • 9.4.4 Performance
  • 9.4.5 Missing Functionality
• 9.5 How to Provide Items for Problem Diagnosis

A Sample Programs

• A.1 Sample Access Manager C Program
• A.2 Sample Access Manager COBOL Program
• A.3 Sample Access Manager RPG Program

B National Language Support

• B.1 Access Manager NLS Support
• B.2 Oracle Character Set Names
• B.3 Oracle NLS_LANG Specifications

Index