IBM Books

Administration Getting Started

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

  • Welcome
  • Conventions

    • Part 1. Tools and Basic Concepts

  • Chapter 1. DB2 Administration Tools and Basic Concepts
  • Using the Control Center
  • Opening the Control Center
  • Displaying Systems
  • Creating a Basic Database
  • Creating and Working with Objects
  • Overview of Basic Database Objects
  • Tables
  • Views
  • Indexes
  • System Catalog Tables
  • Overview of Recovery Objects
  • Log Files
  • Recovery History File
  • Overview of Storage Objects
  • Table Spaces
  • Containers
  • Buffer Pool
  • Overview of System Objects
  • Configuration Parameters

    • Part 2. Preparing a Database For Use

  • Chapter 2. More About Creating a Database
  • Events Associated with Creating a Database
  • SmartGuide Options for Tuning a Database
  • Adding an Additional Table Space

  • Chapter 3. Preparing a Database for Use
  • Step 1. Creating a Table
  • Step 2. Moving Data Into a Table
  • Importing Data into a Table or View
  • Using the Load Utility to Load Data Quickly
  • Replicating Data
  • Step 3. Enforcing Business Rules for Data
  • Adding a Unique Constraint
  • Defining a Primary Key on an Existing Table
  • Adding a Check Constraint
  • Creating a Schema
  • Step 4. Collecting Statistics
  • How Do I Collect Statistics?
  • Step 5. Backing Up a Database for the First Time
  • Viewing the Recovery History File

  • Chapter 4. Running Applications and Controlling Access To the Data
  • Step 1. Running Applications
  • Running DB2 Embedded SQL Programs
  • Running CLI/ODBC Programs
  • Running Java Programs
  • Step 2. Controlling Access to the Data
  • About Authorities and Privileges
  • Granting and Revoking Authorities and Privileges
  • Creating a View to Restrict Access

    • Part 3. Database Operation

  • Chapter 5. More About Protecting the Data
  • Events that Can Lead to Loss of Data
  • Backing Up a Database
  • About the Logs that DB2 Keeps
  • Configuration Parameters for Database Logging
  • Choosing a Backup Strategy
  • Facilities for Recovering Data
  • How Do I Recover in the Event of a Power Failure?
  • How Do I Perform a Full Database Restore?
  • How Do I Bring the Database Back to a Certain Point in Time?
  • How Do I Recover in the Event of a Disk Failure?

  • Chapter 6. The Basics of DB2 Performance
  • Physical Database Design
  • Separating Different Types of Data
  • Basic Capacity Management
  • Checking Space Available in a Table Space
  • Adding More Space To a Table Space
  • Index Considerations
  • Reorganizing Tables in a Database
  • Setting the Database Configuration Parameters
  • Using the Performance Configuration SmartGuide
  • Tuning the Buffer Pool Size(s)
  • Altering the Size of the Default Buffer Pool
  • Monitoring Performance
  • Considerations for Monitoring and Tuning a Database
  • Monitoring Performance at a Point In Time
  • Analyzing an Event for a Period of Time
  • How To Improve the Performance of a Problem Query Using Visual Explain
  • How to Analyze a Simple Dynamic SQL Statement
  • Other Areas to Watch
  • Managing Initialization Overhead

    • Part 4. Appendixes

  • Appendix A. Working with Scripts and Jobs
  • Creating and Saving a Command Script
  • Using an Existing Script with the Script Center
  • Scheduling a Saved Command Script To Run
  • Working with Jobs

  • Appendix B. Enabling Remote Administration
  • Managing DB2 Server Instances Accessible To Remote Clients
  • Starting and Stopping an Instance

  • Appendix C. Terminology Map

  • Appendix D. Basic Introduction to Troubleshooting

  • Appendix E. About DB2 Universal Database
  • Other DB2 Products
  • DB2 Universal Database Tools

  • Appendix F. How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center

  • Appendix G. Notices
  • Trademarks
  • Trademarks of Other Companies

  • Appendix H. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]