Always Learning

Advanced Search

DB2 Universal Database V8.1 Certification Exams 701 and 706 Study Guide

DB2 Universal Database V8.1 Certification Exams 701 and 706 Study Guide


Dec 2003, Paperback, 512 pages
ISBN13: 9780131840485
ISBN10: 0131840487
This title is no longer available.
  • Print pagePrint page
  • Email this pageEmail page
  • Write a reviewWrite a review
  • Share

This book covers the second "Fundamentals" exam (test 701) an individual needs to pass in order to become an IBM Certified Database Adminstrator. Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8.1 Certification Exam development team and reviewed by the IBM Data Management Certification Program Manager, this book is guaranteed to provide the reader with all of the information needed to pass the V8.1 Certification test 701. Exam-like questions and answers are provided at the end of each chapter and information explaining why each answer provided is correct accompanies every answer given. This is a must-have for any DBA taking the second certification exam.An estimated 20,000 people take this certification exam annually in the US.

The official in-depth guide to passing IBM's DB2 Universal Database Version 8.1 Certification Exams 701 and 706

Over 20,000 people test to become IBM Certified Database Administrators every year. Some will pass, many will not. This book is IBM's official companion to mastering the skills that you need to ensure that you pass Certification Exams 701 and 706.

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.



Foreword.


Preface.

I. DB2 UDB CERTIFICATION.

1. IBM DB2 Universal Database Certification.
DB2 Universal Database Certification Roles. IBM Certified Database Associate-DB2 Universal Database V8.1 Family. IBM Certified Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows. IBM Certified Database Administrator-DB2 Universal Database V8.1 for z/OS and OS/390. IBM Certified Application Developer-DB2 Universal Database V8.1 Family. IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows. IBM Certified Solution Designer-Business Intelligence V8.1. The Certification Process. Preparing for the Certification Exams. Arranging to Take a Certification Exam. Taking an IBM Certification Exam.

II. DB2 UDB Linux, UNIX, and Windows Database Administration.

2. Server Management.
Instances. Attaching to an Instance. Detaching from an Instance. The DB2 Administration Server (DAS). Distributed Connections and Communications. Configuring Communications. The DB2COMM Registry Variable. DB2 Discovery. Controlling Database Access. Authentication. Where Does Authentication Take Place? Trusted Clients versus Untrusted Clients. Authorities and Privileges. Authorities. Privileges. Requirements for Granting and Revoking Authorities and Privileges. Granting Authorities and Privileges. Granting and Revoking Authorities and Privileges from the Control Center. Granting Authorities and Privileges with the GRANT SQL Statement. Revoking Authorities and Privileges with the REVOKE SQL Statement. Authorities and Privileges Needed to Perform Common Tasks. Taking Control of a Server. Finding Out Who is Using an Instance or a Database. The FORCE APPLICATION Command. The QUIESCE and UNQUIESCE Commands. Using the Task Center. A Word about the Journa. Problem Determination. Obtaining Information about an Error Code. First Failure Data Capture (FFDC). Practice Questions. Answers. 3. Data Placement.
Instances and Databases. DB2 UDB Objects. System Objects. Recovery Objects. Storage Objects. Database (or Data) Objects. Creating a DB2 UDB Database with the CREATE DATABASE Command. What Happens When a DB2 UDB Database is Created. The CREATE DATABASE Command. Creating a DB2 UDB Database with the Create Database Wizard. The Configuration Advisor. Creating Additional Storage Objects. Creating Buffer Pools. Modifying Existing Buffer Pools. Creating Tablespaces. Modifying Existing Tablespaces. Tables. A Word about Schemas154 Obtaining Information About Existing Tablespaces. Obtaining Information about the Containers Used by a Tablespace. Practice Questions. Answers. 4. Database Access.
Tables. Constraints. NOT NULL Constraints. Default Constraints. Check Constraints. Unique Constraints. Referential Integrity Constraints. Informational Constraints. Temporarily Suspending Constraint Checking with the SET INTEGRITY SQL Statement. Creating Tables. Identity Columns. Creating Tables That Are Similar to Existing Tables. A Word about Declared Temporary Tables. CREATE TABLE SQL Statement Examples. Indexes. Clustering Indexes. Multidimensional Clustering (MDC) Table Indexes. Type-1 and Type-2 Indexes. Views. The Task Center (Revisited). Practice Questions. Answers. 5. Monitoring DB2 Activity.
Configuring the DB2 System Environment. Configuring Instances and Databases. The DB2 Database Manager Instance Configuration. Database Configurations. The Database System Monitor. The Snapshot Monitor. Event Monitors. The Health Monitor and the Health Center. Monitoring SQL with the Explain Facility. The Explain Tables. Collecting Explain Data. Evaluating Explain Data. Managing SQL Statement Execution with the DB2 Governor and the DB2 Query Patroller. The DB2 Governor. The DB2 Query Patroller. Practice Questions. Answers. 6. DB2 Utilities.
DB2 UDB's Data Movement Utilities and the File Formats. They Support. Delimited ASCII (DEL). Non-Delimited ASCII (ASC). Worksheet Format (WSF). PC Integrated Exchange Format (IXF). Extracting Columnar Data from External Files. The DB2 UDB EXPORT Utility. The DB2 UDB IMPORT Utility. The DB2 UDB LOAD Utility. db2move and db2look. Data Maintenance Utilities. The REORGCHK Utility. The REORG Utility. The INSPECT Utility. The RUNSTATS Utility. The Design Advisor. Practice Questions. Answers. 7. Backup and Recovery.
Transactions. Transaction Logging. Logging Strategies. Database Recovery Concepts. Crash Recovery. Version Recovery. Roll-Forward Recovery. Recoverable and Non-recoverable Databases. Online versus Offline Backup and Recovery. Incremental Backup and Recovery. Performing a Crash Recovery Operation. A Word about Soft Checkpoints. Backup and Recovery. The DB2 UDB BACKUP Utility. The Recovery History File. The DB2 UDB RESTORE Utility. The DB2 UDB ROLLFORWARD Utility. Rebuilding Invalid Indexes. Backing Up a Database with Split Mirroring. Initializing a Split Mirror with db2inidb. Practice Questions. Answers. Appendix A: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Exam (Exam 701) Objectives.
DB2 Server Management (19%). Data Placement (17%). Data Access (17%). Monitoring DB2 Activity (16%). DB2 Utilities (17%). Backup and Recovery (14%). Appendix B: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Upgrade Exam (Exam 706) Objectives.
DB2 Server Management (20%). Data Placement (13%). Data Access (13%). Monitoring DB2 Activity (14%). DB2 Utilities (23%). Backup and Recovery (17%). Index.

ROGER E. SANDERS, Database Performance Engineer with NetworkAppliance, Inc., is author of seven books on DB2 Universal Database,including DB2 Universal Database V8.1 Certification Exam 700 Study Guide. He hasworked with DB2 for more than 15 years and holds eight IBM DB2certifications, including IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1, IBM Certified Application Developer-DB2 Universal Database V8.1, and IBM Certified Advanced Technical Expert (DB2 for Clusters). He also speaks at the International DB2 User's Group (IDUG) and Regional User Group (RUG) conferences and is a regular contributor to DB2 Magazine.