Oracle9i Enterprise Edition System Administration Guide
Release 2 ( for OS/390

Part Number A97313-01
Go To Index

Go to next page


Title and Copyright Information

Send Us Your Comments


1 Introduction to OSDI Architecture

Benefits of OSDI
OSDI Architecture

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
Database Logical Blocksize
Pre-Allocating Database Files
Configuring OS/390 Security
Configuring for Shared Servers
Creating the Database
Configuring a Database Service Using ISPF Panels

4 Defining OS/390 Data Sets for the Oracle Database

Oracle Database Files
Tablespaces and OS/390 Space Management
Server File Name Syntax
Server File Management Parameters
Pre-allocating Database Files
Oracle Managed Files on OS/390

5 Operating a Database Service

Starting and Stopping the Database Service
Oracle Database Instance Startup and Shutdown
Other Database Service Commands

6 Database Backup and Recovery

Logging and Recovery
Backup and Recovery without Recovery Manager
Recovery Manager on OS/390
Tablespace Point-in-Time Recovery
Oracle9i Data Guard

7 Oracle9i Utilities

General Considerations
SQL*Plus on OS/390
Recovery Manager (RMAN) on OS/390
Oracle Password Utility (ORAPWD) on OS/390
Offline Database Verification Utility (DBV) on OS/390

8 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 OS/390 Authorization
External Data Mover Actions Subject to OS/390 Authorization
Oracle Net Actions Subject to OS/390 Authorization
Authorizing Oracle Logon

9 Oracle SMF Data

Preparing to Record SMF Information
Events that Generate SMF Records
SMF Recording under CICS
Interpreting an Oracle SMF Record
Oracle Net Network Information Vector Overview
Sample Formatting Program for SMF Records
Auditing Database Use

10 Oracle Net

OSDI Listener Architecture
OSDI Listener Filenames
Configuring the OSDI Listener
Operating the OSDI Listener
Formatting OSDI Listener Trace Files
Oracle Advanced Security Option Encryption
Generic Listener Architecture
Generic Listener Configuration Steps

11 Oracle Access Manager for CICS

Oracle Access Manager for CICS Applications
Oracle Access Manager for CICS Configuration
Configuration Steps
Post-Configuration Steps
Multiple Versions in the Same CICS Region
Recovery Considerations
Two-Phase Commit Processing under CICS
Shutting Down Oracle Access Manager for CICS with FORCE
CEDF Support
Oracle Access Manager for CICS Command Usage

12 Oracle Access Manager for IMS TM

Oracle Access Manager for IMS TM Applications
Integration with IMS
Configuration Overview
Configuring Oracle Access Manager for IMS TM
Configuration Steps
IMS External Subsystems
Starting and Stopping Oracle Access Manager for IMS TM
Failures and Recovery

13 Oracle Enterprise Manager Intelligent Agent and Data Gatherer

Running the Customization Script
Updating the Parameter Files

14 Oracle9i Real Application Clusters

Setting Up Real Application Clusters
Cross System Communication Facility (XCF)
OS/390 Resource Name Usage

15 Oracle Programmer

Oracle Programmer INCLUDE Files
ASID and Task Considerations
Program Status Word Protect Key
PSW State
Multiple Executions under a TCB
Cross Memory Mode
APF Authorization

16 Oracle9i Performance

CPU Usage
Memory Requirements
Oracle Server Storage Requirements
Oracle Tuning
Minimizing I/O Bottlenecks
OS/390 Tuning
PL/SQL and Java
Oracle Parallel Execution
Applications Performance Diagnosis
Oracle Access Manager for CICS
Oracle Access Manager for IMS

17 Error Diagnosis and Reporting

Oracle Support Services
Providing Error Documentation
General Documentation Requirements
Error Diagnosis
System Dumps

18 Migration and Upgrade Considerations

Differences Between MPM/TNS and OSDI
OSDI Changes in Oracle9i, Release 2
Moving from MPM/TNS to OSDI
Coexistence and Compatibility
Oracle for OS/390 Migration and Upgrade
CFUTIL (Convert File Utility) Reference

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 OS/390-Specific Defaults or Limits
Database Limits
SQL Language Parameters
Storage Parameters

C Oracle9i for OS/390 System Symbols

System Symbols

D National Language Support

Supported Languages
Overview of Character Set Support
Server-Side NLS
Default Character Set Changed
Client-Side NLS
Message Availability
Customized Character Sets (LXINST)
NLS Calendar Utility (LXEGEN)


Go to next page
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Index