| Fifteen percent (15%) of the DB2 UDB V8.1 Family Fundamentals certification exam (Exam 700) is designed to test your ability to recognize which of the DB2 Universal Database Family products available must be installed to create a desired environment/configuration and to test your knowledge of the various tools that are provided with DB2 UDB. The questions that make up this portion of the exam are intended to evaluate the following: -
Your ability to identify the DB2 UDB products that make up the DB2 UDB Family. -
Your knowledge of the different DB2 clients available. -
Your knowledge of the nonrelational data concepts that are managed by the DB2 extenders. -
Your knowledge of data warehousing and OLTP concepts. This chapter is designed to introduce you to the various products that make up the DB2 UDB Family and to the comprehensive set of tools that are provided to assist in administering and managing DB2 UDB instances, databases, and database objects. Terms you will learn: DB2 Universal Database Family DB2 Everyplace Database Edition DB2 Everyplace Enterprise Edition DB2 Personal Edition DB2 Workgroup Server Edition DB2 Workgroup Server Unlimited Edition DB2 Enterprise Server Edition Database Partitioning DB2 Personal Developer's Edition DB2 Universal Developer's Edition DB2 Run-Time Client DB2 Administration Client DB2 Application Development Client DB2 Connect Personal Edition DB2 Connect Enterprise Edition DB2 Relational Connect DB2 AVI Extender DB2 Text Extender DB2 Net Search Extender DB2 XML Extender DB2 Spatial Extender DB2 Data Links Manager DB2 Warehouse Manager Query, Loading, Extraction, Transformation Data Warehouse Center Information Catalog Manager Query Patroller Query Management Facility (QMF) DB2 OLAP Server Control Center Replication Center Satellite Administration Center Command Center SQL Assist Visual Explain Task Center Information Catalog Center Health Center Journal License Center Development Center Information Center Command Line Processor Configuration Assistant Techniques you will master: Understanding the core components of the DB2 Universal Database Family. Recognizing the differences between each edition of DB2 Universal Database. Recognizing the types of DB2 UDB clients available and understanding when each is used. Understanding what DB2 UDB extenders are available, along with what functionality each extender provides. Understanding Data Warehouse and OLAP concepts. Understanding what types of tools are available, along with what actions each tool has been designed to perform. | 