书籍详情
DB2数据库管理考试指南（英文影印版）
作者：（美）Roger E. Sanders
出版社：McGraw-Hill
出版时间：2003-01-01
ISBN：9787505382787
定价：¥59.00
购买这本书可以去
内容简介
本书主要介绍了与DB2数据库管理认证考试相关的基本概念及最新的考试信息。全书共分为三个部分，首先简介了DB2认证考试的有关内容，包括认证工具、考试过程等；并且复习了DB2 UDB的基础知识，以及数据库的具体实现和操作；书中重点讲解了DB2 UDB管理，其中的服务器管理、数据存储和访问、数据查询、安全管理等都是考试中的关键内容。本书的每一章都包含了精心设计的大量练习，并且有贯穿全书的测试提示，为应试者提供极具价值的指导与参考。本书是一本全面、权威的考试用书，适用于DB2管理认证考试的备考者及相关的技术人员使用。
作者简介
暂缺《DB2数据库管理考试指南（英文影印版）》作者简介
目录
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
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
猜您喜欢
