DB2 UDB V8.1 Certification Test 701 Study Guide

( 2 )

Overview

Over 20,000 people test to become IBM Certified Database Administrators every year. Some will pass, many will not. This book is IBM's official companion to mastering the skills that you need to ensure that you pass Certification Exams 701 and 706.

Written by a member of the DB2 UDB Version 8.1 Certification Exam development team, DB2 Universal Database v8.1 Certification Exams 701 and 706 Study Guide delivers information that every database administrator should be familiar with ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (13) from $1.99   
  • New (3) from $30.96   
  • Used (10) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$30.96
Seller since 2014

Feedback rating:

(34)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2003-12-15 Paperback New Get it fast, ng151Get it fast.

Ships from: austin, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$52.43
Seller since 2014

Feedback rating:

(258)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$60.00
Seller since 2014

Feedback rating:

(135)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Over 20,000 people test to become IBM Certified Database Administrators every year. Some will pass, many will not. This book is IBM's official companion to mastering the skills that you need to ensure that you pass Certification Exams 701 and 706.

Written by a member of the DB2 UDB Version 8.1 Certification Exam development team, DB2 Universal Database v8.1 Certification Exams 701 and 706 Study Guide delivers information that every database administrator should be familiar with before they take the DB2 Universal Database v8.1 Database Administrator certification exams.

Author and DB2 UDB expert Roger E. Sanders covers every aspect of DB2 UDB v8.1 in clear, concise, and well-ordered chapters that give you the information you need to maximize your effectiveness come test time. Sanders outlines every facet of DB2 UDB v8.1 that will be featured on the exams and does so in an in-depth, professional manner that can only come from an expert with four DB2 UDB Version 8 certifications.

Each chapter also features practice exam questions and answers, as well as explanations and breakdowns of every correct answer. There is no better way to prepare for the DB2 UDB V8.1 Certification exams!

If you're a DB2 database administrator and you would like to become IBM DB2 UDB certified, then look no further-this is a must-have companion for anyone wanting to take the 701 or 706 certification exams.

Read More Show Less

Product Details

Table of Contents

Foreword
Preface
Pt. 1 DB2 UDB Certification
Ch. 1 IBM DB2 Universal Database Certification 3
Pt. 2 DB2 UDB Linux, UNIX, and Windows Database Administration
Ch. 2 Server Management 35
Ch. 3 Data Placement 121
Ch. 4 Database Access 171
Ch. 5 Monitoring DB2 Activity 239
Ch. 6 DB2 Utilities 333
Ch. 7 Backup and Recovery 419
App. A DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Exam (Exam 701) Objectives 469
App. B DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Upgrade Exam (Exam 706) Objectives 473
Index 477
Read More Show Less

Introduction

Preface

One of the biggest challenges computer professionals face today is keeping their skill sets current with the latest changes in technology. When the computing industry was in its infancy, it was possible to become an expert in several different areas, because the scope of the field was relatively small. Today, our industry is both widespread and fast paced, and the skills needed to master a single software package can be quite complex. Because of this complexity, many application and hardware vendors have initiated certification programs to evaluate and validate an individual's knowledge of their technology. Businesses benefit from these programs, because professional certification gives them confidence that an individual has the expertise needed to perform a specific job. Computer professionals benefit, because professional certification allows them to deliver high levels of service and technical expertise, and more importantly, professional certification can lead to advancement and/or new job opportunities within the computer industry.

If you've bought this book (or if you are thinking about buying this book), chances are you have already decided you want to acquire one or more of the IBM DB2 Universal Database (UDB) V8.1 Professional Certifications available. As an individual who holds eight IBM DB2 UDB professional certifications, let me assure you that the exams you must pass in order to become a certified DB2 UDB professional are not easy. IBM prides itself on designing comprehensive certification exams that are relevant to the work environment an individual holding a particular certification will have had some exposure to. As a result, allof IBM's certification exams are designed with the following items in mind:

  • What are the critical tasks that must be performed by an individual who holds a particular professional certification?
  • What skills must an individual possess in order to perform each critical task?
  • What is the frequency with which each critical task must be performed?

You will find that to pass a DB2 UDB certification exam, you must possess a solid understanding of DB2 Universal Database (and for some of the more advanced certifications, you must understand many of its nuances as well).

Now for the good news. You are holding in your hands what I consider to be the best tool you can use to prepare for the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification exam (Exam 701) or the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706). When IBM learned that I was planning to write a series of study guides for the DB2 UDB V8.1 certification exams, they invited me to participate in the exam development process. Among other things, I had the opportunity to evaluate several of the beta DB2 UDB V8.1 exams before they went into production. Consequently, I have seen every exam question you are likely to encounter, and I know what concepts you will be tested on when you take the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification exam (Exam 701). (I did not participate in the development of the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706); however, IBM provided me with detailed information on the types of test questions a candidate might encounter when taking that exam.) Using this knowledge, along with copies of the beta 701 exams, I developed this study guide, which not only covers every DB2 UDB concept you must know in order to pass the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification exam (Exam 701) or the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706), but also covers the exam process itself and the requirements for each available DB2 UDB V8.1 certification role. In addition, you will find at the end of each chapter, sample questions that are worded just like the actual exam questions. In short, if you see it in this book, count on seeing it on the exam; if you don't see it in this book, chances are it won't be on the exam.

About This Book

This book is divided into two parts:

Part 1--DB2 UDB Certification (Chapter 1)

This section consists of one chapter (Chapter 1), which is designed to introduce you to the DB2 UDB Professional Certification Program that is available from IBM. In this chapter, you will learn about the different certification roles available, along with the basic prerequisites and requirements for each role. This chapter also explains what's involved in the certification process, and it includes a tutorial on the IBM Certification Exam testing software, which you will encounter when you go to take a DB2 UDB V8.1 certification exam.

Part 2--DB2 UDB Linux, UNIX, and Windows Database Administration (Chapters 2-7)

This section consists of six chapters (Chapters 2 through 7), which are designed to provide you with the concepts you will need to master before you can pass the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification exam (Exam 701) or the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706).

Chapter 2 is designed to introduce you to the various aspects of server management and to the authorization levels and privileges that are supported by DB2 UDB V8.1. In this chapter, you will learn how and where users are authenticated, how authorities and privileges determine what a user can and cannot do while working with a database, and how authorities and privileges are given to and taken away from individual users and/or groups of individual users. You will also learn how to configure client/server connectivity and you will learn how to obtain detailed information that can be used to resolve problems when they occur.

Chapter 3 is designed to provide you with everything you need to know about how data in a DB2 UDB database is physically stored. In this chapter, you will learn how to create a DB2 UDB database and you will see what a DB2 UDB database's underlying structure looks like, as well as how that structure is physically mapped to directories, files, and raw devices. You will also learn how buffer pools and tablespaces are used and you will find out how to obtain information about a database's tablespaces without having to query the system catalog.

Chapter 4 is designed to provide you with everything you need to know about tables, indexes, and views. In this chapter, you will learn how to create tables, indexes, and views, and you will learn when and how NOT NULL constraints, default constraints, check constraints, unique constraints, referential integrity constraints, and informational constraints should be used. You will also learn how to automate routine maintenance operations using the Task Center.

Chapter 5 is designed to introduce you to the various tools that are available for monitoring a database's performance. In this chapter, you will learn how to configure and use the snapshot monitor, event monitors, the Health Center, and the Explain facility. You will also learn how to analyze the information produced by these tools to locate weaknesses in database and/or application design.

Chapter 6 is designed to provide you with everything you need to know about DB2 UDB's data movement and data management utilities. In this chapter, you will learn how to use the Export utility to extract data from a database and store it to an external file and you will learn how to use the Import and Load utilities to move data stored in external files into database tables. You will also learn how to reorganize database tables, update statistics that are used by the DB2 Optimizer, and rebind existing applications once statistics have been updated.

Chapter 7 is designed to introduce you to the concept of database recovery and to the various tools that can be used with DB2 UDB V8.1 to return a damaged or corrupted database to a useable state. In this chapter, you will learn what transaction logging is, how transaction logging is performed, and how log files are used to restore a damaged database. You will also learn how to back up a database using the Backup utility, restore a database using the Restore utility, and reapply transaction records stored in log files by performing a roll-forward recovery operation.

The book is written primarily for IT professionals who have already taken and passed the DB2 UDB V8.1 Family Fundamentals exam (Exam 700) and want to take (and pass) the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification exam (Exam 701). IT professionals who possess DB2 UDB Version 7.2 Database Administration certification and wish to upgrade their certification by taking (and passing) the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706) will also benefit from this book. Additionally, any individual who would like to learn the basics of DB2 UDB V8.1 for Linux, UNIX, and Windows database administration will benefit from the information found in this book.

Conventions Used

Many examples of DB2 UDB administrative commands and SQL statements can be found throughout this book. The following conventions are used whenever a DB2 command or SQL statement is presented:
Parameters or items shown inside of brackets are required and must be provided.
< >
Parameters or items shown inside of angle brackets are optional and do not have to be provided.
Vertical bars are used to indicate that one (and only one) item in the list of items presented can be specified
,…
A comma followed by three periods (ellipsis) indicate that multiple instances of the preceding parameter or item can be included in the DB2 command or SQL statement

The following examples illustrate each of these conventions.

Example 2

CREATE SEQUENCE SequenceName<AS SMALLINT INTEGER BIGINT DECIMAL><START WITH StartingNumber><INCREMENT BY 1 Increment><NO MINVALUE MINVALUE MinValue><NO MAXVALUE MAXVALUE MaxValue><NO CYCLE CYCLE><NO CACHE CACHE 20 CACHE CacheValue><NO ORDER ORDER>

In this example, a SequenceName value must be provided, as indicated by the brackets ( ). However, everything else is optional, as indicated by the angle brackets (< >), and in many cases, a list of available option values is provided (for example, NO CYCLE and CYCLE); however, only one can be specified, as indicated by the vertical bar (). In addition, when some options are provided (for example, START WITH, INCREMENT BY, MINVALUE, MAXVALUE, and CACHE), a corresponding value must be provided, as indicated by the brackets ( ) that follow the option.

SQL is not a case-sensitive language, so even though most of the examples provided are shown in uppercase, they can be entered in any case.

Acknowledgments

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. Jan also provided me with the Foreword for this book.

Melissa Montoya--Certification Program Manager, DB2 Information Management Software, IBM Menlo Park

Melissa provided me with detailed information about the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 706) and she arranged for Hana and Darrin to review the manuscript for clarity and accuracy.

Hana Curtis--Advisory Development Analyst, DB2 Integration, IBM Toronto Lab

Hana did an excellent job of reviewing the manuscript and providing me with feedback. Because of Hana's efforts, some mistakes in the manuscript were corrected or clarified before the book went into production.

Darrin Woodard--DB2 UDB Development, DB2 UDB Release Team, IBM Toronto Lab

Darrin also did an excellent job of reviewing the manuscript and providing me with feedback. Like Hana, Darrin pointed out some mistakes in the manuscript and recommended changes, which were incorporated before the book went into production.

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

Dale McInnis--Sr. Technical Manager, DB2 / LUW Backup, Data Protection and Recovery, IBM Toronto Lab

Dale provided me with detailed information on how DB2 UDB performs transaction logging and he reviewed the sections on transaction logging in Chapter 7 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.

About the Author

Roger E. Sanders is a Database Performance Engineer with Network Appliance, Inc. He has been designing and developing database applications for more than 18 years, and he has worked with DB2 Universal Database and its predecessors since it was first introduced on the IBM PC (as part of OS/2 Extended Edition). He has written several articles for publications such as DB2 Magazine and IDUG Solutions Journal, authored a tutorial titled "Database Concurrency: DB2 Version 8.1 Family Fundamentals Certification Preparation" for IBM's DeveloperWorks Web site, presented at three International DB2 User's Group (IDUG) conferences, and is the author of the following books:

  • DB2 UDB V8.1 Certification Exam 700 Study Guide
  • DB2 UDB Exploitation of NAS Technology (IBM RedBook; coauthor)
  • All-In-One DB2 Administration Exam Guide
  • DB2 Universal Database SQL Developer's Guide
  • DB2 Universal Database API Developer's Guide
  • DB2 Universal Database Call Level Interface Developer's Guide
  • ODBC 3.5 Developer's Guide
  • The Developer's Handbook to DB2 for Common Servers
  • In addition, Roger holds the following profess certifications:
  • IBM Certified Advanced Database Administrator--DB2 Universal Database V8.1 for Linux, UNIX, and Windows
  • IBM Certified Database Administrator--DB2 Universal Database V8.1 for Linux, UNIX, and Windows
  • IBM Certified Developer--DB2 Universal Database V8.1 Family
  • IBM Certified Database Associate--DB2 Universal Database V8.1 Family
  • IBM Certified Advanced Technical Expert--DB2 for Clusters
  • IBM Certified Solutions Expert--DB2 UDB V7.1 Database Administration for UNIX, Windows, and OS/2
  • IBM Certified Solutions Expert--DB2 UDB V6.1 Application Development for UNIX, Windows, and OS/2
  • IBM Certified Specialist--DB2 UDB V6/V7 User
Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted June 18, 2004

    You must do the problems

    In the world of large commercial databases, there are really only two choices: IBM's dB2 and Oracle. While MySQL and Postgres are increasingly try to break up this cosy duopoly, they are still small players. So as a professional DBA, or an aspiring one, dB2 is a good choice. Given this, IBM provides several levels of certification. Sanders here supplies the official study guide for the 701 and 706 exams. Thumbing through this book, you see lots of SQL commands. But a lot of the SQL appears to be syntax specific to managing dB2. A dB2 programmer/user can largely deal with generic SQL. But for you, that's not enough. The value of this book is heavily in the specifics of dB2 and how to optimise its performance. The questions and answers in each chapter are at least as important as the text. If you are at all serious, you MUST tackle these. Otherwise, you've just discarded half the value of the book. Of course, the actual questions in the exams will differ. But by being able to do the book's problems, it forces you to clarify your understanding. My own SQL background is mostly with MySQL. So most of this book is new to me. I tried a couple of chapters and their problem sets. Not bad. The problems are not trivial. But the volume of material in each chapter is succinct enough to be doable in a few hours.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted March 16, 2004

    Excellent Certifications Study Guide

    If you are serious in moving through the DB2 certifications, you will find the book to be a helpful addition to your library. I certainly wish I had this reference when I was studying for the certification exams. The book opens with a detailed roadmap on DB2 certification that explains the various tracks. It also has a good explanation of how to register for tests and how the tests work. Understanding how the tests work can save you valuable time on test day. The book is arranged around the test sections, which seems like a good way to study for the tests. A certification study guide could easily be dry, but Roger's good use of white space, pictures and diagrams help keep the book easy to read. The questions in the book seem so close to the real thing, that you may think you are taking the exam.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)