Control Center Operations Guide for VSE

Table of Contents

About This Manual

  • Who Should Use This Manual
  • Conventions Used in This Manual
  • Organization of This Manual
  • Prerequisite IBM Publications
  • |How to Send Your Comments

    • 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. Introduction

  • Product Benefits
  • Access Control
  • Single User Mode Parameters
  • Multiple Database Support
  • Database Operator Command Interface
  • DBSPACE Reorganization
  • DBSPACE Analysis
  • Group Authorization Tools
  • Monitor Tools
  • Package Tools
  • Work File Label Definition
  • CICS Report Controller Interface
  • Help Facility
  • Job Scheduling Tool
  • Query Management Facility
  • Table Utility Tool
  • Prerequisite Programs
  • About Control Center
  • Control Center's DBA ID
  • How to Invoke
  • Before You Use Control Center
  • |Changing to a New Database

    • Chapter 2. Getting Started

  • Getting Started With Control Center

    • Chapter 3. Using the Operator Command Interface Tool

    Chapter 4. DBSPACE Reorganization Tool

  • When To Reorganize
  • Features
  • How the DBSPACE Reorganization Tool Tool Works
  • Using the DBSPACE Reorganization Utility Screen
  • Optional Parameters
  • Using the DBSPACE REORGANIZATION Tool
  • Option 1 - GENERATE DDL
  • Option 2 - UNLOAD DBSPACE
  • Option 3 - REORGANIZE DBSPACE
  • Option 4 - RELOAD DBSPACE
  • DBSPACE Reorganization Submit Screen
  • VSE/POWER Parameters
  • Single User Mode (SUM) DBSPACE Reorganization
  • Before You Choose Single User Mode Execution
  • Single User Mode Parameters
  • DBSPACE Reorganization Tape Support
  • Unloading to Tape
  • Special Considerations
  • Repetitive Scheduling
  • Failure Restart
  • Problem Analysis

    • Chapter 5. DBSPACE Analysis Tools

  • About the DBSPACE Analysis Tools
  • Before You Begin
  • How the DBSPACE Analysis Tools Work
  • SQLMAINT Table
  • DBSPACE Analysis Utility Screen
  • Functions
  • Selection Options
  • DBSPACE Reorganization Criteria (CRITERIA)
  • Update Statistics Analysis Tool
  • DBSPACE Reorganization Analysis Tool
  • DBSPACE Analysis Submit Screen
  • VSE/POWER Job Parameters
  • DBSPACE Analysis Job Options
  • Additional Topics
  • Initial Execution
  • Reorganization Work Space

    • Chapter 6. Work File Label Definition Tool

  • About the Work File Label Definition Tool
  • Work File Label Definition Screen
  • How the Work File Label Definition Tool Works
  • Disk Work File Label Definition Screen
  • Disk Work File Label Definition Fields
  • Tape Work File Definition Screen
  • Special Considerations

    • Chapter 7. CICS Report Controller Interface Tool

  • About the CICS Report Controller Interface Tool
  • A Sample CICS Report Controller Session

    • Chapter 8. Control Center Help Facility

  • About the Help Facility

    • Chapter 9. Package Utility

  • Introduction
  • Package Utility Functions
  • Package Function Descriptions
  • Package Migration
  • Invocation
  • Package Utility Parameters
  • Using the Package Utility

    • Chapter 10. Group Authorization Tool

  • About the Group Authorization Tool
  • Functions
  • ADD a Group
  • DROP a Group
  • Manage Group Objects and Users
  • Manage Privileges
  • LIST Functions
  • Using the Group Authorization Tool
  • Step 1: Define Application Groups
  • |Step 2: Add (or Drop) Objects to the Application Group
  • Step 3: Define User Groups
  • Step 4: Add Users to the User Groups
  • Step 5: Grant Authorities to the User Groups
  • Special Considerations

    • Chapter 11. The Monitor Maintenance Menu

  • How the Monitors Work
  • Options and Monitors Available
  • Monitor Thresholds and VSE Console Messages
  • Description of Monitor Options
  • Start the Monitor Kernel
  • Stop the Monitor Kernel
  • List Monitors
  • Add a Monitor
  • Modify a Monitor
  • Delete a Monitor
  • Display a Monitor
  • View Data
  • Reset Data
  • Print Report
  • Types of Monitors
  • SHOW ACTIVE
  • SHOW LOCK
  • SHOW DBEXTENT
  • SHOW LOG
  • SHOW CONNECT
  • SHOW DBSPACE
  • COUNTER *
  • Invocation
  • How To Use the Monitors
  • Adding A Monitor
  • Using the Monitor Maintenance Menu
  • Specifying Monitor Thresholds
  • Starting a Monitor
  • Changing a Monitor
  • Viewing Monitor Data
  • Stopping a Monitor

    • Chapter 12. Table Utility

  • Invocation
  • LIST TABLES
  • List Tables Processing Flow
  • DROP TABLE
  • Drop Table Processing Flow
  • REORGANIZE TABLE
  • Reorganize Table Processing Flow
  • Table Reorganization Menu Required Parameters
  • Table Reorganization Menu Optional Parameters
  • Using the TABLE REORGANIZATION Option
  • Table Reorganization Submit Screen
  • CREATE TABLE
  • Create Table Processing Flow
  • Using the Create Table Function
  • Create Table Parameters
  • UPDATE STATISTICS
  • Update Statistics Submit Screen Required Parameters
  • Update Statistics Submit Screen Optional Parameters

    • |Chapter 13. Installing Stored Procedures Support

    Appendix A. Reorganization Job Streams

    Appendix B. DBSPACE and Table Reorganization Tool Related Files

    Notices

  • Trademarks

    • Glossary

    Bibliography

    Index

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