DB2 (R) Universal Database V8.1 Certification Exams 701 and 706 Study Guide
Published on 24. December 2003
Book
Paperback/Softback
512 pages
978-0-13-184048-5 (ISBN)
Description
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.
More details
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 229 mm
Width: 154 mm
Thickness: 36 mm
Weight
806 gr
ISBN-13
978-0-13-184048-5 (9780131840485)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
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.
Content
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.
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.