DB2 Administration All-in-One Exam Guide

DB2 Administration All-in-One Exam Guide

by Roger E. Sanders

Hardcover

$69.99

Product Details

ISBN-13: 9780072133752
Publisher: McGraw-Hill Companies, The
Publication date: 01/18/2002
Series: All-in-One Certification Series
Pages: 804
Product dimensions: 7.70(w) x 9.42(h) x 2.18(d)

Table of Contents

Introductionxvii
Part IDB2 Certification1
Chapter 1DB2 Universal Database Professional Certification3
The Professional Certification Program from IBM4
DB2 Universal Database Certification Roles5
IBM Certified Specialist--DB2 User6
IBM Certified Solutions Expert--Business Intelligence7
IBM Certified Solutions Expert--DB2 UDB V7.1 Database Administration for UNIX, Windows, and OS/28
IBM Certified Solutions Expert--DB2 UDB V7.1 Family Application Development10
IBM Certified Solutions Expert--DB2 UDB V7.1 Database Administration for OS/39011
IBM Certified Advanced Technical Expert--DB2 for Clusters12
IBM Certified Advanced Technical Expert--DB2 - DRDA13
IBM Certified Advanced Technical Expert--DB2 Data Replication15
The Certification Process15
Preparing for the Tests17
The Testing Procedure18
Benefits Professional Certification Provides20
Summary21
Part IIDB2 UDB Fundamentals (Test 509 and 512)23
Chapter 2Installation and Planning25
The DB2 Universal Database Family26
DB2 Universal Database Products26
DB2 Universal Database Clients36
Other DB2 Universal Database Products37
DB2 Universal Database Packages47
DB2's Administration Tools49
The Control Center50
The Command Center51
The Script Center56
The Alert Center57
The Journal57
The Command Line Processor (CLP)58
The Performance Monitor60
The Client Configuration Assistant (CCA)61
Summary63
Questions65
Answers67
Chapter 3Instances and Security69
Instances70
The DB2 Administration Server (DAS) Instance72
Controlling Database Access74
Authentication74
Authorities77
Privileges82
Granting and Revoking Authorities and Privileges90
Summary94
Questions97
Answers99
Chapter 4Creating and Accessing DB2 Databases and DB2 Database Objects101
The Relational Database Model102
What Is a DB2 Universal Database Database?103
Creating a DB2 Universal Database Database106
Destroying a DB2 Universal Database Database111
The DB2 Universal Database Directory Files112
Uncataloging a DB2 Universal Database Database114
Cataloging a DB2 Universal Database Database115
Understanding Objects117
System Objects117
Recovery Objects118
Storage Objects118
Database (or Data) Objects123
Summary145
Questions150
Answers153
Chapter 5Creating Table Objects155
Understanding Data Types156
Small Integer157
Integer157
Big Integer157
Decimal158
Single-Precision Floating Point158
Double-Precision Floating Point159
Fixed-Length Character String159
Varying-Length Character String159
Varying-Length Long Character String160
Fixed-Length Double-Byte Character String161
Varying-Length Double-Byte Character String161
Varying-Length Double-Byte Long Character String162
Date163
Time163
Timestamp164
Binary Large Object165
Character Large Object166
Double-Byte Character Large Object166
DataLink166
User-Defined Data Types (UDTs)167
Extenders168
Understanding Constraints168
The NOT NULL Constraint169
The Column Default Constraint170
Unique Constraints172
Referential Constraints174
Check Constraints180
The CREATE TABLE SQL Statement181
CREATE TABLE SQL Statement Examples and Resulting Table Characteristics185
System Catalog Tables189
Summary192
Questions197
Answers200
Chapter 6Basic SQL203
Structured Query Language (SQL)204
Data Definition Language (DDL) Statements205
Creating Nodegroups--The CREATE NODEGROUP Statement207
Creating Buffer Pools--The CREATE BUFFERPOOL Statement209
Creating Table Spaces--The CREATE TABLESPACE Statement211
Creating Tables--The CREATE TABLE Statement215
Creating Views--The CREATE VIEW Statement215
Creating Indexes--The CREATE INDEX Statement221
Creating Schemas--The CREATE SCHEMA Statement224
Creating Aliases--The CREATE ALIAS Statement226
Describing an Object--The COMMENT ON Statement227
Dropping an Object--The DROP Statement229
Modifying Object Definitions230
Data Manipulation Language (DML) Statements244
Retrieving Data--The SELECT Statement and Its Clauses244
Adding Data--The INSERT Statement257
Changing Data--The UPDATE Statement258
Deleting Data--The DELETE Statement260
Summary261
Questions269
Answers281
Chapter 7Database Concurrency285
What Is Data Consistency?286
Transactions287
Concurrency and Isolation Levels290
Repeatable Read291
Read Stability292
Cursor Stability292
Uncommitted Read292
Specifying the Isolation Level293
Choosing the Proper Isolation Level293
Locking294
Lock Attributes and Lock States294
Lock Compatibility295
Lock Conversion298
Lock Escalation300
Deadlocks301
Lock Waits and Timeouts303
How Locks Are Acquired304
Factors That Affect Locking307
Summary309
Questions314
Answers316
Part IIIDB2 UDB Administration (Test 513)319
Chapter 8Server Management321
Instances322
Attaching to an Instance322
Detaching from an Instance324
The DB2 Administration Server (DAS) Instance325
Distributed Connections326
Configuring Communications327
DB2 Discovery331
Controlling Database Access--Revisited338
Authentication338
A Word about Users and Groups341
Authorities341
Privileges347
Granting and Revoking Authorities and Privileges355
Taking Control of a Server to Perform Maintenance Operations357
Scheduling Maintenance with the Journal361
Summary363
Questions370
Answers374
Chapter 9Data Placement377
Creating a DB2 Universal Database Database - A Review378
The DB2 Universal Database Storage Model379
Buffer Pools379
Table Spaces381
Containers382
Basic Buffer Pool and Table Space Requirements384
Characteristics That Affect Table Space Performance386
Page Size386
Extent Size386
Prefetch Size389
Obtaining Information about Existing Table Spaces390
Table Space States393
Obtaining Information about Table Space Containers395
Altering an Existing Table Space396
Summary396
Questions402
Answers405
Chapter 10Data Access407
Tables - A Review408
Views408
Types of Views410
Imposing Restrictions on Views with the WITH CHECK OPTION clause411
Indexes and Constraints413
Indexes--A Review413
Understanding Constraints415
Unique (and Nonunique) Indexes415
Referential Constraints Revisited417
Examples of Referential Constraints422
Improving Performance with a Clustering Index426
System Catalog Tables and Views427
Using the Script Center431
An Alternative Method for Viewing Information Stored in Tables and Views434
Reverse-Engineering a Database with DB2LOOK434
Expanding a Database's Boundaries with Federated Systems439
Summary441
Questions448
Answers452
Chapter 11Monitoring Database Activity455
The Database System Monitor456
The Snapshot Monitor456
Event Monitors464
The Performance Monitor478
Starting, Stopping, and Viewing the Performance Monitor479
Sending Messages to the Journal479
A Word about the Query Patroller Tracker480
Monitoring SQL Behavior482
The Explain Facility482
Configuring Database and Database Manager Resources494
Viewing the DB2 Database Manager's Configuration494
Viewing a Database's Configuration497
Changing the Value of a DB2 Database Manager Configuration Parameter499
Changing the Value of a Database's Configuration Parameter510
Changing the Value of a DB2 Registry or Environment Variable520
Summary522
Questions531
Answers534
Chapter 12DB2 Universal Database's Data Movement and Data Management Utilities537
DB2 Universal Database's Data Movement Utilities538
Supported File Formats538
Obtaining Columnar Data from External Files542
The Export Utility543
The Import Utility551
The Load Utility563
The DB2MOVE Utility581
DB2 Universal Database's Data Maintenance Utilities584
The Reorganize Check Utility584
The Reorganize Table Utility589
The Run Statistics Utility592
Summary596
Questions602
Answers605
Chapter 13Database Recovery and Maintenance607
Transaction Logging608
Circular Logging610
Archival Logging610
Returning a Database to a Consistent State611
Managing Database Recovery616
Creating a Backup Image of a Database616
The Recovery History File619
Restoring a Database (or a Table Space) from a Backup Image621
Roll-Forward Recovery626
Rebuilding Invalid Indexes633
Configuration Parameters That Affect Logging and Data Recovery633
Summary635
Questions642
Answers643
Chapter 14Problem Determination645
Common Types of Errors646
Error Codes646
Viewing Error Messages648
First Failure Data Capture (FFDC) Information649
The db2diag.log File652
Interpreting db2diag.log Entry Headers653
Interpreting SQLCA Data Structure Value Entries655
Interpreting Hexadecimal Codes661
Locating Failed Objects662
An Example Scenario664
Summary666
Questions669
Answers670
Appendix ASystem Catalog Views671
Appendix BBibliography781
Index785

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews