DB2 Server for VSE: 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

  • Usage Environments
  • Batch Application Processing
  • Online (CICS) Transaction Processing
  • Interactive Application Development
  • Query/Report Writing
  • Components of the Relational Database Management System
  • Prerequisite Programs
  • Virtual Storage Requirements
  • Hardware Requirements
  • DBNAME Directory Requirements
  • DB2 Key Processing

    • Chapter 2. Planning for Database Generation

  • Setting Up the DB2 Product Key
  • 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
  • Setting Up the DBNAME Directory
  • The IBM-Supplied DBNAME Directory
  • Updating the DBNAME Directory
  • CICS CEDA DEF CONNECTIONS Command for a Remote Entry
  • 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 a Server Name
  • Elimination of the SET XPCC Command
  • Choosing an Application Server Default CHARNAME
  • Considerations for Mixed Primary Keys with Field Procedures
  • Considerations for EXPLAIN Tables
  • Considerations for VSE Guest Sharing
  • 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 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
  • Choosing the Default CHARNAME for All Application Requesters
  • Considerations for VSE DRDA Online Requester Support
  • Considerations for RDS Above 16M
  • Migrating from Version 6 Release 1
  • Considerations for the DBNAME Directory
  • Considerations for Key Enablement
  • Release Coexistence Considerations
  • Changing the Server Name and Application Server Identifier

    • Chapter 4. Planning for Operation of the Database Manager

  • Starting the Application Server
  • Modes of Operation
  • Multiple User Mode Initialization Parameters
  • Single User Mode Initialization Parameters
  • Tape Support
  • Starting the Application Server in Multiple User Mode
  • Running Multiple User Mode Application Programs
  • Starting the Application Server in Single User Mode
  • Overriding Initialization Parameters
  • Creating a Parameter Data Set
  • Stopping the Application Server
  • Taking an Archive
  • Verifying the Directory
  • Online Support Considerations

    • Chapter 5. Operating the Online Support

  • Operating VSE Guest Sharing
  • Operator Responsibilities
  • 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

  • Protecting VSAM Data Sets
  • VSAM Restrictions
  • Controlling Access by ISQL Users
  • Controlling Access by Remote Users
  • DRDA Security

    • Chapter 7. Managing Database Storage

  • Storage Concepts
  • How Information is Stored in Dbspaces
  • Adding Dbspaces to the Database
  • The ADD DBSPACE Operation
  • Considerations for Adding Dbspaces
  • Expanding the Database Directory
  • Acquiring Dbspaces for Packages
  • Managing Storage Pools
  • Design Considerations for Storage Pools
  • Monitoring Storage Pools
  • Maintaining Storage Pools

    • Chapter 8. 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
  • Choosing Dynamic or Static Tape Devices
  • Archiving Procedures
  • Performing Database Archives With Database Manager Facilities
  • Performing Database Archives With User Facilities
  • Performing Log Archives
  • 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 Dbextent
  • Replacing a Log
  • Recovering to a Secondary System

    • Chapter 9. Special Topics in Recovery Design

  • Switching Log Modes
  • From LOGMODE=A
  • From LOGMODE=L
  • From LOGMODE=Y or N
  • Using Dual Logging
  • Reconfiguring and Reformatting the Logs
  • Log Reconfiguration
  • Log Reformatting
  • 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 10. Using the Accounting Facility

  • Preparing to Use the Accounting Facility
  • Setting Up Your System
  • Setting Up a Job Control for the Accounting Files
  • Starting the Accounting Facility
  • Operating the Accounting Facility
  • Generation of Accounting Records
  • Using DRDA Accounting
  • Supplying Accounting Data from DRDA Applications
  • Formats of the Accounting Records
  • Initialization Records
  • Operator and Checkpoint Records
  • Termination Records
  • User Records
  • Remote User Records
  • DRDA Records
  • VSE Guest User Records
  • Maintaining Accounting Data
  • Considerations for an Accounting Dbspace
  • Tables to Hold Accounting Data
  • Loading the Accounting Data
  • Converting VSAM ESDS Accounting File Records into VSAM Managed SAM Feature Records

    • Chapter 11. Generating Additional Databases

  • Learning about Configuration Concepts
  • Reasons for Adding a Database Partition
  • Database Generation Process
  • Step 1: Update the DBNAME Directory
  • Step 2: Defining the Database Data Sets
  • Step 3: Setting Up Your Database Job Control
  • Step 4: Generating the Database
  • Step 5: Installing the Database Components
  • Step 6: Reload CCSID-Related Packages
  • Step 7: Optionally Changing the Application Server Default CHARNAME
  • Step 8: Optionally Changing the Application Server Default Character Subtype
  • Step 9: Optionally Setting the DBCS Option to YES
  • Step 10: Changing the Password of Authorization ID SQLDBA
  • Step 11: Optionally Install the DRDA Code
  • Step 12: Optionally Load Phases into SVA

    • Chapter 12. 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
  • The SQLGLOB File Batch Query/Update Program
  • Setting the Application Server Default Character Subtype
  • Setting the DBCS Option for the Application Server
  • Setting the Default Application Requester DBCS Option
  • 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
  • Changing the ISQL Default Language
  • National Language Messages in a VSE Guest Sharing Environment

    • Chapter 13. 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
  •  
  • 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 14. 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 VSE
  • Preparing to Implement DRDA
  • On the Application Requester
  • On the Application Server
  • Entries Required in CICS System Definition File
  • CICS Program Definitions Required for DRDA
  • Entries Required in DFHSIT
  • Terminal Definitions Required by AXE
  • Entries Required in DFHCSDUP
  • Entries Required in DFHSNT
  • CICS Transaction Server (TS) Considerations
  • Installing and Removing the DRDA Code
  • Installing the DRDA Code on the Application Server
  • Removing the DRDA Code on the Application Server
  • Installing the DRDA Code on the Application Requester
  • Removing the DRDA Code on the Application Requester
  • Using DRDA
  • Creating Packages on the Remote Server
  • Using the DBS Utility on Remote Application Servers
  • Using ISQL on non-DB2 Server for VM Application Servers
  • Two-Phase Commit Processing
  • Using the Two-Phase Commit Protocol
  • CICS/VSE Syncpoint Manager and the Task Related User Exit (TRUE)
  • Managing In-Doubt LUW's
  • Operator Commands
  • Making Heuristic Decisions
  • Resynchronization
  • Resync When Partner is Not Active
  • Resolution of In-doubts

    • Chapter 15. Using TCP/IP with DB2 Server for VSE

  • Preparing the Application Server to use TCP/IP
  • Preparing the Application Requester to use TCP/IP

    • Appendix A. Processor Storage Requirements

  • Virtual Storage Requirements of Components
  • CICS Dynamic Storage Considerations
  • Use of SELECT
  • Use of Routines
  • CICS Temporary Storage Queues

    • Appendix B. Estimating Database Storage

  • Storage Capacities of IBM DASD Devices
  • 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 Phases

    • Appendix F. Macro List

    Appendix G. DRDA Considerations

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

    • Appendix H. 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
  • V3R4 and V3R2 Incompatibilities (VSE Only)
  • Detailed Notes on V3R4-V3R2 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 ]