Administration Getting Started

Welcome

This book will teach you:

• How to use the DB2 administration tools to administer a single, local database. You access the tools from the Control Center. For information about multi-node databases, see the Administration Guide.

• Basic DB2 administration concepts

• To perform basic DB2 administration tasks covering the areas of:
  • Database implementation
  • Database management
  • Database configuration and tuning to improve performance

The Administration Guide covers all administration topics at a more advanced level.

Another interface you can use to perform administration tasks, which is not described in this book, is the application programming interface (API). It allows you to execute DB2 utility functions within an application program using SQL statements or DB2 APIs. For more information about using the application programming interface, see the Embedded SQL Programming Guide and the API Reference book. You can also use the command line processor (accessible from its own icon in the DB2 product folder) to execute SQL statements and DB2 commands. It is described in the SQL Reference.

Before you perform any of the actions described in this book, you should:

• Install and configure the server and install the SAMPLE database as outlined in the Quick Beginnings book for your platform. It is recommended that you do not put your own data into the DB2 SAMPLE database.

• Create the user ID following the instructions in the Quick Beginnings for your platform. That user ID should have SYSADM authority.

Use the table below to help you quickly find the part of the book you are interested in.

Part 1. "Tools and Basic Concepts"	Provides an overview of the tools to use to manage a DB2 system, shows you how to create a basic database and work with objects, and describes the components of a DB2 database.
Part 2. "Preparing a Database For Use"	Explains how to: Add a table space Create a table Move data into a database Enforce rules for the data Collect statistics Back up a database Support applications Control access to the data
Part 3. "Database Operation"	Explains more about how to protect data, how to recover data, and some basics of DB2 performance.

[ DB2 List of Books | Search the DB2 Books ]