Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

Typographic Conventions

Storage Measurements

Documents Referenced in this Guide

1 Introduction to OSDI Architecture

Database Service

Network Service

2 Configuring and Initializing the Subsystem

Choosing a Subsystem Name and Command Prefix

The Subsystem Parameter File

OSDI Commands in the Subsystem Parameter File

Initializing the Subsystem

After Initializing the Subsystem

3 Configuring a Database Service and Creating a New Database

Database Service Definition

Database Region JCL

Database Region Parameters

Oracle Initialization Parameter Considerations

Pre-Allocating Database Files

Configuring z/OS Security

Configuring for Shared Servers

Creating the Database

Populating the SYSTEM Tablespace

Creating an Oracle Database Instance

4 Defining z/OS Data Sets for the Oracle Database

Oracle Database Files

Tablespaces and z/OS Space Management

Enlarging a Tablespace

VSAM Space Allocation Rounding

Extending Files Accessed from Multiple Server Address Spaces

Using the AUTOEXTEND Clause

Bigfile Tablespaces

Server File Name Syntax

Server File Management Parameters

File Group Names

Special Considerations for External Data Mover

File Management Parameters and Syntax

Pre-allocating Database Files

Special Considerations for Ultra Large Datafiles

Special Considerations for VSAM

Oracle Managed Files on z/OS

Copying and Moving Database Files

5 Operating a Database Service

Starting and Stopping the Database Service

Oracle Database Instance Startup and Shutdown

Managing the Alert Log

Closing and Releasing the Alert Log

Other Database Service Commands

DISPLAY SESSION

DISPLAY VERSION

6 Database Backup and Recovery

Logging and Recovery

Backup and Recovery without Recovery Manager

Recovery Manager on z/OS

External Data Mover

Providing a Snapshot Control File

Identifying Backups

Maintaining EDM Backups

Proxy Backup Identification

Proxy Backup Restrictions

EDM Backup Allocation Parameters

ALLOCATE CHANNEL Considerations

BACKUP Considerations

Example RMAN Backup Script

EDM JCL and Parameters

File Management Parameters Example

7 Oracle Database Administration Utilities

Global Environment Variable File

Recovery Manager (RMAN) on z/OS

Oracle Password Utility (ORAPWD) on z/OS

Offline Database Verification Utility (DBV) on z/OS

8 Oracle Net

Configuring the OSDI Listener

Network Service Definition

Example of OSDI Listener Definition

OSDI Listener Region JCL

Example of OSDI Listener Procedure JCL

Example of NET8LOG output

TCP/IP Network Considerations

Operating the OSDI Listener

Formatting OSDI Listener Trace Files

Oracle Advanced Security Option Encryption

Setting Up ASO Encryption for Test

Checklist for Setting Up ASO Encryption

Step 1: Set ASO Encryption Parameters for the Server

Step 2: Set ASO Encryption Parameters for the Client

Testing ASO Encryption

Checklist for Testing ASO Encryption

Step 1: Connect Client and Server

Step 2: Reset Configuration Parameters on Server

Generic Listener

Oracle Shared Servers

Oracle External Procedures

Configuring the Generic Listener for SSL

Step 1: Edit the Server Init.ora File

Step 2: Edit the Server Sqlnet.ora File

Step 3: Edit the Server and Client Tsnames.ora File

Step 4: Edit the Listener.ora File

Starting the Generic Listener for SSL and Shared Servers

Configuring the Generic Listener for External Procedures

Step 1: Create or Modify the Tsnames.ora File

Step 2: Create or Modify the Listener.ora File

Starting the Generic Listener for External Procedures

9 Security Considerations

Controlling Access to OSDI Subsystem Commands

Controlling Access to OSDI Services

Controlling Access to Database SYSDBA and SYSOPER Privileges

Database Service Actions Subject to z/OS Authorization

External Data Mover Actions Subject to z/OS Authorization

Oracle Net Actions Subject to z/OS Authorization

Client Authorizations

Authorizing Oracle Logon

10 Oracle SMF Data

Preparing to Record Oracle Accounting SMF Information

Specifying the Oracle Record Type

Starting SMF Recording of Oracle Records

Stopping SMF Recording of Oracle Records

Events that Generate SMF Accounting Records

SMF Accounting Recording under CICS TS

Interpreting an Oracle Accounting SMF Record

Contents of the SMF Header Section

Contents of the SMF Correlation Section

Contents of the SMF OSDI Data Section

Contents of the SMF Database Engine Data Section

Contents of the SMF Net Data Section

Oracle Net Network Information Vector Overview

General NIV Format

NIV List Format

Net TCP/IP Identification NIV Format

Contents of the SMF z/OS Accounting Data Section

Sample Formatting Program for SMF Accounting Records

Auditing Database Use

Preparing To Record Oracle Database for z/OS Audit information

Interpreting Oracle Database for z/OS Audit Records

11 Oracle Access Manager for CICS TS

Oracle Access Manager for CICS TS Applications

Oracle Access Manager for CICS TS Configuration

Configuration Checklist

Configuration Steps

Post-Configuration Steps

Configuration Steps

Step 1: Define and Assemble Thread Definition Table

Step 1.1: Determine Requirements for Each Transaction

Step 1.2: Define Thread Requirements in Thread Definition Table

Thread Definition Table Parameters

AUTH Thread Definition Table Parameter

TYPE Thread Definition Table Parameter

Sample Thread Definition Table

Specifying User Authorization

Special Considerations

Step 1.3: Assemble and Link Thread Table

Step 1.4: Installing a Revised Thread Table with CICS TS Executing

Step 2: Define the MESG Library to CICS TS

Step 3: Copy Access Manager for CICS TS Modules to CICS Libraries

Step 4: Define CICS TS to Oracle and Grant Privileges

Step 5: Set INITORA Parameter and Prepare Host

Step 5.1: Review IDLE_TIMEOUT Parameter

Step 5.2: Set REMOTE_OS_AUTHENT

Step 5.3: Set OS_AUTHENT_PREFIX

Step 6: Generate the ORACSTUB Stub for CICS TS

Step 7: Update CICS TS Tables to Include Oracle Access Manager for CICS TS

Step 7.1: Define Oracle Access Manager for CICS TS Programs to CICS

Step 7.2: Define Oracle Access Manager for CICS TS Transactions to CICS

Step 7.3: Install Oracle Access Manager for CICS TS Resources

Step 8: Start Oracle Access Manager for CICS TS Adapter

Step 9: Set Up Automatic Initialization for Oracle Access Manager for CICS TS

Step 9.1: Generate the PLTPI Program

Step 9.2: Generate the PLTSD Program

Step 9.3: Input PLTSD and PLTPI to the CICS DFHEITAL Procedure

Step 9.4: Add the User-Defined Name to the PLTPI Table

Step 9.5: Add the User-Defined Name to the PLTSD Table

Step 9.6: Make Generated Programs Available

Post-Configuration Steps

Step 1: Modify the Sample Compilation Procedures

Step 2: Use the SRCLIB Member OSAMPLE

Multiple Versions in the Same CICS TS Region

Recovery Considerations

Using COMMIT (CICS)

Using COMMIT (Oracle)

Two-Phase Commit Processing under CICS TS

CICS TS Warm or Emergency Restart

Oracle Server Restart

Manual Recovery

Shutting Down Oracle Access Manager for CICS TS with FORCE

Oracle Access Manager for CICS TS V$SESSION Information

Oracle Access Manager for CICS TS Recovery and Autorestart

Oracle Access Manager for CICS TS Command Usage

DISPLAY NAME Example

DISPLAY TRAN NAME Example

DISPLAY STATUS NAME Example

STOP FORCE Example

Oracle Access Manager for CICS TS Storage Requirements

Base Code Storage Requirements

Adapter Storage Requirements

Thread Table Storage Requirements

Connected Thread Storage Requirements

12 Oracle Access Manager for IMS TM

Oracle Access Manager for IMS TM Applications

Integration with IMS

Oracle Access Manager for IMS TM Design

Configuration Overview

The LIT and SSM

Resource Translation Table

Distributed Option Considerations

Security Considerations

Determining the Oracle User id

Session Authentication

Error Processing

Recovery Considerations

Clarification of Cursor Close Behavior

Handling Oracle Unavailable Situations

Initial Connection Failure

Failure After Initial Connection

Oracle Environment Variables

Configuring Oracle Access Manager for IMS TM

Oracle Access Manager for IMS TM Configuration Checklist

Configuration Steps

Step 1: Define a z/OS Subsystem Identifier for the Instance

Step 2: Choose a Value for the Instance and Generate the LIT

Step 3: Create a User Id in the Target Oracle Database Used to Conduct Recovery

Step 4: Determine the Oracle User Id, Authentication, and Environment Variable

Step 5: Code and Generate the Control Region and Dependent Region RTT

Step 6: Add a Control Region and Dependent Region SSM Entry for the Instance

Step 7: If a New SSM Member is Created for Any Region, Specify the Member to IMS

Step 8: Make the Oracle Access Manager Code and Modules Available to IMS Regions

Step 9: Shutdown and Restart IMS

IMS External Subsystems

Starting and Stopping Oracle Access Manager for IMS TM

Failures and Recovery

Oracle Access Manager for IMS TM Storage Requirements

Base Code Storage Requirements

Adapter Storage Requirements

13 Oracle Enterprise Manager Management Agent

Configuring the Management Agent

Controlling the Management Agent

14 Oracle Real Application Clusters

Setting Up Real Application Clusters

Checklist for Setting Up Oracle Real Application Clusters:

Step 1: Review and Set Options in the CREATE DATABASE Statement

Step 2: Set Up Additional Threads of Redo Log Files and Rollback Segments

Step 3: Share All Non-VSAM Data Sets

Step 4: Set Up the Database Region Parameters

Step 5: Set Up the Common Oracle Real Application Clusters Initialization Parameters

Step 6: Set Up the Instance-specific Oracle Real Application Clusters Initialization Parameters

Step 7: Operating an OSDI Database Service

Cross System Communication Facility (XCF)

Resource Name Usage on z/OS

15 Oracle Database Performance

Real Storage Requirements

LPA Considerations for Database and Net Regions

LPA Considerations for Local Oracle Users

Oracle Server Storage Requirements

Database Server Address Space Configuration

Determining the Number of Oracle Address Spaces

Oracle SGA on z/OS

User Stack Area in z/OS

Limiting Sessions in a Server Address Space

Limiting Memory Allocations in a Server Address Space

Real Storage: Working Set

Virtual Memory Allocation

Dispatching Priority

CICS TS and IMS TM

Special Needs Functions

Database Imports and Exports

Sorting Data by Key Before Loading

16 Error Diagnosis and Reporting

Oracle Support Services

Providing Error Documentation

General Documentation Requirements

Error Diagnosis

Error Categories

Incorrect Output

Oracle Database External Error

Missing Functionality

Diagnosing Wait State Problems

System Dump Data Sets

Operator Initiated Dumps

TSO System Dumps

17 Migration and Upgrade Considerations

Upgrade Eligibility

Preparing to Upgrade

Upgrading the Database

Install the Database

Analyze the Database

Back Up the Database

Shut Down the Prior Oracle Instance Cleanly

Perform the Backup

Upgrade the Database

Step 1: Prepare to Start the New Oracle Database Release

Step 2: Start the New Oracle Database Release

Step 3: Create a SYSAUX Tablespace

Step 4: Run Upgrade Scripts

Step 5: Run the utlu101s.sql Script

Step 6: Shut Down and Restart the Instance

Step 7: Recompile Database Stored Procedures

Fallback and Recovery Considerations

After Upgrading the Database

OSDI Changes in Oracle9i, Release 2

Network Client Operations

Clients Use Language Environment

Configuring Network Service

Configuring Oracle Access Managers

Oracle Access Manager for CICS TS

A OSDI Subsystem Command Reference

OSDI Command Reference

Command Types and Processing

System Symbols in Commands

Definition Commands

Service Group Definition Commands

Service Definition Commands

Operating Commands

Available Commands

OSDI Command Keyword Abbreviations

B Operating System Dependent Variables

Initialization Parameters with z/OS-Specific Defaults or Limits

Database Limits

SQL Language Parameters

CREATE CONTROLFILE

CREATE DATABASE

Storage Parameters

C Oracle Database for z/OS System Symbols

D National Language Support

Supported Languages

Overview of Character Set Support

Server-Side NLS

Client-Side NLS

Supported z/OS Client Character Sets

NLS Calendar Utility (LXEGEN)

Index