Product Details

• Amazon Sales Rank: #2125925 in Books
• Published on: 1998-09-10
• Original language: English
• Number of items: 1
• Binding: Paperback
• 544 pages

From the Inside Flap
Preface

This book is a complete guide to IBM's DB2 Universal Database Enterprise-Extended Edition. DB2 Universal Database (UDB) Enterprise-Extended Edition (EEE) is available on AIX, Windows NT, and Sun Solaris. This book, however, was written from a UNIX, specifically AIX operating system perspective. There may be some differences in the implementation of the DB2 UDB EEE product on these operating systems, but since they are not part of the certification testing for the IBM UDB for Cluster Exam, they are not covered in this publication. If you would like to become a Certified IBM Advanced Technical Expert on DB2 Universal Database V5, or you would simply like to understand the powerful DB2 UDB EEE product, then read on.
This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following: This guide helps you prepare for one of the tests in the the IBM Certified Advanced Technical Expert - DB2 Universal Database V5 program. The path to this level of certification involves the following:

Figure 1.

Figure 1. The Path to Certification To become an IBM Certified Advanced Technical Expert - DB2 Universal Database V5, you must do the following: To become an IBM Certified Advanced Technical Expert - DB2 Universal Database V5, you must do the following: 1.

1. Be either an IBM Certified Solutions Expert - DB2 UDB V5 Database Administrator or an IBM Certified Solutions Expert - DB2 UDB V5 Application Developer. To possess either of the IBM Certified Solutions Expert levels, you must have successfully passed: To possess either of the IBM Certified Solutions Expert levels, you must have successfully passed: 1.

1. DB2 UDB V5 Fundamentals Exam (503) DB2 UDB V5 Fundamentals Exam (503) 2.

2. One or both of the following: One or both of the following: ¥¥

DB2 UDB V5 Database Administration Exam (504) DB2 UDB V5 Database Administration Exam (504) ¥¥

DB2 UDB V5 Application Development Exam (505) DB2 UDB V5 Application Development Exam (505) 4.

4. Pass any two of the following three advanced exams: Pass any two of the following three advanced exams: 5.

5. DB2 UDB for Cluster Exam (506) DB2 UDB for Cluster Exam (506) 6.

6. IBM DRDA Exam (507) IBM DRDA Exam (507) 7.

7. IBM Data Replication Exam (508) Those interested in taking the DB2 Universal Database V5 for Cluster Exam (506) should review the sample questions found in Appendix A, ÒTest Objectives and Sample QuestionsÓ on page 495. This test is one of the three advanced tests; passing any two of these tests along with the pre-requisites will give you the Advanced Technical Expert - DB2 Universal Database V5 certification. As this guide is a follow-on to the existing DB2 Universal Database Certification Guide, for the most part, the information contained in that publication is not repeated in this guide. The book is divided into the following areas: The book is divided into the following areas: ¥¥

Overview - This chapter is a short introduction to the DB2 UDB Enterprise-Extended Edition product. It covers some features and functions and some of the terminology and conventions used throughout the book. Overview - This chapter is a short introduction to the DB2 UDB Enterprise-Extended Edition product. It covers some features and functions and some of the terminology and conventions used throughout the book. ¥¥

Installation and Configuration - A partitioned database requires some specialized hardware setup and configuration. As such, there are numerous ways that the product can be installed and configured. This is explained in chapter two. Installation and Configuration - A partitioned database requires some specialized hardware setup and configuration. As such, there are numerous ways that the product can be installed and configured. This is explained in chapter two. ¥¥

Designing and Implementing a Database - When dealing with gigabytes or even terabytes of data, you need optimal logical and physical data placement. This chapter takes you through each logical step, explaining the relationship between the objects, followed by sections that help you to perform the activity with detail on the commands used. . ¥¥

Loading Data - Chapter four discusses the methods available to get data into your cluster database, with discussion on each method so that you can choose the opimal method for your environment. Step by step detail is provided. Loading Data - Chapter four discusses the methods available to get data into your cluster database, with discussion on each method so that you can choose the opimal method for your environment. Step by step detail is provided. ¥¥

Managing Data - This chapter covers activities that the database administrator must know. For example, there is a very detailed section covering what to do when your hardware configuration changes and how to rebalance your data. Also, how to efficiently back up and restore data is discussed. back up and restore data is discussed. ¥¥

Performance Tuning and Problem Determination - These chapters look at the tuning parameters in a cluster environment. For complex queries, you need to understand what is happening during the execution of that query. The output from the explain facilities is detailed so that you not only understand what is happening during execution, but you can also learn how to influence the optimizer to improve performance. How This Book was Created This book was a joint effort between the Austin ITSO (International Technical Support Organization) and the IBM Toronto Lab. The ITSO is a group within IBM whose mission is to provide skill transfer on new products and emerging technology on a worldwide basis. We provide direct feedback to the IBM software labs as we gather input from various groups of DB2 users, including IBM support personnel, customers and business partners. The ITSO provides a working envionment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. Each team develops a workshop or book, known as a redbook. The ITSO provides a working envionment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. Each team develops a workshop or book, known as a redbook. The ITSO provides a working envionment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. Each team develops a workshop or book, known as a redbook.

The DB2 Universal Database Enterprise-Edition Certification Guide was produced by many people from all over the world. The DB2 Universal Database Enterprise-Edition Certification Guide was produced by many people from all over the world. Figure 2.

Figure 2. The Austin Team Calene Janacek is the DB2 Project Leader for the International Technical Support Organization (ITSO) in Austin, Texas. She has been with IBM since 1989, working for the ITSO since 1993. Calene is responsible for producing technical manuals called "redbooks" that are used worldwide by support personnel and customers. She also develops workshops for new releases of DB2 that she teaches worldwide. She has presented at DB2 and AIX technical conferences. Jonathan Cook is an Advisory Software Engineer at the International Technical Support Organization (ITSO), Austin Center. He has ten years of experience as a database specialist working in the areas of application development and database administration. He has been with IBM since 1992, working

From the Back Cover

CD-ROM Included!

Make DB2 UDB EEE work for you!

Practical planning, design, installation, configuration and management techniques — straight from IBM!

Sample exercises prepare you for IBM's DB2 Certification Course #506: IBM DB2 UDB for Cluster.

International Technical Support Organization.

IBM's DB2 Universal Database Enterprise-Extended Edition (DB2 UDB EEE) is the world's most powerful, scalable, flexible database: simply the best solution for today's gigantic databases, fast queries and business-critical decision support applications. Now, straight from IBM, there's a systematic, hands-on guide to making DB2 UDB EEE work for you: The DB2 Cluster Certification Guide.

This book brings together all the techniques you need to deploy, manage and optimize DB2 UDB EEE — and if you're pursuing IBM DB2 certification, it's a great guide to passing the DB2 UDB for Cluster Exam (506). Master all this, and more:

• Planning, installation, configuration, database design and implementation.
• Loading and splitting data; using the LOAD and AutoLoader utilities.
• Partitioned databases, nodegroups, table spaces and tables.
• Practical data management: rebalancing, redistributing, backup and recovery.
• Performance/tuning: Join strategies, OLAP features, EXPLAIN tools, monitoring and more.
• DB2 Control Center, Client Configuration Assistant and Command Line Processor.

You'll find practical deployment scenarios, a full chapter on problem determination and error logs, and a complete DB2 UDB for Cluster sample exam. Whether you're a DBA, developer, network administrator or manager, if you want to get the most out of DB2 UDB EEE, get The DB2 Cluster Certification Guide.

About the Author

JONATHAN COOK is an Advisory Software Engineer at IBM's ITSO in Austin, Texas. He has ten years of database experience, and teaches IBM DB2 classes worldwide.

CALENE JANACEK is DB2 Project Leader for IBM's ITSO in Austin, Texas, and co-author of the DB2 Universal Database Certification Guide.

DWAINE SNOW has eight years of experience designing applications for DB2 and its predecessors. He coordinates IBM's DB2 UDB certification and education program.

Customer Reviews

A must buy book about DB2 Clusters
There are no other books on the market quite like this one. Although geared towards DB2 Cluster Certification this book also offers the reader a lot of readable informatiuon on setting up a clustered DB2 enviroment.

It is very well laid out and an easy read. It expects a certain amount of understanding of DB2 UDB already, however, there is a lot of detailed information as and when required to help you along.

No serious DB2 Developer/DBA/Consultant should be without this book if they wish to understand how DB2 EEE works and can be configured.

I have just about every DB2 book published and am happy to answer any questions you may have about Certification or the books I have reviewed. Please feel free to e-mail me.

It's not all there......
After pouring over the book, and practicing the test questions over and over, I still did not pass the certification. I found that a great number of the questions asked during the certification were NOT covered in the book. The sample questions did not address the many SQL and EXPLAIN questions on the certification exam. It would be nice to not only have the answers to the sample questions, but also the "why is this the correct answer" information as well. Since this book was written with the knowledge of IBM, why didn't the authors provide a representative sample of ALL of the certification test questions, instead of just a few? The certification test is broken into several groups. While the book identifies these sections, it does not organize the questions in the same fashion.

The book appears to be a rehash of the IBM EEE class that is still being taught today. Also, the current level of DB2 is 7.2, the book is written to version 5.

On the plus side, it is the only book for DB2 EEE certification.

Good reference material. BUT...
This is a useful reference manual. However, it doesn't appear to be as tailored to the cluster exams as it might claim.

Also -- and more painfully, IMO -- this book STILL uses concepts as of version 5. It's 2002 and the book hasn't been updated from 1998 principles. That's an eternity in this business! Nevertheless, many of the same concepts apply, but it is still in desperate need of a revision to include UDB V7.