DB2 Server for VSE & VM: Control Center Operations Guide for VM

Table of Contents

About This Manual

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

    • 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

  • About Control Center
  • Product Overview
  • Product Benefits
  • Product History
  • Product Requirements
  • Control Center and the Database Environment
  • Service Machine
  • Distributing Work with Support Machines
  • Sample Environments
  • Control Center Tools Overview
  • System Administration Tools
  • How the System Administration Tools Work
  • List of System Administration Tools
  • Database Administration Tools
  • How the Database Administration Tools Work
  • List of Database Administration Tools
  • Control Center Administration Tools
  • How the Control Center Administration Tools Work
  • List of Control Center Administration Tools

    • Chapter 2. Architecture

  • Overview
  • Related Virtual Machines
  • Service Machine
  • Support Machine
  • Database Machine
  • User Machine
  • Owner Machine
  • Control Center Tools and the Virtual Machines They Run On
  • System Administration Tools on the Service Machine
  • Database Administration Tools on Support and User Machines
  • Control Center Administration Tools on Service and Support Machines
  • Control Center Communications
  • SCIF Communications (Database to Service Machine)
  • Message and File Communication
  • Operator Communication
  • Database Connection
  • Minidisk Layout
  • Code Disk
  • Database Production Code Disk
  • Tape Manager Code Disk
  • Tape Management
  • Multivolume Tapes
  • Tape Mount Procedure
  • Tape Management Products
  • Authorization
  • Authorization Level Definition

    • Chapter 3. Installation and Migration Overview

  • Installation
  • Migration
  • Optional Steps
  • Multiple Databases
  • Control Center Support Machine
  • Corrective Service Planning
  • Processor Requirements
  • Prerequisite Programs
  • Control Center Virtual Machine Requirements
  • VM MAINT Machine
  • Database Machine (SQLMACH)
  • Control Center Service Machine (MSTRSRV)
  • Control Center Support Machine (MSTRSUP)
  • Control Center Owner Machine (MSTROWN)
  • Control Center User Machine (MSTRUSR)

    • Chapter 4. Database Setup

  • Database Setup Considerations
  • Naming Convention
  • Checklist for Setting up a Database to Work with Control Center
  • Preliminary Setup
  • Setup Step 1: Log On to the VM MAINT Machine
  • Setup Step 2: Redefine the Database Machine (SQLMACH)
  • Setup Step 3: Update the VM Directory
  • Setup Step 4: Add SQLMACH Machine to Autolog List
  • Setup Step 5: Log Off the MAINT Machine
  • Control Files Setup
  • Setup Step 6: Log On to the MSTROWN Machine
  • Setup Step 7: Link and Access the Control Center Code Disk
  • Setup Step 8: Start Control Center Session
  • Setup Step 9: Define Database Parameters File
  • Setup Step 10: Define Database TAPES File
  • Setup Step 11: Define Database ARISPOOL File
  • Setup Step 12: End Control Center Session
  • Setup Step 13: Migrate SQLMSTR DIRECTRY and DBINIT CONTROL Files
  • Setup Step 14: SQLMSTR DIRECTRY Customization
  • Setup Step 15: Log Off the MSTROWN Machine
  • Database Machine Setup
  • Setup Step 16: Log On to the Database Machine (SQLMACH)
  • Setup Step 17: Link and Access the Control Center Code Disk
  • Setup Step 18: Copy and Update DBPROF EXEC
  • Setup Step 19: Run DBSTART EXEC
  • Setup Verification
  • Setup Step 20: Log On to the MSTROWN Machine
  • Setup Step 21: Verify Messages Received
  • Setup Step 22: Link and Access the Control Center Code Disk
  • Setup Step 23: Review the Database Startup File
  • |Setup Step 24: Load the Control Center Packages

    • Chapter 5. Corrective Service

  • Installing Corrective Service

    • Chapter 6. Data Restore Setup with Control Center

  • Data Restore Considerations
  • Checklist for Setting up the Data Restore Interface
  • Preliminary Setup
  • Setup Step 1: Log On to the VM MAINT Machine
  • Setup Step 2: Redefine the Data Restore Machine (DRMACH)
  • Setup Step 3: Update the VM Directory
  • Setup Step 4: Add Data Restore Machine to Autolog List
  • Setup Step 5: Log On to the MSTROWN Machine
  • Setup Step 6: Link and Access the Control Center Code Disk
  • Setup Step 7: Define Data Restore Parameters File
  • Setup Step 8: Create the SDRESTOR DIRECTRY
  • Setup Step 9: Migrate SDRESTOR DIRECTRY File
  • Setup Step 10: Start Control Center Session
  • Database TAPES files
  • About the TAPES Files Required for Data Restore
  • Setup Step 11: Update Database Parameters File
  • Setup Step 12: Define & Update Database TAPES Files
  • Setup Step 13: Update the Control Center SQLMSTR Profile
  • Setup Step 14: Create the LINKPWDS File
  • Setup Step 15: Restart Control Center
  • Data Restore Machine Setup
  • Setup Step 16: Log On to the Data Restore Machine (DRMACH)
  • Setup Step 17: Link and Access the Control Center Code Disk
  • Setup Step 18: Create the Data Restore SQLMSTR Profile
  • Setup Step 19: Copy and Update DRFPROF EXEC
  • Setup Step 20: Rename XTS9X001 EXEC
  • Setup Step 21: Run DRMSTR EXEC
  • Setup Step 22: Send the Data Restore Machine (DRMACH) a Message

    • Chapter 7. Version Tool

  • Overview
  • Features
  • Invocation
  • Command Format
  • General Options
  • PTF List Options
  • Non-Control Center Files
  • System Report Option
  • |SQLMSTR PROFILE Validation Report Option
  • PTF Report

    • Chapter 8. Managing the Environment

  • Communications Methodology
  • Understanding Control Center Interrupt Processing
  • Starting and Stopping a Service Machine
  • Manual Startup
  • Automatic Startup
  • Stopping Control Center
  • Starting and Stopping a Support Machine
  • Starting and Stopping the Database Machine
  • Adding Users to Control Center
  • Maintenance
  • Routine Maintenance
  • Disk Maintenance
  • Control File Maintenance
  • Maintaining the SQLMSTR PROFILE File
  • Maintaining the SQLMSTR CONTROL File
  • Maintaining the SQLMSTR DIRECTRY File
  • Maintaining the DBINIT CONTROL File
  • Shared File System (SFS) Support
  • When the Database Name is Not the Virtual Machine Name
  • Maintaining the DATABASE MESSAGES File
  • Maintaining the SQLMSTR HOLIDAYS File
  • Maintaining the SQLMSTR TIMES File
  • Database TAPES File
  • Database PARMS File
  • Problem Resolution

    • Chapter 9. Getting Started

  • Using Control Center
  • Starting a Session
  • Control Center Main Menu
  • Other Type of Panels
  • Fast Path Navigation
  • How to Use Fast Path
  • Where Fast Path is NOT Available
  • Fast Path Help and Hints
  • Control Center Communication Path and Database Settings
  • Control Center Communication Path Setting
  • Control Center Database Setting
  • List Panels
  • Response Panels
  • Saving Response Information

    • Chapter 10. Job Scheduling Tool

  • Overview
  • How You Might Use the Job Scheduling Tool
  • Before You Begin
  • Who Can Use the Job Scheduling Tools
  • How Job Scheduling Works
  • Job Scheduling Concepts
  • Job Dependencies
  • Schedule Interval
  • Job Priority
  • Execution Window
  • Job Scheduling Tool
  • Job Scheduler Panel
  • Job Schedule List Tool
  • Scheduled Job List Panel
  • Job Output Filelist Panel
  • Job Scheduling Architecture
  • Related Files
  • Problem Resolution
  • Correcting Active Job Status
  • Resetting Average Runtime

    • Chapter 11. Tape Management Tool

  • Overview
  • VIEW TAPES (V)
  • TAPE MAINTENANCE (M)
  • SCRATCH TAPE ACQUISITION (ST)
  • DYNAMT Tape Usage
  • DYNOPEN
  • DYNMOUNT
  • Data Restore Tape Types
  • Backup Media
  • Translate Media
  • Incremental Backup Media
  • |FILEDEF and LABELDEF Support for Online Archives

    • |Chapter 12. QMF Tools

  • |QMF Tools Utility
  • |Overview
  • |QMF Tools Setup
  • |QMFINIT $CONTROL Sample Control File
  • |Functional Description

    • Chapter 13. Group Authorization Tool

  • Installation Considerations
  • Group Authorization Tables
  • How it Works
  • Tool Design
  • Options Available
  • ADD a Group
  • DROP a Group
  • ADD/DROP GROUP OBJECTS or USERS
  • GRANT or REVOKE Privileges
  • LIST Functions
  • Invocation
  • Using the Tool
  • |Using the Connect Authorizations Option
  • Sample Scenarios For Working With Group Authorizations
  • Step 1: Define Application Groups
  • Step 2: Add 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
  • Performance
  • Usage Notes
  • Special Considerations

    • Chapter 14. Database Operation Interface Tools

  • Overview
  • Operator Command Tool
  • Database Tracing
  • Advantages of Use
  • Direct Operator Command Tool
  • |Before Issuing SQLREX
  • |SQLREX

    • Chapter 15. Database Status Tool

  • Overview
  • Database Status Display Options
  • Who is Authorized to Use the Status Display Panels
  • About the Master Database Status Display Panel
  • Changing a Database's Status
  • Who Can Change a Database's Status
  • When to Change the Database's Status
  • About SQMODE and DBSTATUS
  • Resetting DBSTATUS and SQMODE

    • Chapter 16. Database Startup and Termination Tools

  • Overview
  • About the Database Parameters Tool
  • Display Fields
  • About the Database Startup Tool
  • Database Termination Tool

    • Chapter 17. Database Archiving and Recovery Tools

  • Overview
  • Before You Begin
  • Telling Control Center How to Manage Your Database Archive
  • SQLMSTR CONTROL
  • SQMOUNT EXEC
  • SQMSTAPE EXEC
  • Database PARMS File
  • Database TAPES File
  • Archive Media Types (Tape and Disk)
  • About Archiving to Disk
  • Log Archives to Disk
  • |Online Archiving and Archive FILEDEF and LABELDEF
  • User Archiving Without Data Restore
  • User Archiving With Data Restore
  • Database Archiving Tool
  • Initiate/Schedule Archive (I/S)
  • Cancel Archive (C)
  • View Job Schedule (VJ)
  • History (H)
  • Log (L)
  • View Tapes (VT)
  • Tape Maintenance (TM)
  • Scratch Tape Acquisition (ST)
  • Database Recovery Tool
  • Introduction
  • How Automated Recovery Works
  • Initiate/Schedule Recovery (I/S)
  • Cancel Recovery (C)
  • Initiate Failure Restart (R)
  • Restart Data Restore (DR)
  • View Job Schedule (VJ)
  • History (H)
  • Log (L)
  • View Tapes (VT)
  • Tape Maintenance (TM)
  • Additional Recovery Considerations
  • Considerations when Running a Manual Recovery
  • Considerations when Reconfiguring Logs
  • How to Run Filtered Log Recoveries

    • Chapter 18. Data Restore Support

  • Overview
  • Description
  • Data Restore Functions
  • Important Considerations
  • Disk and Tape Passwords
  • Architecture
  • Message and Command Processing
  • Communicating with Data Restore
  • Interfaces
  • Status Tracking
  • Installation Considerations
  • Control File Setup
  • Resources
  • Invocation
  • Authorization
  • Performance

    • Chapter 19. Data Restore BACKUP

  • Overview
  • Terms and Definitions
  • Implicit Archives
  • DASD and TAPES
  • Tape Series and History Files
  • BACKUP Process
  • Incremental Backup Process
  • Tape Rotation with Incremental Backup
  • Before You Begin
  • Files Used to Manage BACKUPS
  • User Archiving Without Data Restore
  • How to Invoke BACKUP
  • Authorization
  • Cancel a Data Restore BACKUP

    • Chapter 20. Data Restore RESTORE

  • Overview
  • Considerations When Using Data RESTORE
  • How to Invoke RESTORE
  • RESTORE Process

    • Chapter 21. Data Restore UNLOAD

  • Overview
  • How the UNLOAD Tool Works
  • UNLOAD Control and OUTPUT files
  • Input and Output Media Processing
  • Database UNLTAPES File
  • UNLOAD ID
  • UNLOAD Series
  • UNLOAD Tapes
  • Passwords
  • How to Invoke UNLOAD
  • Data Restore UNLOAD Options
  • After the UNLOAD

    • Chapter 22. Data Restore RELOAD

  • Overview
  • How the RELOAD Tool Works
  • RELOAD Control and OUTPUT files
  • Input and Output Media Processing
  • Passwords
  • How to Invoke RELOAD
  • Table RELOAD Command Generation
  • Tape Passwords

    • Chapter 23. Data Restore TRANSLATE

  • Overview
  • How the Translate Tool Works
  • Translate Files
  • Input and Output Media Processing
  • Tape Processing
  • How to Invoke TRANSLATE
  • Tape Passwords
  • After the Translate

    • Chapter 24. Data Restore LISTLOG

  • Overview
  • How LISTLOG Works
  • How to Invoke
  • Input and Output Media Processing
  • Passwords
  • How to Invoke LISTLOG

    • Chapter 25. Data Restore APPLYLOG

  • Overview
  • How APPLYLOG Works
  • Passwords
  • How to Invoke APPLYLOG

    • Chapter 26. Single User Mode Tools

  • Overview
  • How the Single User Mode Tools Work
  • Single User Mode Log File
  • Single User Mode History Files
  • Who Can Use Single User Mode Tools
  • Add DBEXTENTS Tool
  • How the Add DBEXTENTS Tool Works
  • Add DBEXTENTS Tool Entry Panel
  • Add DBEXTENTS Control Files
  • Add DBEXTENTS Log File
  • Add DBEXTENTS History File
  • Delete DBEXTENTS Tool
  • How the Delete DBEXTENTS Tool Works
  • About the Delete DBEXTENTS Entry Panel
  • Delete DBEXTENTS Control File
  • Delete DBEXTENTS Log File
  • Delete DBEXTENTS History File
  • Copy/Move DBEXTENTS Tools
  • How the Copy/Move DBEXTENTS Tools Work
  • About the Copy/Move DBEXTENTS Options Panel
  • Copy/Move Log Files
  • Copy/Move History Files
  • Copy/Expand Database Directory Tool
  • How the Copy/Expand Database Directory Tool Works
  • Copy/Expand Database Directory Entry Panel
  • Copy/Expand Database Directory Control File
  • Copy/Move Database Log Disk Tool
  • How the Copy/Move Database Log Disk Tool Works
  • Copy/Move Database Log Disk Entry Panel
  • Copy/Move Database Log Disk Control File
  • Copy/Move Data Disk Tool
  • How the Copy/Move Data Disk Tool Works
  • Copy/Move Data Disk Entry Panel
  • Copy/Move Data Disk Control File
  • Add DBSPACE Tool
  • How the Add DBSPACE Tool Works
  • After Adding a DBSPACE
  • About the Add DBSPACE Control File
  • About the Add DBSPACE Panel
  • Add DBSPACE Log File
  • Add DBSPACE History File
  • Database COLDLOG Tool
  • How the Database COLDLOG Tool Works
  • Database COLDLOG Options Panel
  • Database COLDLOG Log File
  • Reorganize Catalog Indexes Tool
  • How the Reorganize Catalog Indexes Works
  • Reorganize Catalog Indexes Options Panel
  • Reorganize Catalog Indexes Log File

    • Chapter 27. Database Monitoring Tools

  • Overview
  • How the Monitors Work
  • Monitor Analysis Activity
  • Database Monitor Types
  • Database Monitoring Panel
  • Selecting a Database Monitor
  • Naming a Database Monitor
  • Database Log Check Monitor (CL)
  • Database Up and Running Check Monitor (CU)
  • Users Active Monitor (UA)
  • Users Connected Monitor (UC)
  • User Locking Monitor (UL)
  • DBSPACE Usage Monitor (SD)
  • POOL Usage Monitor (SP)
  • Database Counters Monitor (CO)
  • Reset Counters Monitor (RC)
  • VMDSS Counter Internal Monitor (CI)
  • VMDSS Counter Pool Monitor (CP)
  • Scheduling a Monitor Routine
  • Monitor Scheduling and Rescheduling
  • Deactivating A Monitor
  • Monitor Scheduling Panel

    • Chapter 28. DBSPACE Reorganization Tools

  • Overview
  • How the DBSPACE Reorganization Tools Work
  • Processing Flow
  • Related files
  • Who Can Use DBSPACE Reorganization Tools
  • Multiple User Mode DBSPACE Reorganization Tool
  • Before You Begin
  • Features
  • Multiple User Mode DBSPACE Reorganization Entry Panel
  • Uses of SQLREORG
  • Special Considerations
  • Unloading to Tape
  • Failure Restart
  • Pause Option
  • Unloaded Data File
  • Failure Analysis
  • Single User Mode DBSPACE Reload Tool
  • Before You Begin
  • Single User Mode DBSPACE Reorganization Panels
  • Full Single User Mode DBSPACE Reorganization Tool
  • Before You Begin
  • How the Single User Mode Reorganization Works
  • Who Can Use the Single User Mode DBSPACE Reorganization Tool
  • Features
  • Single User Mode DBSPACE Reorganization Panels
  • Special Considerations

    • Chapter 29. DBSPACE Reorganization Driver Tool

  • Overview
  • How the DBSPACE Reorganization Driver Tool Works
  • Processing Flow
  • Related files
  • Who Can Use the DBSPACE Reorganization Driver Tool
  • Features
  • DBSPACE Reorganization Driver Entry Panel
  • DBSPACE Reorganization Driver List Panel
  • DBSPACE Reorganization Driver Job Control Panel
  • DBSPACE Reorganization Driver Tape Control Panel
  • Uses of SQLREODR
  • Special Considerations

    • Chapter 30. Table Reorganization Tool

  • Overview
  • Before You Begin
  • Who Can Use the Table Tool
  • How the SQLTABLE Tool Works
  • Features
  • SQLTABLE Panels
  • Special Considerations

    • |Chapter 31. Table Create Utility

  • |Overview
  • |Table Create Utility Functions
  • |Create Table Parameters
  • |Inserting and Deleting Data Columns

    • Chapter 32. Index Reorganization Tool

  • Overview
  • Features
  • How the Index Reorganization Tool Works
  • Command Mode Invocation
  • Index Maintenance Utility Screen
  • Functions
  • Options
  • Files and Reports
  • Sample Index Analysis Report
  • Sample Index Reorganization Report

    • Chapter 33. Automated DBSPACE Maintenance Tools

  • Overview
  • Before You Begin
  • How the Automated DBSPACE Maintenance Tools Work
  • Who Can Use the Automated DBSPACE Maintenance Tools
  • Installing the Automated DBSPACE Maintenance Tool for Operation
  • Step 1. Make SQLMAINT's Files Available to Subsequent Users
  • Step 2. Acquire a Public DBSPACE in which the Tool is to be Installed
  • Step 3. Run the Install Option from the Control Center Panel Interface
  • SQLMAINT Control Table
  • SQLMAINT Installation Output Example
  • DBSPACE Maintenance Utility Panel
  • Display Fields
  • Statistics Maintenance Tool
  • How the Statistics Maintenance Tool Works
  • List Statistics (LS)
  • Update Statistics (US)
  • DBSPACE Reorganization Maintenance Tool
  • How the DBSPACE Reorganization Maintenance Tool Works
  • DBSPACE Maintenance Criteria Selection Screen
  • List Reorg Candidates (LR)
  • Run Reorg Prior Function (RP)
  • Run Reorg Function (RR)
  • Additional Topics
  • Automated Execution
  • Reorganization Work Space
  • Using the SQLMAINT Control Table
  • Summary Comments

    • Chapter 34. Rebind Package Tool

  • Overview
  • Package Rebind Utility Screen
  • Entry Fields
  • Sample Output

    • Chapter 35. Object Search and List Tools

  • Overview
  • Invoking the Object Search and List
  • Navigating the Object Search and List Panels
  • Who Can Use the Object Search and List Tools
  • DBSPACE Search and List Tool
  • DBSPACE Search Entry Panel
  • DBSPACE List Panel
  • Package Search and List Tool
  • Package Search Entry Panel
  • Package List Panel
  • |View Packages
  • |Running EXPLAIN on a Package Query
  • Table Search and List Tool
  • Table Search Entry Panel
  • Table List Panel
  • Index List Tool
  • View List Tool
  • View List Panel
  • Column List Tool
  • Column List Panel
  • Table Referential Integrity Tool
  • Description
  • |Stand-Alone Referential Integrity Tool

    • Chapter 36. Control Center Administration Tools

  • Overview
  • View Message Log Tool
  • Who Can Use the View Message Log Tool
  • How the View Message Log Tool Works
  • View Message Log Panel
  • Sample View Message Log Display
  • Issue Database Commands Tool
  • Who Can Use the Issue Database Commands Tool
  • How the Issue Database Commands Tool Works
  • Issue Database Commands Entry Panel
  • List Control Center VM Database Files Tool
  • Who Can Use the List Control Center VM Database Files Tool
  • How the List Control Center VM Database Files Tool Works
  • List Control Center VM Database Files Panel
  • Query DBEXTENTS/STORPOOL Mapping Tool
  • Who Can Use the Query DBEXTENTS/STORPOOL Mapping Tool
  • How the Query DBEXTENTS/STORPOOL Mapping Tool Works
  • Query DBEXTENTS/STORPOOL Mapping Report

    • Appendix A. Control Center Messages

  • Control Center Message/Action Report

    • Appendix B. Changing Database Name

  • Database Changes
  • Control Center Changes

    • Appendix C. Password Support

  • Links Performed by Control Center
  • Password File Setup
  • READ Passwords on the Database Production Disk
  • How it Works
  • Password Support for Data Restore
  • Password File Setup for the Data Restore machine

    • Appendix D. Master Scheduling Tool

  • Before You Begin
  • Who Can Use the Master Scheduling Tool
  • About Viewing Times Events
  • About Scheduling Times Events
  • Using the Master Scheduling to Schedule Non-Control Center Tools

    • Appendix E. Authorizations

  • Control Center Authorization Levels
  • Authorization to System Administration Tools
  • Authorization to a Database Administration Tools

    • Appendix F. User Archiving

  • Process Flow
  • Preparing for User Archiving
  • Sample User Archive Architecture
  • Steps Required on the Service Machine
  • Steps Required on the Database Machine
  • Steps Required on the Support Machine
  • Steps Required on the BACKUP Product Machine
  • Summary Diagram of Control Center User Archive Architecture
  • Sample Code Supplied with the Product

    • Appendix G. Command Mode Interface

  • Issuing Control Center Commands
  • DBINIT: Database Access
  • SQLMAINT: DBSPACE Maintenance
  • SQLRBIND: Rebind Package
  • SQLREORG: DBSPACE Reorganization
  • SQLTABLE: Table Reorganization and Redefinition
  • SQM: Control Center

    • |Appendix H. Tape Hopper Support

  • |Tape Hoppers and Archiving
  • |No Tape Mounting Required
  • |Special Considerations
  • |Steps for Implementing Control Center Tape Hopper Support
  • |Steps for Turning Control Center Tape Hopper Support Off

    • Appendix I. Parameter Support

  • Single User Mode Startup Parameters
  • Override Startup Parameters Capability

    • Appendix J. Database Shutdown Procedures

  • DBFORCE: Database Shutdown Procedures
  • Who Can Use the DBFORCE Tool
  • How to Use DBFORCE

    • |Appendix K. DB2 UDB Web Control Center Support

  • |Installing DB2 Web Control Center Stored Procedures
  • |USER STEPS to Define (CREATE PROC) Stored Procedures
  • |USER STEPS to Load the Package
  • |USER STEPS to GENMOD the Stored Procedures

    • Notices

  • Trademarks

    • Bibliography

    Index


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