PART I DB2 Certification
Chapter 1 DB2 Universal Database Professional Certification
The Professional Certification Pro.am from ]-BM
DB2 Universal Database CerQfication Roles.
IBM Certified Specialist -- DB2 UDB V6/V7 User
IBM Certified Solutions Expert -- Business Intelligence
IBM Certified Solutions Expert -- DB2 UDB V7.1 Database
Administration for UNIX, Windows, and OS/2
IBM Certified Solutions Expert -- DB2 UDB V7.1
Family Application Development.
IBM Certified Solutions Expert -- DB2 UDB V7.1
Database Administration for OS/390
IBM Certified Advanced Technical Expert -- DB2 for Clusters
IBM Certified Advanced Technical Expert -- DB2 -- DRDA
IBM Certified Advanced Technical Expert -- DB2 Data Replication
The Certification Process
Preparing for the Tests
The Testing Procedure
Benefits Professional Certification Provides
Summary
PART II DB2 UDB Fundamentals (Tests 509 and 512)
Chapter 2 Installation and Planning
The DB2 Universal Database Family
DB2 Universal Database Products
DB2 Universal Database Clients
Other DB2 Universal Database Products
DB2 Universal Database Packages
DB2's Administration Tools
The Control Center.
The Command Center
The Script Center
The Alert Center
The Journal
The Command Line Processor (CLP)
The Performance Monitor
The Client Configuration Assistant (CCA)
Summary. ~
Questions
Answers
Chapter 3 Instances and Security
Instances
The DB2 Administration Server (DAS) Instance.
Controlling Database Access
Authentication
Authorities
Privileges.
Granting and Revoking Authorities and Privileges.
Summary
Questions.
Answers
Chapter 4 Creating and Accessing DB2 Databases and DB2 Database Objects.
The Relational Database Model.
What Is a DB2 Universal Database Database?
Creating a DB2 Universal Database Database
Destroying a DB2 Universal Database Database
The DB2 Universal Database Dkectory Files
Uncataloging a DB2 Universal Database Database
Cataloging a DB2 Universal Database Database
Understanding Objects
System Objects
Recovery Objects
Storage Objects.
Database (or Data) Objects
Summary.
Questions
Answers
Chapter 5 Creating Table Objects
Understanding Data Types
Small Integer
Integer
Big Integer
Decimal
Single-Precision Floating Point
Double-Precision Floating Point
Fixed-Length Character String
Varying-Length Character String
Varying-Length Long Character String
Fixed-Length Double-Byte Character String
Varying-Length Double-Byte Character String
Varying-Length Double-Byte Long Character String
Date
Time
Timestamp
Binary Large Object ,
Character Large Object
Double-Byte Character Large Object
DataLink
User-Defined Data Types (UDTs)
Extenders
Understanding Constraints
The NOT NULL Constraint
The Column Default Constraint
Unique Constraints
Referential Constraints
Check Constraints
The CREATE TABLE SQL Statement
CREATE TABLE SQL Statement Examples and Resulting Table Characteristics
System Catalog Tables
Summary.
Questions .
Answers
Chapter 6 Basic SQL
Structured Query Language (SQL)
Data Definition Language (DDL) Statements
Creating Nodegroups -- The CREATE NODEGROUP Statement
Creating Buffer Pools -- The CREATE BUFFERPOOL Statement
Creating Table Spaces -- The CREATE TABLESPACE Statement
Creating Tables -- The CREATE TABLE Statement
Creating Views -- The CREATE VIEW Statement
Creating Indexes -- The CREATE INDEX Statement
Creating Schemas -- The CREATE SCHEMA Statement
Creating Aliases -- The CREATE ALIAS Statement
Describing an Object -- The COMMENT ON Statement
Dropping an Object -- The DROP Statement
Modifying Object Definitions
Data Manipulation Language (DML) Statements
Retrieving Data -- The SELECT Statement and Its Clauses
Adding Data -- The INSERT Statement
Changing Data- The UPDATE Statement
Deleting Data -- The DELETE Statement
Summary
Questions
Answers
Chapter 7 Database Concurrency
What Is Data Consistency?
Transactions
Concurrency an"d Isolation Levels
Repeatable Read
Read Stability
Cursor Stability
Uncommitted Read
Specifying the Isolation Level
Choosing the Proper Isolation Level
Locking
Lock Attributes and Lock States
Lock Compatibility
Lock Conversion
Lock Escalation
Deadlocks
Lock Waits and Timeouts
How Locks Are Acquired
Factors That Affect Locking
Summary
Questions
Answers
PART III DB2 UDB Administration(Tests 513)
Chapter 8 Server Management
Instances
Attaching to an Instance
Detaching from an Instance
The DB2 Administration Server (DAS) Instance
Distributed Connections
Configuring Communications
DB2 Discovery
Controlling Database Access -- Revisited
Authentication
A Word about Users and Groups
Authorities
Privileges
Granting and Revoking Authorities and Privileges
Taking Control of a Server to Perform Maintenance Operations
Scheduling Maintenance with the Journal
Summary
Questions
Answers
Chapter 9 Data Placement
Creating a DB2 Universal Database Database -- AReview
The DB2 Universal Database Storage Model
Buffer Pools
Table Spaces
Containers
Basic Buffer Pool and Table Space Requirements
Characteristics That Affect Table Space Performance
Page Size
Extent Size
Prefetch Size
Obtaining Information about Existing Table Spaces
Table Space States
Obtaining Information about Table Space Containers
Altering an Existing Table Space
Summary, ,,
Questions
Answers
Chapter 10 Data Access
Tables -- A Review
Views
Types of Views
Imposing Restrictions on Views with the WITH CHECK OPTION clause
Indexes and Constraints
Indexes -- A Review
Understanding Constraints
Unique (and Nonunique) Indexes
Referential Constraints Revisited
Examples of Referential Constraints
Improving Performance with a Clustering Index
System Catalog Tables and Views
Using the Script Center
An Alternative Method for Viewing Information Stored in Tables and Views
Reverse-Engineering a Database with DB2LOOK
Expanding a Database's Boundaries with Federated Systems
Summary
Questions
Answers
Chapter 11 Monitoring Database Activity
The Database System Monitor
The Snapshot Monitor
Event Monitors
The Performance Monitor
Starting, Stopping, and Viewing the Performance Monitor
Sending Messages to the Journal
A Word about the Query Patroller Tracker
Monitoring SQL Behavior
The Explain Facility
Configuring Database and Database Manager Resources
Viewing the DB2 Database Manager's Configuration
Viewing a Database's Configuration
Changing the Value of a DB2 Database Manager Configuration Parameter
Changing the Value of a Database's Configuration Parameter
Changing the Value of a DB2 Registry or Environment Variable
Summary
Questions
Answers
Chapter 12 DB2 Universal Database's Data Movement and
Data Management Utilities
DB2 Universal Database's Data Movement Utilities
Supported File Formats
Obtaining Columnar Data from External Files
The Export Utility
The Import Utility
The Load Utility
The DB2MOVE Utility
DB2 Universal Database's Data Maintenance Utilities
The Reorganize Check Utility
The Reorganize Table Utility
The Run Statistics Utility
Summary
Questions
Answers
Chapter 13 Database Recovery and Maintenance
Transaction Logging
Circular Logging
Archival Logging
Returning a Database to a Consistent State
Managing Database Recovery
Creating a Backup Image of a Database
The Recovery History File
Restoring a Database (or a Table Space) from a Backup Image
Roll-Forward Recovery
Rebuilding Invalid Indexes
Configuration Parameters That Affect Logging and Data Recovery
Summary
Questions
Answers
Chapter 14 Problem Determination
Common Types of Errors
Error Codes
Viewing Error Messages
First Failure Data Capture (FFDC) Information
The db2diaglog File
Interpreting db2diaglog Entry Headers
Interpreting SQLCA Data Structure Value Entries
Interpreting Hexadecimal Codes
Locating Failed Objects
An Example Scenario
Summary
Questions
Answers
Appendix A System Catalog Views
Appendix B Bibliography
鄂公网安备 42010302001612号 