DB2 Universal Database V8.1 Certification Exam 700 Study Guide

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 Visser ”IBM Press, Data Management Program Manager

IBM Toronto Lab

Once again, Susan's help was invaluable ”without her help, this book would not have been written. Susan paved the way for my participation in the DB2 UDB V8.1 exam development process, providing me with both the exam objectives and beta copies of the DB2 UDB V8.1 certification exams. More importantly, Susan helped me make the migration from Osborne/McGraw-Hill to IBM Press. 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.

Jan Kritter ”Database Specialist, IBM SAP Integration and Support Center, Toronto

SAP

Jan did a superb job of reviewing the manuscript and providing me with feedback. Jan pointed out where I assumed the reader was already familiar with a topic (that they might not be familiar with), and he kept me honest. Because of Jan's efforts, some of the finer points you will find throughout this book were clarified or edited before the manuscript went into production.

Howard Fosdick ”President FCI

Founder and Past President of IDUG and MDUG

Howard is the author of the "Configuration Strategies" column in DB2 Magazine and a recognized database certification expert. When I began this project, I turned to him for information on the database certification "industry." Howard provided me with the information I requested , and he reviewed several chapters as soon as they were completed. Howard also provided me with the Foreword for this book.

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 Chapter 6, and Rick reviewed the final draft of many of these drawings for accuracy and completeness.

Paul Rivot ”Director of Database Servers for Software Group

(Vera Patterson, Secretary)

Paul and Vera provided me with a copy of the DB2 Universal Developer's Edition, Version 8.1 software. This software, in turn , was used to produce the screen captures found throughout the book. The online documentation that comes with the DB2 Universal Developer's Edition was used extensively as well.

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 book.