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.
