Roger E. Sanders - DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade: Certification Study Guide

DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide Roger E. Sanders

First Edition

First PrintingOctober 2007

2007 Roger Sanders. All rights reserved.

Every attempt has been made to provide correct information. However, the publisher and the author do not guarantee the accuracy of the book and do not assume responsibility for information included in or omitted from it.

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: DB2, Lotus, Tivoli, WebSphere, Rational, IBM, the IBM logo, and IBM Press. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of the Microsoft Corporation in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds. Intel, Intel Inside (logo), MMX, and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. OSF/1 and UNIX are registered trademarks and The Open Group is a trademark of the The Open Group in the United States and other countries. Other company, product, or service names mentioned herein may be trademarks or service marks their respective owners.

Printed in Canada. All rights reserved. This publication is protected by copyright, and permission mut be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.

MC Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include custom covers and content particular to your business, training goals, marketing focus, and branding interest.

For information regarding permissions or special orders, please contact:

MC Press

Corporate Offices

125 N. Woodland Trail

Lewisville, TX 75077 USA

For information regarding sales and/or customer service, please contact:

MC Press

P.O. Box 4300

Big Sandy, TX 75755-4300 USA

ISBN 10: 158347-078-6
ISBN 13: 978-158347-078-7

Dedication

To my sister, Kathy

A project of this magnitude requires both a great deal of time and the support of many different individuals. I would like to express my gratitude to the following people for their contributions:

Susan Dykman - Information Management Certification Program Manager, IBM Information Management

Susan invited me to participate in the DB2 9 exam development process, and provided me with screen shots of the IBM Certification Exam Testing software. Susan also reviewed the first chapter of the book and provided valuable feedback.

Susan Visser - IBM Press, Data Management Program Manager IBM Toronto Lab

Once again, Susans help was invaluable; without her help, this book would not have been written. Susan paved the way for me to acquire the rights to the Version 8.1 manuscript and move to MC Press when Pearson Education decided not to publish an updated version of my Version 8.1 book. Susan also reviewed many of the chapters as they were written, and she made sure the appropriate subject-matter experts at the IBM Toronto Lab reviewed portions of the manuscript as well.

Dr. Arvind Krishna - Vice President, IBM Data Servers and Worldwide Information Management Development

Dr. Krishna provided me with the Foreword for this book.

Reed M. Meseck - Senior Competitive Specialist, IBM Information Management Software

Reed helped Dr. Arvind Krishna develop the Foreword for this book.

Brant Davison - Program Director, IBM Information Management Software

Brant worked with me to ensure that Dr. Arvind Krishna received the materials he needed to develop the Foreword for this book.

Jason Gartner - Executive Assistant to Arvind Krishna

Jason worked with Reed Meseck and Dr. Arvind Krishna to make sure I received the Foreword for this book in a timely manner.

Rick Swagerman - Sr. Technical Manager, DB2 SQL and Catalog Development IBM Toronto Lab

Rick provided me with detailed examples illustrating how the UPDATE/DELETE NO ACTION and UPDATE/DELETE RESTRICT rules of referential constraints work. His examples were converted into some of the illustrations you see in , and Rick reviewed the final draft of many of these drawings for accuracy and completeness.

Dale McInnis - Sr. Technical Staff Member, DB2 High Availability IBM Toronto Lab

Dale reviewed the material in - High Availability for accuracy and completeness; the valuable feedback he provided was I incorporated into the chapter.

I would also like to thank my wife Beth for her help and encouragement, and for once again overlooking all of the things that did not get done while I worked on yet another (my 16th) book.

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. He has been designing and developing database applications for more than 20 years and has been working with DB2 and its predecessors since it was first introduced on the IBM PC (as part of OS/2 Extended Edition). He has written articles for publications such as Certification Magazine and IDUG Solutions Journal, authored tutorials for IBMs developerWorks Web site, presented at numerous International DB2 Users Group (IDUG) and Regional DB2 Users Group (RUG) conferences, taught classes on DB2 fundamentals and database administration (DB2 for Linux, UNIX, and Windows), writes a regular column called Distributed DBA in DB2 Magazine, and is the author of the following books:

• DB2 9 for Linux, UNIX, and Windows Database Administration Certification Exam Study Guide
• Using the IBM System Storage N Series with Databases (IBM RedBook; co-author)
• DB2 9 Fundamentals Certification Study Guide
• Integrating IBM DB2 with the IBM System Storage N Series (IBM RedBook; co-author)
• Using IBM DB2UDB with IBM System Storage N Series (IBM RedBook; co-author)
• DB2 Universal Database V8.1 Certification Exam 703 Study Guide
• DB2 Universal Database V8.1 Certification Exam 701 and 706 Study Guide
• DB2 Universal Database V8.1 Certification Exam 700 Study Guide
• DB2 UDB Exploitation of NAS Technology (IBM RedBook; co-author)
• All-In-One DB2 Administration Exam Guide
• DB2 Universal Database SQL Developers Guide
• DB2 Universal Database API Developers Guide
• DB2 Universal Database Call Level Interface Developers Guide
• ODBC 3.5 Developers Guide
• The Developers Handbook to DB2 for Common Servers

In addition, Roger holds the following professional certifications:

• IBM Certified Advanced Database AdministratorDB2 9 for Linux, UNIX, and Windows
• IBM Certified Application DeveloperDB2 9
• IBM Certified Database AdministratorDB2 9 DBA for Linux, UNIX, and Windows
• IBM Certified Database AssociateDB2 9 Fundamentals
• IBM Certified Advanced Database AdministratorDB2 Universal Database V8.1 for Linux, UNIX, and Windows