Contents

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 Pre-allocating Database Files
  • 4.5.1 Special Considerations for Ultra Large Datafiles
  • 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 Tsnames.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 Tsnames.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 the Management Agent
• 13.3 Controlling the Management Agent

14 Oracle Real Application Clusters

• 14.1 Overview
• 14.2 Setting Up 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 Supported Languages
• 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