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.