DB2 Server for VSE & VM: Operation

Table of Contents

About This Manual

  • Who Should Use This Manual
  • Conventions Used in This Manual
  • Components of the Relational Database Management System
  • Organization of this Manual
  • How to Send Your Comments
  • Syntax Notation Conventions
  • SQL Reserved Words
  • Related Information

    • 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. Starting and Stopping the Application Server

  • About the Product
  • About Operating the Application Server
  • Starting the Application Server in a VSE Environment
  • Starting the Application Server in a VM Environment
  • Specifying Initialization Parameters
  • Viewing or Changing the Initialization Parameters
  • Obtaining More Information
  • Putting Initialization Parameters in VSE Source Members or in VM CMS Files
  • Overriding Parameters in a Source Member
  • Overriding a CMS Parameter File
  • Using Multiple User Mode and Single User Mode
  • Starting the Application Server in Multiple User Mode
  • Starting the Application Server in Single User Mode
  • Specifying Parameters for User Programs
  • Specifying CMS FILEDEF Commands for the Application Server
  • Overriding the Block Size
  • Specifying an Alternative Tape Drive Address
  • Overriding CMS FILEDEF Commands
  • Disconnecting the Application Server
  • Stopping the Application Server

    • Chapter 2. Managing Online Support

  • Starting VSE Guest Sharing Support
  • VSE Guest Sharing Operator Responsibilities
  • Starting the Online Support
  • Displaying the Status of the Online Support
  • Stopping the Online Support
  • Password Implications on Online Resource Adapter Termination
  • Adding Online Connections Support
  • Removing Online Connections Support
  • Changing Online Default Support
  • Using Syntax Rules for DB2 Server for VSE CICS Transactions
  • Managing DRDA2 Task-Related User Exits
  • Setting Parameters Required to Autostart DRDA TRUE
  • Disabling DRDA TRUE Support Within CICS/VSE

    • Chapter 3. Operating the Application Server

  • Issuing DB2 Server for VSE & VM Operator Commands
  • From the VSE System Operator Console
  • From the VM System Console
  • From the Application Server Operator Console
  • From a CICS Terminal
  • From User Displays
  • DB2 Server for VSE Accounting
  • Using Alternate Accounting Files
  • Archiving the Database
  • Creating a User Archive
  • Archiving the Log
  • Archiving the Log to Tape in VM/ESA
  • Archiving the Log to Disk in VM/ESA
  • Forcing Users to End Their Work
  • Forcing DB2 Server for VSE Remote Users to End Their Work
  • VM/ESA FORCE Enhancements for CRR
  • Choosing a National Language
  • Monitoring Performance
  • COUNTER
  • RESET
  • RESET CRR LOGNAMES (VM only)
  • RESET HIGHSTOR
  • RESET INDOUBT
  • SET
  • SHOW ACTIVE
  • SHOW ADDRESS
  • SHOW BUFFERS
  • SHOW CONNECT
  • SHOW CRR LOGNAMES (VM Only)
  • SHOW DBCONFIG
  • SHOW DBEXTENT
  • SHOW DBSPACE
  • SHOW INDOUBT
  • SHOW INITPARM
  • SHOW INVALID
  • SHOW LOCK ACTIVE
  • SHOW LOCK DBSPACE
  • SHOW LOCK GRAPH
  • SHOW LOCK MATRIX
  • SHOW LOCK USER
  • SHOW LOCK WANTLOCK
  • SHOW LOG
  • SHOW LOGHIST
  • SHOW POOL
  • SHOW PROC
  • SHOW PSERVER
  • SHOW STORAGE
  • SHOW SYSTEM
  • SHOW USERS (Valid for VM only)
  • START PROC
  • START PSERVER
  • START TCPIP
  • STOP PROC
  • STOP PSERVER

    • Chapter 4. Recovering from System or Media Failures

  • General Recovery
  • Resolving DRDA 2 In-Doubt Logical Units of Work
  • Useful CRR Commands (Valid for VM only)
  • Resolving CICS In-Doubt Logical Units of Work
  • Recovery from Media Failure

    • Chapter 5. Tracing the DB2 Server for VSE & VM System

  • DB2 Server for VSE & VM Tracing
  • Specifying CMS FILEDEF for a DB2 Server for VM Trace
  • Specifying Job Control for a DB2 Server for VSE Trace
  • Tracing in Multiple User Mode
  • Tracing in Single User Mode
  • Tracing to a CMS File
  • Special Considerations for Multiple Activations of Tracing
  • Tracing the DB2 Server for VSE Resource Adapter
  • Choosing the Functions to Be Traced
  • Starting a Trace
  • Stopping a Trace
  • Formatting DB2 Server for VM Trace Output
  • Formatting DB2 Server for VSE Trace Output
  • Trace Formatter Control Statements
  • Format of DB2 Server for VSE & VM Trace Output
  • Isolating Problems
  • ISQLMAP
  • ISQL Dumps in DB2 Server for VSE
  • ISQL In-Core Trace

    • Appendix A. DB2 Server for VSE & VM Initialization Parameters

  • Common Parameters
  • Common Tracing Parameters
  • DB2 Server for VSE Parameters
  • DB2 Server for VM Parameters
  • DB2 Server for VM Data Spaces Support Parameters

    • Appendix B. VMDSS Operator Commands

  • COUNTER POOL
  • Syntax
  • RESET POOL
  • Syntax
  • SET POOL
  • Syntax
  • SET SAVEINTV
  • Syntax
  • SET TARGETWS
  • Syntax
  • SHOW ACTIVE
  • Syntax
  • SHOW BUFFERS
  • Syntax
  • SHOW LOCK ACTIVE
  • Syntax
  • SHOW LOCK GRAPH
  • Syntax
  • SHOW POOL
  • Syntax
  • SHOW SAVEINTV
  • Syntax
  • SHOW TARGETWS
  • Syntax
  • Internal Counters

    • Notices

  • Trademarks

    • Bibliography

    Index


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