- Shopping Bag ( 0 items )
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 ...
Ships from: austin, TX
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
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.
|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|
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:
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.
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.
The following examples illustrate each of these conventions.
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.
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.
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:
Posted June 18, 2004
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted March 16, 2004
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.