DB2 Cluster Certification Guide, The - Softcover

Cook, Jonathan; Janacek, Calene; Snow, Dwaine; International Business Machines Corporation

Softcover

ISBN 10: 013081900X ISBN 13: 9780130819000

Publisher: Prentice Hall, 1998

Synopsis

A preparatory guide to exam 506 of the IBM Certified Advanced Technical Expert-DB2 Universal Database (UDB) V5 Program which covers the DB2 UDB Enterprise-Extended Edition. After a brief overview of DB2 UDB, the authors examine installation and configuration, designing and implementing a database, loading and managing data, and performance tuning and problem determination. Annotation c. by Book News, Inc., Portland, Or.

About this title

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 this edition

• Publisher: Prentice Hall
• Publication date: 1998
• ISBN 10: 013081900X
• ISBN 13: 9780130819000
• Binding: Paperback
• Edition number: 1
• Number of pages: 513