Release Team[oR] 2001
[x] Database
- 2 -
Sams Teach Yourself DB2 Universal Database in 21 Days
by Susan Visser
ISBN: 0672312786
Sams © 1998, 501 pages
This in-depth guide offers a hands-on, 21-day course in DB2
database administration.
Table of Contents Colleague Comments
Back Cover
Synopsis by Dean Andrews
DB2 development team member Susan Visser guides you through the
administering of a DB2 Universal Database system in this in-depth 21-day
course. Although DB2 runs on UNIX, OS/2, and Windows NT, this book's
examples focus primarily on Windows NT. However, most of the course's
content -- which includes configuring a DB2 client/server setup, creating
databases, using admin tools, backup and recovery methods, performance
tuning, and more -- describes the techniques used for any DB2 version 5
product. As with other "in 21 days" books, this volume comes complete with
quizzes, tips, lesson plans, and answers in the back.
Table of Contents
Sams Teach Yourself DB2 Universal Database in 21Days - 3
Introduction - 5
Week 1
Day 1
- What Can DB2 Do For You? - 7
Day 2
- Exploring the Capabilities of DB2 Universal Server - 24
Day 3
- Installing and Configuring DB2 Server - 52
Day 4
- Getting Started - 60
Day 5
- Configuring Server Communications with the Control Center - 76
Day 6
- Installing DB2 Clients - 85
Day 7
- Designing a CDLIB Database - 103
Week 1
Week 2 At a Glance
Day 8
- Creating Databases - 119
Day 9
- Creating Table Spaces - 131
Day 10
- Accessing the Data - 143
Day 11
- Using System Administration Tools - 158
Day 12
- Backing Up and Recovering Data - 171
Day 13
- Moving Data - 182
Day 14
- Replicating Data - 201
Week 2
- 3 -
Week 3 At a Glance
Day 15
- Ensuring Data Security - 215
Day 16
- Administering Clients with the CCA - 224
Day 17
- Working with DB2 Instances - 237
Day 18
- Performance Aids - 243
Day 19
- Design Considerations - 267
Day 20
- Tuning DB2 Universal Database Performance - 276
Day 21
- Diagnosing Problems - 292
Week 3
Appendix A
- Answers to Quiz Questions - 304
Appendix B
- Uninstalling DB2 Products - 314
Appendix C
- Road Map to DB2 Information - 317
Back Cover
This step-by-step, hands-on guide teaches you all the new feature to DB2
Universal Database Version 5. Learn the basics of this database in 21 easy-
to-follow lessons. You'll:
• Learn how DB2 can improve your productivity and profitability with
better organization
• Master shortcuts to instantly increase your productivity
• Find out more about parallelism, replication, and Web access.
• Take advantage of helpful tips from the experts.
• Learn to build secure distributed databases
• Build replication databases into a network environment
About the Author
Susan Visser is a member of the IBM's DB2 Universal Database development
team and the author of numerous books on the product.
Sams Teach Yourself DB2 Universal Database
in 21Days
Susan M. Visser
Sams
A Division of Macmillan Computer Publishing
201 West 103rd St., Indianapolis, Indiana, 46290 USA
Executive Editor
Bryan Gambrel
Acquisitions Editor
- 4 -
Angela C. Kozlowski
Development Editors
Susan Shaw Dunn
Rich Alvey
Managing Editor
Jodi Jensen
Project Editor
Maureen A. McDaniel
Copy Editors
Kate Talbot
Michael Brumitt
San Dee Phillips
Indexer
Erika Millen
Technical Editors
IBM
Jim Hobuss
Willie Favero
Rich Yevich
Software Development Specialist
Andrea Duvall
Production
Michael Henry
Linda Knose
Timothy Osborn
Staci Somers
Mark Walchle
Copyright © 1998 by Sams Publishing
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system,
or transmitted by any means, electronic, mechanical, photocopying, recording, or
otherwise, without written permission from the publisher. No patent liability is assumed
with respect to the use of the information contained herein. Although every precaution
has been taken in the preparation of this book, the publisher and author assume no
responsibility for errors or omissions. Neither is any liability assumed for damages
resulting from the use of the information contained herein.
International Standard Book Number: 0-672-31278-6
- 5 -
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have
been appropriately capitalized. Sams cannot attest to the accuracy of this information.
Use of a term in this book should not be regarded as affecting the validity of any
trademark or service mark.
About the Author
Susan M. Visser has been an employee of IBM Canada for 8 1/2 years. For six of these
years, she worked as a technical writer assigned to the DB2 Universal Database product.
A
s part of her job, she has written more than 15 technical manuals over the five versions of
the product. She helped set the information strategy and provided input to the look and feel
of the product. You can reach Susan via email at suenkarl@interlog.com.
Acknowledgments
Thanks to the many people who helped make this book a reality. Special thanks go to
Susan Dunn and Angela Kozlowski at Macmillan Publishing for helping get me over the
hurdles of this, my first publication.
Thanks also to my management and colleagues: Gary Sampson, Kathryn Fryer, Mark
Ryan, Jasna Krmpotic, Sheila Richardson, David Sky, David Ready, Richard Hedges,
and Dale McInnis. Thanks also to everyone else I deal with on a regular basis who may
have helped without even knowing they helped.
Thanks also to my husband, Karl, for helping me test the information and the samples and
for looking after all the things I ignored.
Introduction
Overview
Welcome to Teach Yourself DB2 Universal Database in 21 Days! This book explores how
to install and use version 5 of the DB2 Universal Database product.
DB2 Universal Database is a powerful relational database that can help you and your
business become more successful. This book will show you how to exploit DB2's features
to create world-class applications that can put your business ahead of your competition.
Throughout the book we have highlighted successful applications that work with DB2's
most lucrative features, including integration with the Internet, storing and manipulating
multimedia objects, DB2 parallelism, exploitation of the Windows NT environment and
electronic business.
The focus is on using the administration tools provided with the product. During a three-
week period, you will be exposed to many aspects of database administration, including
installing the product, setting up a server to accept requests from clients, designing and
creating a database, designing and creating the tables and relationships that make up a
relational database, exploiting table spaces, and using the various tools to tune
performance.
You also will learn how to use the tools provided with DB2 Universal Database to simplify
the task of administering your database.
In addition to the 21 lessons are three appendixes: one to provide the answers to the quiz
questions, one that explains how to uninstall the DB2 product, and one that walks you
through the massive library included with the product.
Assumptions