1/27

The script content on this page is for navigation purposes only and does not alter the content in any way.

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Product Name
• Command Syntax
• Accessing Documentation
• Related Documentation
• Typographic Conventions

1 Configuring and Initializing the Subsystem

• 1.1 Overview
• 1.2 Choosing a Subsystem Name and Command Prefix
• 1.3 The Subsystem Parameter File
• 1.4 OSDI Commands in the Subsystem Parameter File
• 1.5 Initializing the Subsystem
• 1.6 Examples
• 1.7 After Initializing the Subsystem

2 Introduction to OSDI Architecture

• 2.1 Overview
• 2.2 Subsystem
• 2.3 Services
• 2.4 Connections
• 2.5 Security
• 2.6 Database Service
• 2.7 Network Service

3 Configuring a Database Service and Creating a New Database

• 3.1 Overview
• 3.2 Database Service Definition
• 3.3 Database Region JCL
• 3.4 Database Region Parameters
• 3.5 Oracle Initialization Parameter Considerations
• 3.6 Pre-Allocating Database Files
• 3.7 Configuring z/OS Security
• 3.8 Configuring for Shared Servers
• 3.9 Creating the Database
  • 3.9.1 Populating the SYSTEM Tablespace
• 3.10 Creating an Oracle Database Instance

4 Defining z/OS Data Sets for the Oracle Database

• 4.1 Oracle Database Files
  • 4.1.1 Control File
  • 4.1.2 Database Files
  • 4.1.3 Redo Log Files
  • 4.1.4 Archive Log
• 4.2 Tablespaces and z/OS Space Management
  • 4.2.1 Enlarging a Tablespace
  • 4.2.2 VSAM Space Allocation Rounding
  • 4.2.3 Extending Files Accessed from Multiple Server Address Spaces
  • 4.2.4 Using the AUTOEXTEND Clause
  • 4.2.5 Bigfile Tablespaces
• 4.3 Server File Name Syntax
• 4.4 Server File Management Parameters
  • 4.4.1 File Group Names
  • 4.4.2 Special Considerations for External Data Mover
  • 4.4.3 File Management Parameters and Syntax
• 4.5 Preallocating Database Files
  • 4.5.1 Special Considerations for Ultra Large Data Files
  • 4.5.2 Special Considerations for VSAM
• 4.6 Oracle Managed Files on z/OS
• 4.7 Copying and Moving Database Files

5 Operating a Database Service

• 5.1 Starting and Stopping the Database Service
• 5.2 Oracle Database Instance Startup and Shutdown
• 5.3 Managing the Alert Log
  • 5.3.1 Closing and Releasing the Alert Log
• 5.4 Other Database Service Commands
  • 5.4.1 DISPLAY SESSION
  • 5.4.2 DISPLAY VERSION
  • 5.4.3 DUMP SESSION
  • 5.4.4 KILL SESSION
  • 5.4.5 LOGSWITCH
  • 5.4.6 REFRESH FPS

6 Database Backup and Recovery

• 6.1 Overview
• 6.2 Logging and Recovery
• 6.3 Backup and Recovery without Recovery Manager
• 6.4 Recovery Manager on z/OS
  • 6.4.1 External Data Mover
  • 6.4.2 Providing a Snapshot Control File
  • 6.4.3 Identifying Backups
  • 6.4.4 Maintaining EDM Backups
  • 6.4.5 Proxy Backup Identification
    • 6.4.5.1 Proxy Backup Restrictions
    • 6.4.5.2 Proxy Restore
  • 6.4.6 EDM Backup Allocation Parameters
  • 6.4.7 ALLOCATE CHANNEL Considerations
  • 6.4.8 BACKUP Considerations
  • 6.4.9 Example RMAN Backup Script
  • 6.4.10 EDM JCL and Parameters
  • 6.4.11 File Management Parameters Example

7 Oracle Database Administration Utilities

• 7.1 Global Environment Variable File
• 7.2 Recovery Manager (RMAN) on z/OS
• 7.3 Oracle Password Utility (ORAPWD) on z/OS
• 7.4 Offline Database Verification Utility (DBV) on z/OS

8 Oracle Net

• 8.1 Overview
• 8.2 Configuring the OSDI Listener
  • 8.2.1 Network Service Definition
  • 8.2.2 Service Name
  • 8.2.3 TYPE
  • 8.2.4 PROC
  • 8.2.5 PARM
    • 8.2.5.1 Example of OSDI Listener Definition
  • 8.2.6 OSDI Listener Region JCL
    • 8.2.6.1 Example of OSDI Listener Procedure JCL
    • 8.2.6.2 Example of NET8LOG output
  • 8.2.7 TCP/IP Network Considerations
• 8.3 Operating the OSDI Listener
• 8.4 Formatting OSDI Listener Trace Files
• 8.5 Oracle Advanced Security Option Encryption
  • 8.5.1 Setting Up ASO Encryption for Test
    • 8.5.1.1 Checklist for Setting Up ASO Encryption
    • 8.5.1.2 Step 1: Set ASO Encryption Parameters for the Server
    • 8.5.1.3 Step 2: Set ASO Encryption Parameters for the Client
  • 8.5.2 Testing ASO Encryption
    • 8.5.2.1 Checklist for Testing ASO Encryption
    • 8.5.2.2 Step 1: Connect Client and Server
    • 8.5.2.3 Step 2: Reset Configuration Parameters on Server
• 8.6 Generic Listener
  • 8.6.1 Oracle Shared Servers
  • 8.6.2 Oracle External Procedures
• 8.7 Configuring the Generic Listener for SSL
  • 8.7.1 Step 1: Edit the Server init.ora File
  • 8.7.2 Step 2: Edit the Server sqlnet.ora File
  • 8.7.3 Step 3: Edit the Server and Client tnsnames.ora File
  • 8.7.4 Step 4: Edit the listener.ora File
  • 8.7.5 Starting the Generic Listener for SSL and Shared Servers
• 8.8 Configuring the Generic Listener for External Procedures
  • 8.8.1 Step 1: Create or Modify the tnsnames.ora File
  • 8.8.2 Step 2: Create or Modify the listener.ora File
  • 8.8.3 Starting the Generic Listener for External Procedures

9 Security Considerations

• 9.1 Overview
• 9.2 Controlling Access to OSDI Subsystem Commands
• 9.3 Controlling Access to OSDI Services
• 9.4 Controlling Access to Database SYSDBA and SYSOPER Privileges
• 9.5 Database Service Actions Subject to z/OS Authorization
• 9.6 External Data Mover Actions Subject to z/OS Authorization
• 9.7 Oracle Net Actions Subject to z/OS Authorization
• 9.8 Client Authorizations
• 9.9 Authorizing Oracle Logon

10 Oracle SMF Data

• 10.1 Preparing to Record Oracle Accounting SMF Information
  • 10.1.1 Specifying the Oracle Record Type
  • 10.1.2 Starting SMF Recording of Oracle Records
  • 10.1.3 Stopping SMF Recording of Oracle Records
• 10.2 Events that Generate SMF Accounting Records
• 10.3 SMF Accounting Recording under CICS TS
• 10.4 Interpreting an Oracle Accounting SMF Record
  • 10.4.1 Contents of the SMF Header Section
  • 10.4.2 Contents of the SMF Correlation Section
  • 10.4.3 Contents of the SMF OSDI Data Section
  • 10.4.4 Contents of the SMF Database Engine Data Section
  • 10.4.5 Contents of the SMF Net Data Section
• 10.5 Oracle Net Network Information Vector Overview
  • 10.5.1 General NIV Format
  • 10.5.2 NIV List Format
  • 10.5.3 Net TCP/IP Identification NIV Format
  • 10.5.4 Contents of the SMF z/OS Accounting Data Section
• 10.6 Sample Formatting Program for SMF Accounting Records
• 10.7 Auditing Database Use
  • 10.7.1 Preparing To Record Oracle Database for z/OS Audit information
  • 10.7.2 Interpreting Oracle Database for z/OS Audit Records

11 Oracle Access Manager for CICS TS

• 11.1 Overview
• 11.2 Oracle Access Manager for CICS TS Applications
• 11.3 Oracle Access Manager for CICS TS Configuration
  • 11.3.1 Configuration Checklist
    • 11.3.1.1 Configuration Steps
    • 11.3.1.2 Post-Configuration Steps
• 11.4 Configuration Steps
  • 11.4.1 Step 1: Define and Assemble Thread Definition Table
    • 11.4.1.1 Step 1.1: Determine Requirements for Each Transaction
    • 11.4.1.2 Step 1.2: Define Thread Requirements in Thread Definition Table
  • 11.4.2 Thread Definition Table Parameters
    • 11.4.2.1 AUTH Thread Definition Table Parameter
    • 11.4.2.2 TYPE Thread Definition Table Parameter
    • 11.4.2.3 Sample Thread Definition Table
    • 11.4.2.4 Specifying User Authorization
    • 11.4.2.5 Special Considerations
    • 11.4.2.6 Step 1.3: Assemble and Link Thread Table
    • 11.4.2.7 Step 1.4: Installing a Revised Thread Table with CICS TS Executing
  • 11.4.3 Step 2: Define the MESG Library to CICS TS
  • 11.4.4 Step 3: Copy Access Manager for CICS TS Modules to CICS Libraries
  • 11.4.5 Step 4: Define CICS TS to Oracle and Grant Privileges
  • 11.4.6 Step 5: Set INITORA Parameter and Prepare Host
    • 11.4.6.1 Step 5.1: Review IDLE_TIMEOUT Parameter
    • 11.4.6.2 Step 5.2: Set REMOTE_OS_AUTHENT
    • 11.4.6.3 Step 5.3: Set OS_AUTHENT_PREFIX
  • 11.4.7 Step 6: Generate the ORACSTUB Stub for CICS TS
  • 11.4.8 Step 7: Update CICS TS Tables to Include Oracle Access Manager for CICS TS
    • 11.4.8.1 Step 7.1: Define Oracle Access Manager for CICS TS Programs to CICS
    • 11.4.8.2 Step 7.2: Define Oracle Access Manager for CICS TS Transactions to CICS
    • 11.4.8.3 Step 7.3: Install Oracle Access Manager for CICS TS Resources
  • 11.4.9 Step 8: Start Oracle Access Manager for CICS TS Adapter
  • 11.4.10 Step 9: Set Up Automatic Initialization for Oracle Access Manager for CICS TS
    • 11.4.10.1 Step 9.1: Using the CICS TS initialization parameter
    • 11.4.10.2 Step 9.2: Using the PLTPI Program
    • 11.4.10.3 Step 9.3: Generate the PLTSD Program
    • 11.4.10.4 Step 9.4: Input PLTSD and PLTPI to the CICS DFHEITAL Procedure
    • 11.4.10.5 Step 9.5: Add the User-Defined Name to the PLTPI Table
    • 11.4.10.6 Step 9.6: Add the User-Defined Name to the PLTSD Table
    • 11.4.10.7 Step 9.7: Make Generated Programs Available
• 11.5 Post-Configuration Steps
  • 11.5.1 Step 1: Modify the Sample Compilation Procedures
  • 11.5.2 Step 2: Use the SRCLIB Member OSAMPLE
• 11.6 Multiple Versions in the Same CICS TS Region
• 11.7 Recovery Considerations
  • 11.7.1 Using COMMIT (CICS)
  • 11.7.2 Using COMMIT (Oracle)
• 11.8 Two-Phase Commit Processing under CICS TS
  • 11.8.1 First Phase
  • 11.8.2 Second Phase
    • 11.8.2.1 CICS TS Warm or Emergency Restart
    • 11.8.2.2 Oracle Server Restart
    • 11.8.2.3 Manual Recovery
• 11.9 Shutting Down Oracle Access Manager for CICS TS with FORCE
• 11.10 CEDF Support
• 11.11 Oracle Access Manager for CICS TS V$SESSION Information
• 11.12 Oracle Access Manager for CICS TS Recovery and Autorestart
• 11.13 Oracle Access Manager for CICS TS Command Usage
  • 11.13.1 DISPLAY
    • 11.13.1.1 Options
    • 11.13.1.2 Syntax
    • 11.13.1.3 Purpose
    • 11.13.1.4 DISPLAY NAME Example
    • 11.13.1.5 DISPLAY TRAN NAME Example
    • 11.13.1.6 DISPLAY STATUS NAME Example
  • 11.13.2 START
    • 11.13.2.1 Syntax
    • 11.13.2.2 Purpose
    • 11.13.2.3 START Example
  • 11.13.3 STOP
    • 11.13.3.1 Syntax
    • 11.13.3.2 Purpose
    • 11.13.3.3 STOP FORCE Example
• 11.14 Oracle Access Manager for CICS TS Storage Requirements
  • 11.14.1 Base Code Storage Requirements
  • 11.14.2 Adapter Storage Requirements
  • 11.14.3 Thread Table Storage Requirements
  • 11.14.4 Connected Thread Storage Requirements

12 Oracle Access Manager for IMS TM

• 12.1 Overview
• 12.2 Oracle Access Manager for IMS TM Applications
• 12.3 Integration with IMS
  • 12.3.1 Oracle Access Manager for IMS TM Design
• 12.4 Configuration Overview
  • 12.4.1 The LIT and SSM
  • 12.4.2 Resource Translation Table
  • 12.4.3 Distributed Option Considerations
  • 12.4.4 Security Considerations
    • 12.4.4.1 Determining the Oracle User ID
    • 12.4.4.2 Session Authentication
  • 12.4.5 Error Processing
  • 12.4.6 Recovery Considerations
  • 12.4.7 Clarification of Cursor Close Behavior
  • 12.4.8 Handling Oracle Unavailable Situations
    • 12.4.8.1 Initial Connection Failure
    • 12.4.8.2 Failure After Initial Connection
  • 12.4.9 Oracle Environment Variables
• 12.5 Configuring Oracle Access Manager for IMS TM
  • 12.5.1 Oracle Access Manager for IMS TM Configuration Checklist
• 12.6 Configuration Steps
  • 12.6.1 Step 1: Define a z/OS Subsystem Identifier for the Instance
  • 12.6.2 Step 2: Choose a Value for the Instance and Generate the LIT
  • 12.6.3 Step 3: Create a User ID in the Target Oracle Database Used to Conduct Recovery
  • 12.6.4 Step 4: Determine the Oracle User ID, Authentication, and Environment Variable
  • 12.6.5 Step 5: Code and Generate the Control Region and Dependent Region RTT
    • 12.6.5.1 AMIRT
    • 12.6.5.2 AMITRANS
    • 12.6.5.3 AMISESS
    • 12.6.5.4 AMIENV
  • 12.6.6 Step 6: Add a Control Region and Dependent Region SSM Entry for the Instance
  • 12.6.7 Step 7: If a New SSM Member is Created for Any Region, Specify the Member to IMS
  • 12.6.8 Step 8: Make the Oracle Access Manager Code and Modules Available to IMS Regions
  • 12.6.9 Step 9: Shutdown and Restart IMS
• 12.7 IMS External Subsystems
• 12.8 Starting and Stopping Oracle Access Manager for IMS TM
• 12.9 Failures and Recovery
• 12.10 Oracle Access Manager for IMS TM Storage Requirements
  • 12.10.1 Base Code Storage Requirements
  • 12.10.2 Adapter Storage Requirements

13 Oracle Enterprise Manager Management Agent

• 13.1 Overview
• 13.2 Configuring Oracle Management Agent
• 13.3 Controlling Oracle Management Agent

14 Oracle Real Application Clusters

• 14.1 Overview
• 14.2 Setting Up Oracle Real Application Clusters
  • 14.2.1 Checklist for Setting Up Oracle Real Application Clusters:
    • 14.2.1.1 Step 1: Review and Set Options in the CREATE DATABASE Statement
    • 14.2.1.2 Step 2: Set Up Additional Threads of Redo Log Files and Rollback Segments
    • 14.2.1.3 Step 3: Share All Non-VSAM Data Sets
    • 14.2.1.4 Step 4: Set Up the Database Region Parameters
    • 14.2.1.5 Step 5: Set Up the Common Oracle Real Application Clusters Initialization Parameters
    • 14.2.1.6 Step 6: Set Up the Instance-specific Oracle Real Application Clusters Initialization Parameters
    • 14.2.1.7 Step 7: Operating an OSDI Database Service
• 14.3 Cross System Communication Facility (XCF)
• 14.4 Resource Name Usage on z/OS

15 Oracle Database Performance

• 15.1 Real Storage Requirements
  • 15.1.1 LPA Considerations for Database and Net Regions
  • 15.1.2 LPA Considerations for Local Oracle Users
• 15.2 Oracle Server Storage Requirements
  • 15.2.1 Database Server Address Space Configuration
    • 15.2.1.1 Determining the Number of Oracle Address Spaces
    • 15.2.1.2 Oracle SGA on z/OS
    • 15.2.1.3 User Stack Area in z/OS
  • 15.2.2 Limiting Sessions in a Server Address Space
  • 15.2.3 Limiting Memory Allocations in a Server Address Space
  • 15.2.4 Real Storage: Working Set
  • 15.2.5 Virtual Memory Allocation
• 15.3 Tuning on z/OS
  • 15.3.1 Oracle Regions
    • 15.3.1.1 Dispatching Priority
  • 15.3.2 Local Clients
    • 15.3.2.1 TSO
    • 15.3.2.2 CICS TS and IMS TM
    • 15.3.2.3 Batch
  • 15.3.3 Special Needs Functions
    • 15.3.3.1 DBA Accounts
    • 15.3.3.2 Database Imports and Exports
    • 15.3.3.3 Data Loading
    • 15.3.3.4 Index Creation
    • 15.3.3.5 Sorting Data by Key Before Loading
  • 15.3.4 Remote Clients

16 Error Diagnosis and Reporting

• 16.1 Oracle Support Services
• 16.2 Providing Error Documentation
• 16.3 General Documentation Requirements
• 16.4 Error Diagnosis
  • 16.4.1 Components
  • 16.4.2 Error Categories
    • 16.4.2.1 Documentation
    • 16.4.2.2 Incorrect Output
    • 16.4.2.3 Oracle Database External Error
    • 16.4.2.4 Abend
    • 16.4.2.5 Program Loop
    • 16.4.2.6 Performance
    • 16.4.2.7 Missing Functionality
    • 16.4.2.8 Wait State
  • 16.4.3 Diagnosing Wait State Problems
• 16.5 System Dumps
  • 16.5.1 System Dump Data Sets
  • 16.5.2 Operator Initiated Dumps
  • 16.5.3 SLIP
  • 16.5.4 TSO System Dumps
• 16.6 GTF

17 Migration and Upgrade Considerations

• 17.1 Requirements
• 17.2 Upgrade Eligibility
• 17.3 Preparing to Upgrade
• 17.4 Upgrading the Database
  • 17.4.1 Install the Database
  • 17.4.2 Analyze the Database
  • 17.4.3 Back Up the Database
    • 17.4.3.1 Shut Down the Prior Oracle Instance Cleanly
    • 17.4.3.2 Perform the Backup
  • 17.4.4 Upgrade the Database
    • 17.4.4.1 Step 1: Prepare to Start the New Oracle Database Release
    • 17.4.4.2 Step 2: Start the New Oracle Database Release
    • 17.4.4.3 Step 3: Create a SYSAUX Tablespace
    • 17.4.4.4 Step 4: Run Upgrade Scripts
    • 17.4.4.5 Step 5: Run the utlu102s.sql Script
    • 17.4.4.6 Step 6: Shut Down and Restart the Instance
    • 17.4.4.7 Step 7: Recompile Database Stored Procedures
  • 17.4.5 Fallback and Recovery Considerations
  • 17.4.6 After Upgrading the Database
• 17.5 OSDI Changes in Oracle9i Release 2
  • 17.5.1 Network Client Operations
  • 17.5.2 Clients Use Language Environment
  • 17.5.3 Configuring Network Service
  • 17.5.4 Configuring Oracle Access Managers
    • 17.5.4.1 Oracle Access Manager for CICS TS

A OSDI Subsystem Command Reference

• A.1 OSDI Command Reference
• A.2 Command Types and Processing
• A.3 System Symbols in Commands
• A.4 Definition Commands
• A.5 Structures
• A.6 Service Group Definition Commands
• A.7 Service Definition Commands
• A.8 Operating Commands
• A.9 Available Commands
• A.10 Commands
• A.11 OSDI Command Keyword Abbreviations

B Operating System Dependent Variables

• B.1 Initialization Parameters with z/OS-Specific Defaults or Limits
• B.2 Database Limits
• B.3 SQL Language Parameters
  • B.3.1 CREATE CONTROLFILE
  • B.3.2 CREATE DATABASE
• B.4 Storage Parameters

C Oracle Database for z/OS System Symbols

• C.1 System Symbols

D National Language Support

• D.1 Overview
• D.2 Translated Messages
• D.3 Overview of Character Set Support
• D.4 Server-Side NLS
• D.5 Client-Side NLS
  • D.5.1 Supported z/OS Client Character Sets
• D.6 NLS Calendar Utility (LXEGEN)

Index