DB2数据库管理考试指南 英文版【2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载】

DB2数据库管理考试指南 英文版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

PART Ⅰ DB2 Certification1

Chapter 1 DB2 Universal Database Professional Certification3

The Professional Certification Program from IBM3

DB2 Universal Database Certification Roles4

IBM Certified Specialist—DB2 UDB V6/V7 User5

IBM Certified Solutions Expert—Business Intelligence6

IBM Certified Solutions Expert—DB2 UDB V7.1 Database Administration for UNIX,Windows,and OS/26

IBM Certified Solutions Expert—DB2 UDB V7.1 Family Application Development7

IBM Certified Solutions Expert—DB2 UDB V7.1 Database Administration for OS/3908

IBM Certified Advanced Technical Expert—DB2 for Clusters9

IBM Certified Advanced Technical Expert—DB2—DRDA10

IBM Certified Advanced Technical Expert—DB2 Data Replication11

The Certification Process11

Preparing for the Tests12

The Testing Procedure13

Benefits Professional Certification Provides15

Summary16

PART Ⅱ DB2 UDB Fundamentals(Tests 509 and 512)17

Chapter 2 Installation and Planning19

The DB2 Universal Database Family19

DB2 Universal Database Products20

DB2 Universal Database Clients26

Other DB2 Universal Database Products27

DB2 Universal Database Packages34

DB2's Administration Tools36

The Control Center36

The Command Center38

The Script Center41

The Alert Center42

The Journal42

The Command Line Processor(CLP)43

The Performance Monitor44

Summary45

The Client Configuration Assistant(CCA)45

Questions47

Answers48

Chapter 3 Instances and Security50

Instances50

The DB2 Administration Server(DAS)Instance52

Controlling Database Access53

Authentication54

Authorities55

Privileges59

Granting and Revoking Authorities and Privileges65

Summary67

Questions69

Answers71

Chapter 4 Creating and Accessing DB2 Databases and DB2 Database Objects72

What Is a DB2 Universal Database Database?73

The Relational Database Model73

Creating a DB2 Universal Database Database75

Destroying a DB2 Universal Database Database79

The DB2 Universal Database Directory Files80

Uncataloging a DB2 Universal Database Database81

Cataloging a DB2 Universal Database Database82

Understanding Objects84

System Objects84

Recovery Objects84

Storage Objects84

Database(or Data)Objects88

Summary103

Questions106

Answers108

Chapter 5 Creating Table Objects110

Understanding Data Types110

Integer111

Small Integer111

Big Integer112

Decimal112

Single-Precision Floating Point112

Double-Precision Floating Point113

Fixed-Length Character String113

Varying-Length Character String113

Varying-Length Long Character String114

Fixed-Length Double-Byte Character String115

Varying-Length Double-Byte Character String115

Varying-Length Double-Byte Long Character String115

Date116

Time116

Timestamp117

Binary Large Object117

DataLink118

Character Large Object118

Double-Byte Character Large Object118

User-Defined Data Types(UDTs)119

Extenders119

Understanding Constraints120

The NOT NULL Constraint120

The Column Default Constraint121

Unique Constraints123

Referential Constraints124

Check Constraints128

The CREATE TABLE SQL Statement129

CREATE TABLE SQL Statement Examples and Resulting Table Characteristics133

System Catalog Tables135

Summary137

Questions140

Answers143

Structured Query Language(SQL)145

Chapter 6 Basic SQL145

Data Definition Language(DDL)Statements146

Creating Nodegroups—The CREATE NODEGROUP Statement147

Creating Buffer Pools—The CREATE BUFFERPOOL Statement149

Creating Table Spaces—The CREATE TABLESPACE Statement150

Creating Tables—The CREATE TABLE Statement153

Creating Views—The CREATE VIEW Statement154

Creating Indexes—The CREATE INDEX Statement158

Creating Schemas—The CREATE SCHEMA Statement160

Creating Aliases—The CREATE ALIAS Statement161

Describing an Object—The COMMENT ON Statement162

Dropping an Object—The DROP Statement163

Modifying Object Definitions164

Data Manipulation Language(DML)Statements175

Retrieving Data—The SELECT Statement and Its Clauses175

Adding Data—The INSERT Statement184

Changing Data—The UPDATE Statement185

Deleting Data—The DELETE Statement186

Summary187

Questions193

Answers201

Chapter 7 Database Concurrency204

What Is Data Consistency?204

Transactions205

Concurrency and Isolation Levels207

Repeatable Read208

Read Stability209

Cursor Stability209

Uncommitted Read209

Specifying the Isolation Level210

Choosing the Proper Isolation Level210

Locking210

Lock Attributes and Lock States211

Lock Conversion213

Lock Compatibility213

Lock Escalation215

Deadlocks216

Lock Waits and Timeouts217

How Locks Are Acquired218

Factors That Affect Locking220

Summary221

Questions225

Answers227

PART Ⅲ DB2 UDB Administration(Tests 513)229

Chapter 8 Server Management231

Instances231

Attaching to an Instance232

Detaching from an Instance233

The DB2 Administration Server (DAS) Instance234

Distributed Connections234

Configuring Communications235

DB2 Discovery239

Controlling Database Access—Revisited244

Authentication244

AWord about Users and Groups246

Authorities246

Privileges250

Granting and Revoking Authorities and Privileges255

Taking Control of a Server to Perform Maintenance Operations258

Scheduling Maintenance with the Journal260

Summary261

Questions267

Answers269

Chapter 9 Data Placement271

Creating a DB2 Universal Database Database—AReview271

The DB2 Universal Database Storage Model272

Buffer Pools272

Table Spaces274

Containers275

Basic Buffer Pool and Table Space Requirements276

Characteristics That Affect Table Space Performance277

Page Size277

Extent Size278

Prefetch Size280

Obtaining Information about Existing Table Spaces280

Table Space States283

Obtaining Information about Table Space Containers284

Altering an Existing Table Space285

Summary285

Questions289

Answers292

Chapter 10 Data Access293

Tables—A Review293

Views294

Types of Views295

Imposing Restrictions on Views with the WITH CHECK OPTION clause296

Indexes and Constraints297

Indexes—A Review297

Understanding Constraints299

Unique(and Nonunique)Indexes299

Referential Constraints Revisited300

Examples of Referential Constraints303

Improving Performance with a Clustering Index306

System Catalog Tables and Views307

Using the Script Center310

An Alternative Method for Viewing Information Stored in Tables and Views312

Reverse-Engineering a Database with DB2LOOK313

Expanding a Database's Boundaries with Federated Systems315

Summary317

Questions321

Answers325

Chapter 11 Monitoring Database Activity327

The Database System Monitor327

The Snapshot Monitor328

Event Monitors333

The Performance Monitor344

Starting,Stopping,and Viewing the Performance Monitor344

Sending Messages to the Journal345

A Word about the Query Patroller Tracker346

Monitoring SQL Behavior346

The Explain Facility347

Configuring Database and Database Manager Resources355

Viewing the DB2 Database Manager's Configuration355

Viewing a Database's Configuration358

Changing the Value of a DB2 Database Manager Configuration Parameter360

Changing the Value of a Database's Configuration Parameter368

Changing the Value of a DB2 Registry or Environment Variable375

Summary376

Questions383

Answers385

Chapter 12 DB2 Universal Database's Data Movement and Data Management Utilities386

DB2 Universal Database's Data Movement Utilities386

Supported File Formats387

Obtaining Columnar Data from External Files389

The Export Utility392

The Import Utility396

The Load Utility406

The DB2MOVE Utility419

DB2 Universal Database's Data Maintenance Utilities421

The Reorganize Check Utility422

The Reorganize Table Utility425

The Run Statistics Utility427

Summary430

Questions434

Answers436

Chapter 13 Database Recovery and Maintenance438

Transaction Logging438

Circular Logging440

Archival Logging440

Returning a Database to a Consistent State441

Managing Database Recovery444

Creating a Backup Image of a Database445

The Recovery History File447

Restoring a Database(or a Table Space)from a Backup Image448

Roll-Forward Recovery452

Rebuilding Invalid Indexes456

Configuration Parameters That Affect Logging and Data Recovery456

Summary458

Questions462

Answers463

Chapter 14 Problem Determination465

Common Types of Errors465

Error Codes466

Viewing Error Messages467

First Failure Data Capture(FFDC)Information468

The db2diag.log File470

Interpreting db2diag.log Entry Headers470

Interpreting SQLCA Data Structure Value Entries472

Interpreting Hexadecimal Codes476

Locating Failed Objects477

An Example Scenario478

Summary480

Questions482

Answers483

Appendix A System Catalog Views484

Appendix B Bibliography550