Cover image for DB2 administration exam guide
Title:
DB2 administration exam guide
Author:
Sanders, Roger E., 1961-
Personal Author:
Publication Information:
New York : McGraw-Hill/Osborne, [2002]

©2002
Physical Description:
xxiii, 804 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.).
General Note:
"Complete coverage of all objectives on DB2 certification exams 509, 512, and 513"--Cover.

"213375-9"--Spine.

Includes index.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780072133752
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 S2534 2002 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

This title covers all three exams necessary for DB2 certification. It contains exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and hundreds of photos and illustrations.


Table of Contents

Introductionp. xvii
Part I DB2 Certificationp. 1
Chapter 1 DB2 Universal Database Professional Certificationp. 3
The Professional Certification Program from IBMp. 4
DB2 Universal Database Certification Rolesp. 5
IBM Certified Specialist--DB2 Userp. 6
IBM Certified Solutions Expert--Business Intelligencep. 7
IBM Certified Solutions Expert--DB2 UDB V7.1 Database Administration for UNIX, Windows, and OS/2p. 8
IBM Certified Solutions Expert--DB2 UDB V7.1 Family Application Developmentp. 10
IBM Certified Solutions Expert--DB2 UDB V7.1 Database Administration for OS/390p. 11
IBM Certified Advanced Technical Expert--DB2 for Clustersp. 12
IBM Certified Advanced Technical Expert--DB2 - DRDAp. 13
IBM Certified Advanced Technical Expert--DB2 Data Replicationp. 15
The Certification Processp. 15
Preparing for the Testsp. 17
The Testing Procedurep. 18
Benefits Professional Certification Providesp. 20
Summaryp. 21
Part II DB2 UDB Fundamentals (Test 509 and 512)p. 23
Chapter 2 Installation and Planningp. 25
The DB2 Universal Database Familyp. 26
DB2 Universal Database Productsp. 26
DB2 Universal Database Clientsp. 36
Other DB2 Universal Database Productsp. 37
DB2 Universal Database Packagesp. 47
DB2's Administration Toolsp. 49
The Control Centerp. 50
The Command Centerp. 51
The Script Centerp. 56
The Alert Centerp. 57
The Journalp. 57
The Command Line Processor (CLP)p. 58
The Performance Monitorp. 60
The Client Configuration Assistant (CCA)p. 61
Summaryp. 63
Questionsp. 65
Answersp. 67
Chapter 3 Instances and Securityp. 69
Instancesp. 70
The DB2 Administration Server (DAS) Instancep. 72
Controlling Database Accessp. 74
Authenticationp. 74
Authoritiesp. 77
Privilegesp. 82
Granting and Revoking Authorities and Privilegesp. 90
Summaryp. 94
Questionsp. 97
Answersp. 99
Chapter 4 Creating and Accessing DB2 Databases and DB2 Database Objectsp. 101
The Relational Database Modelp. 102
What Is a DB2 Universal Database Database?p. 103
Creating a DB2 Universal Database Databasep. 106
Destroying a DB2 Universal Database Databasep. 111
The DB2 Universal Database Directory Filesp. 112
Uncataloging a DB2 Universal Database Databasep. 114
Cataloging a DB2 Universal Database Databasep. 115
Understanding Objectsp. 117
System Objectsp. 117
Recovery Objectsp. 118
Storage Objectsp. 118
Database (or Data) Objectsp. 123
Summaryp. 145
Questionsp. 150
Answersp. 153
Chapter 5 Creating Table Objectsp. 155
Understanding Data Typesp. 156
Small Integerp. 157
Integerp. 157
Big Integerp. 157
Decimalp. 158
Single-Precision Floating Pointp. 158
Double-Precision Floating Pointp. 159
Fixed-Length Character Stringp. 159
Varying-Length Character Stringp. 159
Varying-Length Long Character Stringp. 160
Fixed-Length Double-Byte Character Stringp. 161
Varying-Length Double-Byte Character Stringp. 161
Varying-Length Double-Byte Long Character Stringp. 162
Datep. 163
Timep. 163
Timestampp. 164
Binary Large Objectp. 165
Character Large Objectp. 166
Double-Byte Character Large Objectp. 166
DataLinkp. 166
User-Defined Data Types (UDTs)p. 167
Extendersp. 168
Understanding Constraintsp. 168
The NOT NULL Constraintp. 169
The Column Default Constraintp. 170
Unique Constraintsp. 172
Referential Constraintsp. 174
Check Constraintsp. 180
The CREATE TABLE SQL Statementp. 181
CREATE TABLE SQL Statement Examples and Resulting Table Characteristicsp. 185
System Catalog Tablesp. 189
Summaryp. 192
Questionsp. 197
Answersp. 200
Chapter 6 Basic SQLp. 203
Structured Query Language (SQL)p. 204
Data Definition Language (DDL) Statementsp. 205
Creating Nodegroups--The CREATE NODEGROUP Statementp. 207
Creating Buffer Pools--The CREATE BUFFERPOOL Statementp. 209
Creating Table Spaces--The CREATE TABLESPACE Statementp. 211
Creating Tables--The CREATE TABLE Statementp. 215
Creating Views--The CREATE VIEW Statementp. 215
Creating Indexes--The CREATE INDEX Statementp. 221
Creating Schemas--The CREATE SCHEMA Statementp. 224
Creating Aliases--The CREATE ALIAS Statementp. 226
Describing an Object--The COMMENT ON Statementp. 227
Dropping an Object--The DROP Statementp. 229
Modifying Object Definitionsp. 230
Data Manipulation Language (DML) Statementsp. 244
Retrieving Data--The SELECT Statement and Its Clausesp. 244
Adding Data--The INSERT Statementp. 257
Changing Data--The UPDATE Statementp. 258
Deleting Data--The DELETE Statementp. 260
Summaryp. 261
Questionsp. 269
Answersp. 281
Chapter 7 Database Concurrencyp. 285
What Is Data Consistency?p. 286
Transactionsp. 287
Concurrency and Isolation Levelsp. 290
Repeatable Readp. 291
Read Stabilityp. 292
Cursor Stabilityp. 292
Uncommitted Readp. 292
Specifying the Isolation Levelp. 293
Choosing the Proper Isolation Levelp. 293
Lockingp. 294
Lock Attributes and Lock Statesp. 294
Lock Compatibilityp. 295
Lock Conversionp. 298
Lock Escalationp. 300
Deadlocksp. 301
Lock Waits and Timeoutsp. 303
How Locks Are Acquiredp. 304
Factors That Affect Lockingp. 307
Summaryp. 309
Questionsp. 314
Answersp. 316
Part III DB2 UDB Administration (Test 513)p. 319
Chapter 8 Server Managementp. 321
Instancesp. 322
Attaching to an Instancep. 322
Detaching from an Instancep. 324
The DB2 Administration Server (DAS) Instancep. 325
Distributed Connectionsp. 326
Configuring Communicationsp. 327
DB2 Discoveryp. 331
Controlling Database Access--Revisitedp. 338
Authenticationp. 338
A Word about Users and Groupsp. 341
Authoritiesp. 341
Privilegesp. 347
Granting and Revoking Authorities and Privilegesp. 355
Taking Control of a Server to Perform Maintenance Operationsp. 357
Scheduling Maintenance with the Journalp. 361
Summaryp. 363
Questionsp. 370
Answersp. 374
Chapter 9 Data Placementp. 377
Creating a DB2 Universal Database Database - A Reviewp. 378
The DB2 Universal Database Storage Modelp. 379
Buffer Poolsp. 379
Table Spacesp. 381
Containersp. 382
Basic Buffer Pool and Table Space Requirementsp. 384
Characteristics That Affect Table Space Performancep. 386
Page Sizep. 386
Extent Sizep. 386
Prefetch Sizep. 389
Obtaining Information about Existing Table Spacesp. 390
Table Space Statesp. 393
Obtaining Information about Table Space Containersp. 395
Altering an Existing Table Spacep. 396
Summaryp. 396
Questionsp. 402
Answersp. 405
Chapter 10 Data Accessp. 407
Tables - A Reviewp. 408
Viewsp. 408
Types of Viewsp. 410
Imposing Restrictions on Views with the WITH CHECK OPTION clausep. 411
Indexes and Constraintsp. 413
Indexes--A Reviewp. 413
Understanding Constraintsp. 415
Unique (and Nonunique) Indexesp. 415
Referential Constraints Revisitedp. 417
Examples of Referential Constraintsp. 422
Improving Performance with a Clustering Indexp. 426
System Catalog Tables and Viewsp. 427
Using the Script Centerp. 431
An Alternative Method for Viewing Information Stored in Tables and Viewsp. 434
Reverse-Engineering a Database with DB2LOOKp. 434
Expanding a Database's Boundaries with Federated Systemsp. 439
Summaryp. 441
Questionsp. 448
Answersp. 452
Chapter 11 Monitoring Database Activityp. 455
The Database System Monitorp. 456
The Snapshot Monitorp. 456
Event Monitorsp. 464
The Performance Monitorp. 478
Starting, Stopping, and Viewing the Performance Monitorp. 479
Sending Messages to the Journalp. 479
A Word about the Query Patroller Trackerp. 480
Monitoring SQL Behaviorp. 482
The Explain Facilityp. 482
Configuring Database and Database Manager Resourcesp. 494
Viewing the DB2 Database Manager's Configurationp. 494
Viewing a Database's Configurationp. 497
Changing the Value of a DB2 Database Manager Configuration Parameterp. 499
Changing the Value of a Database's Configuration Parameterp. 510
Changing the Value of a DB2 Registry or Environment Variablep. 520
Summaryp. 522
Questionsp. 531
Answersp. 534
Chapter 12 DB2 Universal Database's Data Movement and Data Management Utilitiesp. 537
DB2 Universal Database's Data Movement Utilitiesp. 538
Supported File Formatsp. 538
Obtaining Columnar Data from External Filesp. 542
The Export Utilityp. 543
The Import Utilityp. 551
The Load Utilityp. 563
The DB2MOVE Utilityp. 581
DB2 Universal Database's Data Maintenance Utilitiesp. 584
The Reorganize Check Utilityp. 584
The Reorganize Table Utilityp. 589
The Run Statistics Utilityp. 592
Summaryp. 596
Questionsp. 602
Answersp. 605
Chapter 13 Database Recovery and Maintenancep. 607
Transaction Loggingp. 608
Circular Loggingp. 610
Archival Loggingp. 610
Returning a Database to a Consistent Statep. 611
Managing Database Recoveryp. 616
Creating a Backup Image of a Databasep. 616
The Recovery History Filep. 619
Restoring a Database (or a Table Space) from a Backup Imagep. 621
Roll-Forward Recoveryp. 626
Rebuilding Invalid Indexesp. 633
Configuration Parameters That Affect Logging and Data Recoveryp. 633
Summaryp. 635
Questionsp. 642
Answersp. 643
Chapter 14 Problem Determinationp. 645
Common Types of Errorsp. 646
Error Codesp. 646
Viewing Error Messagesp. 648
First Failure Data Capture (FFDC) Informationp. 649
The db2diag.log Filep. 652
Interpreting db2diag.log Entry Headersp. 653
Interpreting SQLCA Data Structure Value Entriesp. 655
Interpreting Hexadecimal Codesp. 661
Locating Failed Objectsp. 662
An Example Scenariop. 664
Summaryp. 666
Questionsp. 669
Answersp. 670
Appendix A System Catalog Viewsp. 671
Appendix B Bibliographyp. 781
Indexp. 785

Google Preview