DB2 Server for VM: System Administration

Table of Contents

About This Manual

  • Organization of This Manual
  • How to Send Your Comments
  • Syntax Notation Conventions
  • SQL Reserved Words

    • Summary of Changes

  • Summary of Changes for DB2 Version 7 Release 1
  • Enhancements, New Functions, and New Capabilities
  • Reliability, Availability, and Serviceability Improvements
  • Library Enhancements

    • Chapter 1. Planning for Installation

  • Operating System Overview
  • Virtual Machine Overview
  • Components of the Relational Database Management System
  • Software Requirements
  • Virtual Storage Requirements
  • Database Machine Size
  • Service Machine Size
  • User Machine Size
  • Hardware Requirements
  • Real Storage Requirements
  • DASD Space Requirements
  • Tape Requirements
  • Display Terminal Requirements
  • Considerations When Defining a Database Machine and Generating a Database
  • Considerations When Adding Directory Control Statements
  • Considerations When Loading IBM-Supplied Files
  • Considerations When Generating a Database
  • Considerations When Defining a Service Machine
  • Updating the Service Machine VM Directory
  • Considerations When Loading IBM-supplied Files
  • Defining User Machines
  • Defining Saved Segments
  • Setting Up the CMS Communications Directory
  • Updating the SNA NETID File

    • Chapter 2. Planning for Database Generation

  • Database Generation Parameters
  • Defining Database Directory Size
  • Defining the Database Log
  • Establishing Database Capacity Parameters
  • Establishing Initial Dbspace Requirements
  • Determining Initial Dbextent Requirements
  • Choosing an Application Server Name and VM Resource Identifier
  • Choosing the Application Server Default CHARNAME and CCSID
  • Choosing the Application Server Default Character Subtype
  • Choosing the Default CHARNAME and CCSID for Application Requesters
  • Preparing for Database Regeneration
  • Database Generation Worksheet

    • Chapter 3. Planning for Database Migration

  • Migration Considerations
  • Increasing the HELPTEXT Dbspace
  • Migrating from Version 3 Release 1
  • Considerations for Invalid Indexes
  • Conversion of Packages
  • Migrating from Version 3 Release 2
  • Choosing an Application Server Default CHARNAME
  • Choosing the Default CHARNAME for All Application Requesters
  • Considerations for Mixed Primary Keys with Field Procedures
  • Migrating from Version 3 Release 3
  • Considerations for EXPLAIN Tables
  • Considerations for VSE Guest Sharing
  • Considerations for the VM Data Spaces Support (VMDSS)
  • Migrating from Version 3 Release 4
  • Considerations for Assembler Even Precision Packed Decimal
  • Considerations for SQLSTATE Changes for SQL92 Support
  • Migrating from Version 3 Release 5
  • Considerations for Uncommitted Read
  • Considerations for VMSES/E
  • Considerations for Support of ESA-mode Processors Only
  • Considerations for the Renaming of the Product
  • Considerations for the Removal of the User Facility Subset
  • Migrating from Version 5 Release 1
  • Considerations for RDS Above 16M
  • Considerations for TCP/IP
  • Migrating from Version 6 Release 1
  • Release Coexistence Considerations
  • Migrating from a VSE to a VM Operating System
  • Moving a Database from a VSE to a VM Operating System
  • Choosing a VM Resource Identifier
  • Converting Data in the Database
  • Converting Packages
  • Converting Programs
  • VSE Databases Coexisting under VM
  • Migrating from a VM/XA to a VM/ESA Environment
  • Delaying the Directory and Database Name Changes
  • Setting up the Database Machine Directory Entry
  • Example of a Database Machine Directory with Multiple Databases
  • Setting Up the User Machine Directory Entry
  • Database Naming Considerations
  • Migrating from a VM/SP to a VM/ESA Operating System
  • Installing Another IBM VM System on Your Processor
  • Moving a Database
  • Moving a VM Application Server from One User ID to Another
  • Converting a Service Machine to a Database Machine
  • Changing the Server Name and Resource Identifier

    • Chapter 4. Planning for Operation of the Database Manager

  • Starting the Application Server
  • The Database Operator
  • Multiple User Mode Initialization Parameters
  • Single User Mode Initialization Parameters
  • Tape Support
  • General File Support
  • Starting the Application Server in Multiple User Mode
  • Starting the Application Server in Single User Mode
  • Overriding Initialization Parameters
  • Creating a Parameter File
  • Running the Database Manager
  • Operating Modes
  • Disconnecting the Database Machine
  • Stopping the Application Server
  • Taking an Archive
  • Verifying the Directory
  • Online Support Considerations for VSE Guest Sharing
  • A Note about Minidisk Passwords
  • Inter-Machine Communications

    • Chapter 5. Operating the Online Support for VSE Guest Sharing

  • Operating VSE Guest Sharing
  • Operator Responsibilities
  • Starting the Application Server
  • Starting the Online Resource Adapter -- The CIRB Transaction
  • Adding Connections -- The CIRA Transaction
  • Automatic Restart Resynchronization
  • Changing the Default Server -- The CIRC Transaction
  • Removing Connections -- The CIRR Transaction
  • Displaying Information -- The CIRD Transaction
  • Stopping the Online Support -- The CIRT Transaction
  • Password Implications on Online Resource Adapter Termination

    • Chapter 6. Maintaining Database Security

  • Communications and System Security
  • Session-Level Security
  • Conversation-Level Security
  • VM Directory Control Statements
  • User ID Translation
  • Minidisk Protection
  • CMS Restrictions
  • System and DB2 Server for VM Operator Console Considerations
  • Access Control to ISQL on a VSE Guest

    • Chapter 7. Managing Database Storage

  • Storage Concepts
  • How Information is Stored in Dbspaces
  • Adding Dbspaces to the Database
  • Considerations for Adding Dbspaces
  • Example of Adding a Dbspace to a Database
  • Expanding the Database Directory
  • Acquiring Dbspaces for Packages
  • Managing Storage Pools
  • Design Considerations for Storage Pools
  • Monitoring Storage Pools
  • Maintaining Storage Pools
  • Running the SQLADBEX EXEC
  • Moving Dbextents
  • Moving Log Disks

    • Chapter 8. Saved Segments

  • Using Saved Segments for Components
  • Example 1
  • Example 2
  • Example 3
  • Example 4
  • Defining Saved Segments
  •  
  •  
  • Running in User Free Storage after Using Default Saved Segments
  • ARISNLSC MACRO

    • Chapter 9. Making Backups and Recovering from Failures

  • Understanding Recovery Concepts
  • What is a Logical Unit of Work?
  • What is a Log?
  • What is a Checkpoint?
  • What Happens after a System Failure?
  • What is an Archive?
  • Recovering from DASD Failures that Damage the Database
  • Recovering from DASD Failures that Damage a Log
  • Recovering from DASD Failures that Damage the Database and Log
  • Establishing DASD Recovery Procedures
  • Choosing a Log Mode
  • Backing Up the History Area
  • Archiving Procedures
  • Performing Database Archives With Database Manager Facilities
  • Example of an SQLEND ARCHIVE
  • Performing Database Archives With User Facilities
  • Performing Log Archives
  • Example of an SQLEND LARCHIVE
  • Labeling Your Archive Tapes
  • Recovery Procedures
  • Restarting Procedures
  • Restoring the Database
  • Restarting from Failure of a Database Restore
  • Restarting from a System Failure While Archiving
  • Restarting from Failure of a Database Generation or COLDLOG Operation
  • Relocating the Database Manager
  • Replacing a Minidisk Using DASD Dump Restore
  • Replacing a Database Minidisk
  • Replacing a Log Minidisk
  • Recovering to a Secondary System

    • Chapter 10. Special Topics in Recovery Design

  • Switching Log Modes
  • From LOGMODE=A
  • From LOGMODE=L
  • From LOGMODE=Y or N
  • Using Dual Logging
  • Using the VM DUPLEX Command
  • Reconfiguring and Reformatting the Logs
  • Log Reconfiguration
  • Log Reformatting
  • Running the SQLLOG EXEC
  • Switching Log Data between Logs
  • History Area
  • Nonrecoverable Storage Pools
  • Characteristics of Dbspaces in Nonrecoverable Storage Pools
  • Data That Can be Placed in Nonrecoverable Storage Pools
  • Data That Should Not Be Placed in Nonrecoverable Dbspaces
  • Setting Up Nonrecoverable Storage Pools and Dbspaces
  • Querying for Nonrecoverable Storage Pools and Dbspaces

    • Chapter 11. Using the Accounting Facility

  • Where to Find More about VM Accounting
  • Preparing to Use the Accounting Facility
  • Starting the Accounting Facility
  • Generation of Accounting Records
  • Supplying Accounting Data from DRDA Applications
  • Formats of the Accounting Records
  • Initialization Records
  • Operator and Checkpoint Records
  • Termination Records
  • CMS User Records
  • Remote User Records
  • VSE Guest User Records
  • Maintaining Accounting Data
  • Considerations for an Accounting Dbspace
  • Tables to Hold Accounting Data
  • Loading the Accounting Data

    • Chapter 12. Planning and Implementing Configurations

  • Configuration Concepts
  • Reasons for Adding a Database Machine
  • Databases in a TSAF Collection or an SNA Network
  • Adding Service Machines
  • Types of Database Machines
  • Primary Database Machines
  • Why Add a Database Machine?
  • Adding a Primary Database Machine
  • Adding a Secondary Database Machine
  • Adding a Service Machine
  • Defining Additional User Machines
  • Adding a Database
  • VSE Guest Sharing Configuration

    • Chapter 13. Choosing a National Language and Defining Character Sets

  • Considerations when changing default CHARNAME and CCSID
  • Changing from pre-Euro CHARNAME to Euro-compatible CHARNAME
  • Using Alternative Character Sets
  • Hexadecimal Values of the Sample Character Sets
  • Specifying an IBM-Supplied Character Set at Run Time
  • Using Double-Byte Character Set (DBCS)
  • Identifiers Containing DBCS Characters
  • Constants and Data Containing DBCS Characters
  • CCSID Conversion
  • Determining CCSID Values
  • Setting the Application Server Default CHARNAME and CCSIDs
  • Changing the CCSID Attribute of an Existing Column
  • Changing the Subtype Attribute of an Existing Column
  • Setting the Application Requester Default CHARNAME and CCSIDs
  • Setting the Default CHARNAME and CCSIDs for All Application Requesters
  • Setting the Default CHARNAME and CCSIDs for an Application Requester
  • Setting the Application Server Default Character Subtype
  • Setting the DBCS Option for the Application Server
  • Setting DBCS Option for Application Requestors
  • Setting the DBCS Option for all Application Requesters
  • Setting the DBCS Option for an Application Requester
  • EUC Conversions
  • Examples of Setting Values for an Installation
  • Example 1
  • Example 2
  • Identifying Classification and Translation Tables for a CCSID
  • National Language Support for Messages and HELP Text
  • CMS HELP Text Files
  • National Language Messages in a VSE Guest Sharing Environment
  • Defining Message Repositories as Saved Segments

    • Chapter 14. Creating Installation Exits

  • Supplying Account Numbers for Users
  • How the ARIUXIT Module Works
  • Coding Your Own Accounting Exit
  • Installing Your Version of ARIUXIT
  • Service Considerations for ARIUXIT
  • Defining Your Own Datetime Format
  • Datetime Formats
  • How Datetime Exits Work
  • Coding Your Own Datetime Exit
  • Installing Your Version of ARIUXDT or ARIUXTM
  • Updating the SYSTEM.SYSOPTIONS Catalog Table
  • Coding Your Own TRANSPROC Exit
  •  
  • Coding Your Own Cancel Exit
  • Resource Adapter Cancel Support
  • RMXC (Resource Adapter Cancel Exit Control)
  • Field Procedures
  • Specifying the Field Procedure
  • When Field Procedures are Called
  • General Considerations for Writing Field Procedures
  • A Warning about Blanks
  • Maintaining Field Procedures
  • Recovering from Abends in Exits
  • Security with Field Procedures
  • Field Procedures for Cultural Sorts
  • Field Procedure Interface to the Database Manager
  • Field-Definition (Function Code 8)
  • Field-Encoding (Function Code 0)
  • Field-Decoding (Function Code 4)

    • Chapter 15. Using a DRDA Environment

  •  
  • Benefits of Using the DRDA Protocol
  • Added Responsibilities in Using the DRDA Protocol
  • Types of Distributed Access
  • Remote Unit of Work
  • Distributed Unit of Work
  • Summary of DRDA Support in DB2 Server for VM
  • Preparing to Implement DRDA
  • On the Application Requester
  • On the Application Server
  • Installing and Removing the DRDA Code
  • Steps to Install or Remove the DRDA Code
  • Using DRDA
  • Using the DBS Utility on non-DB2 Server for VM Application Servers
  • Using ISQL on non-DB2 Server for VM Application Servers
  • Two-Phase Commit Processing
  • Using the Two-Phase Commit Protocol
  • Operator Commands
  • CRR Operator Commands
  • Resynchronization
  • Resync When Partner is Not Active
  • Resynchronization Initialization
  • Resynchronization Recovery
  • Displaying Resynchronization Status using the SHOW CONNECT Command
  • Terminating Resynchronization using the FORCE Command

    • Chapter 16. Using TCP/IP with DB2 Server for VM

  • Preparing the Application Server to use TCP/IP
  • Preparing the Application Requester to use TCP/IP
  • Security Considerations for TCP/IP
  • Application Requester

    • Appendix A. Virtual and Real Storage Requirements

  • Initial Virtual Storage Requirements of Components
  • User Machine Components
  • Use of SELECT
  • Use of Routines or EXECs

    • Appendix B. Estimating Database Storage

  • Storage Capacities of IBM DASD Devices
  • Determining Equivalent Minidisk Sizes on Different Device Types
  • Relationship of Megabytes to 4-Kilobyte Pages
  • Estimating Directory Space Requirements
  • Estimating Storage Pool Requirements
  • Estimating SYS0001 Dbspace Requirements
  • SYS0001 Storage Estimating General Formula Assumptions
  • Derivation of the General Formula for SYS0001 Storage Estimating
  • Formula for SYS0001 Storage Estimating
  • Examples of Using the SYS0001 Storage Estimating Formula
  • Modifying the SYS0001 Storage Estimating General Formula
  • Estimating ISQL Dbspace Requirements
  • Estimating Dbspace Sizes for Routines
  • Estimating Dbspace Size for Stored SQL Statements (Stored Queries)

    • Appendix C. Maximum Values

  • Database Manager Maximum Values
  • Database Maximum Values

    • Appendix D. Updating SYSTEM.SYSSTRINGS

    Appendix E. Defining Your Own Character Set

  • Step 1: Identify All Characters in Your Character Set
  • Step 2: Classify the Characters
  • Step 3: Determine Translation Characters
  • Step 4: Update the SYSTEM.SYSCHARSETS Catalog Table
  • Step 5: Update the SYSTEM.SYSCCSIDS Catalog Table
  • Step 6: Update the SYSTEM.SYSSTRINGS Catalog Table
  • Step 7: Update the CCSID-Related CMS Files

    • Appendix F. Macro List

    Appendix G. Service and Maintenance Execs

  • ARISAVES EXEC
  • ARISPDFC EXEC
  • Authorization
  • Syntax
  • Description
  • Notes:
  • SQLBOOTS EXEC
  • Authorization
  • Syntax
  • Description
  • SQLGENLD EXEC
  • Authorization
  • Syntax
  • Description

    • Appendix H. DRDA Considerations

  • Omissions from the Standards
  • Extensions to the Standards
  • DB2 Server for VSE & VM Facility Restrictions

    • Appendix I. Incompatibilities Between Releases

  • Definition of an Incompatibility
  • Impact on Existing Applications
  • V2R1 and V1R3.5 Incompatibilities
  • V2R2 and V2R1 Incompatibilities
  • Detailed Notes on V2R2-V2R1 Incompatibilities
  • V3R1 and V2R2 Incompatibilities
  • Detailed Notes on V3R1-V2R2 Incompatibilities
  • V3R2 and V3R1 Incompatibilities
  • Detailed Notes on V3R2-V3R1 Incompatibilities
  • V3R3 and V3R2 Incompatibilities (VM Only)
  • Detailed Notes on V3R3-V3R2 Incompatibilities
  • V3R4 and V3R3 Incompatibilities (VM Only)
  • Detailed Notes on V3R4-V3R3 Incompatibilities
  • V3R5 and V3R4 Incompatibilities
  • V5R1 and V3R5 Incompatibilities
  • V6R1 and V5R1 Incompatibilities
  • V7R1 and V6R1 Incompatibilities

    • Notices

  • Programming Interface Information
  • Trademarks

    • Bibliography

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]