Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

Storage Measurements

1 Introduction

1.2 Architecture of Oracle Access Manager for AS/400

1.2.1 Components

1.3.1 Powerful Oracle SQL Language

1.3.2 Leverage Existing Applications

1.3.3 Universal Access

1.3.4 Datatype 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.1.0.2.0

2.2.1.1 LONG and LONG RAW Datatypes

2.2.1.2 Encryption

2.2.1.3 Big Integers

2.2.1.4 Oracle Timestamp

2.2.2 Bugs Fixed for Release 10.1.0.2.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 Datatypes

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.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.1.1 Oracle Net Tracing Members

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

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 Userids

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 Datatypes to DB2/400 Datatypes

8.6 Message and Error Code Processing

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