The DB2 Cluster Certification Guide

Read an Excerpt

PREFACE: 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 UniversalDatabase 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 in both the United Kingdom and France before joining the Austin ITSO. He writes extensively and teaches IBM classes worldwide on DB2 for the UNIX and Intel platforms. Dwaine Snow has worked with DB2 Universal Database and its predecessors for the past 8 years. During this time, he has written and designed applications using DB2. He has also worked in the DB2 UDB Customer Service Team. Dwaine is currently the DB2 UDB Certification and Education coordinator. In this role, he is responsible for the DB2 Universal Database certification program and tests, as well as the availability of IBM courses required to develop DB2 UDB expertise. Dwaine has written a number of DB2-related articles and has contributed to a number of DB2 redbooks. He has presented at DB2 conferences and has taught DB2 UDB courses worldwide. Diane DeVere Bullock has been a database administrator since 1986 working with DB2 and IMS. Diane currently provides database administration support to IBMÕs internal marketing database which consists of an on-line client/server configuration and a data warehouse that span 7 RISC AS/400Õs; the database appoximately 1 terabyte in size. Diane also provides consulting services in the areas of cross platform data replication and database tuning. Eduardo Fontana is a Data Management Pre-Sales Technical Specialist who works for the Software Group in IBM Argentina. He has extensive experience of AIX, HACMP, RS/6000 SP, DB2 and Intel Operating Systems. Frank Jeppesen is a Systems Engineer who works for IBM Denmark. Included in his responsibilities, is customer support on the DB2 products. Luis Reina Julia works for IBM Global Services in Spain. He is an IBM Certified DB2 Specialist. He has been working with DB2 and data warehousing products for customers in Spain. George Latimer is a Senior Availability Services Specialist who works for IBM Global Services based in Charlottesville, Virginia. His areas of speciality are ADSM, RS/6000 SP, DB2 and HACMP. Clarence Sham has been working with DB2 products for ten years. After joining IBM in 1997 as an Advisory I/T Specialist, Clarence became a technical sales support for the Software Brand team in Hong Kong with responsibility for the Data Management products. Clarence gives technical presentations and product demos for customers in Hong Kong and China. Tetsuya Shirai is an I/T specialist at IBM Japan. He has been been with IBM for six years, working the past two years with the DB2 products. Shirai-san works in the area of services with DB2, teaching classes to both customers and IBMers. He also provides consultanting services to DB2 customers worldwide. He is fluent in Japanese, Spanish, and English. Guillermo F Unger joined IBM Argentina in 1988 where he has been involved with DB2 for MVS, VM, VSE, OS/400, OS/2, NT and AIX. He is a certified DB2 specialist and has also co-authored redbooks on DRDA and Visualizer connectivity. He currently does DB2 technical support for Latin America South. Fernando Ventura works for an IBM Business Partner in Buenos Aires Argentina. He has been supporting DB2 products for the last five years. The following people were invaluable for their technical expertise and moral support: Catherine Cook IBM France Bob Harbus IBM Toronto Lab Dale McInnis IBM Toronto Lab David L. Gray Advanced Micro Devices, Austin, TX A special thanks goes to the staff at the IBM Teraplex Center in Poughkeepsie, without whose help this project would never have been completed: Joe Labriola, Joe Catucci, Gus Branish, Kurt Sulzbach and Paul Bildzok.

Read More