DB2 Universal Database V8.1 Certification Exams 701 and 706 Study Guide,9780131840485

DB2 Universal Database V8.1 Certification Exams 701 and 706 Study Guide

by
ISBN13: 9780131840485
ISBN10: 0131840487
Format: Paperback
Pub. Date: 2004-01-01
Publisher(s): IBM Press
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $52.49

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $14.58

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

The official in-depth guide to passing IBM's DB2 Universal Database Version 8.1 Certification Exams 701 and 706Over 20,000 people test to become IBM Certified Database Administrators every year. Some will pass, many will not. This book is IBM's official companion to mastering the skills that you need to ensure that you pass Certification Exams 701 and 706.Written by a member of the DB2 UDB Version 8.1 Certification Exam development team, DB2 Universal Database v8.1 Certification Exams 701 and 706 Study Guide delivers information that every database administrator should be familiar with before they take the DB2 Universal Database v8.1 Database Administrator certification exams.Author and DB2 UDB expert Roger E. Sanders covers every aspect of DB2 UDB v8.1 in clear, concise, and well-ordered chapters that give you the information you need to maximize your effectiveness come test time. Sanders outlines every facet of DB2 UDB v8.1 that will be featured on the exams and does so in an in-depth, professional manner that can only come from an expert with four DB2 UDB Version 8 certifications.Each chapter also features practice exam questions and answers, as well as explanations and breakdowns of every correct answer. There is no better way to prepare for the DB2 UDB V8.1 Certification exams!If you're a DB2 database administrator and you would like to become IBM DB2 UDB certified, then look no further-this is a must-have companion for anyone wanting to take the 701 or 706 certification exams.

Table of Contents

Foreword xiii
Preface xv
Part 1 DB2 UDB Certification
IBM DB2 Universal Database Certification
3(32)
DB2 Universal Database Certification Roles
3(13)
IBM Certified Database Associate---DB2 Universal Database V8.1 Family
4(1)
IBM Certified Database Administrator---DB2 Universal Database V8.1 for Linux, UNIX, and Windows
5(2)
IBM Certified Database Administrator---DB2 Universal Database V8.1 for z/OS and OS/390
7(2)
IBM Certified Application Developer---DB2 Universal Database V8.1 Family
9(3)
IBM Certified Advanced Database Administrator---DB2 Universal Database V8.1 for Linux, UNIX, and Windows
12(1)
IBM Certified Solution Designer---Business Intelligence V8.1
13(3)
The Certification Process
16(19)
Preparing for the Certification Exams
16(2)
Arranging to Take a Certification Exam
18(2)
Taking an IBM Certification Exam
20(15)
Part 2 DB2 UDB Linux, UNIX, and Windows Database Administration
Server Management
35(86)
Instances
37(4)
Attaching to an Instance
39(2)
Detaching from an Instance
41(1)
The DB2 Administration Server (DAS)
41(2)
Distributed Connections and Communications
43(11)
Configuring Communications
44(3)
The DB2COMM Registry Variable
47(2)
DB2 Discovery
49(5)
Controlling Database Access
54(1)
Authentication
54(4)
Where Does Authentication Take Place?
55(2)
Trusted Clients versus Untrusted Clients
57(1)
Authorities and Privileges
58(18)
Authorities
59(5)
Privileges
64(11)
Requirements for Granting and Revoking Authorities and Privileges
75(1)
Granting Authorities and Privileges
76(13)
Granting and Revoking Authorities and Privileges from the Control Center
77(1)
Granting Authorities and Privileges with the Grant SQL Statement
78(6)
Revoking Authorities and Privileges with the Revoke SQL Statement
84(5)
Authorities and Privileges Needed to Perform Common Tasks
89(2)
Taking Control of a Server
91(6)
Finding Out Who is Using an Instance or a Database
91(2)
The Force Application Command
93(1)
The Quiesce and Unquiesce Commands
94(3)
Using the Task Center
97(2)
A Word about the Journal
99(1)
Problem Determination
100(11)
Obtaining Information about an Error Code
101(1)
First Failure Data Capture (FFDC)
102(9)
Practice Questions
111(6)
Answers
117(4)
Data Placement
121(50)
Instances and Databases
123(1)
DB2 UDB Objects
124(4)
System Objects
124(1)
Recovery Objects
125(1)
Storage Objects
125(3)
Database (or Data) Objects
128(1)
Creating a DB2 UDB Database with the Create Database Command
128(9)
What Happens When a DB2 UDB Database is Created
129(5)
The Create Database Command
134(3)
Creating a DB2 UDB Database with the Create Database Wizard
137(3)
The Configuration Advisor
139(1)
Creating Additional Storage Objects
140(15)
Creating Buffer Pools
141(1)
Modifying Existing Buffer Pools
142(2)
Creating Tablespaces
144(5)
Modifying Existing Tablespaces
149(3)
Tables
152(2)
A Word about Schemas
154(1)
Obtaining Information About Existing Tablespaces
155(6)
Obtaining Information about the Containers Used by a Tablespace
158(3)
Practice Questions
161(5)
Answers
166(5)
Database Access
171(68)
Tables
174(1)
Constraints
175(25)
Not Null Constraints
176(1)
Default Constraints
177(2)
Check Constraints
179(2)
Unique Constraints
181(1)
Referential Integrity Constraints
182(14)
Informational Constraints
196(1)
Temporarily Suspending Constraint Checking with the Set Integrity SQL Statement
197(3)
Creating Tables
200(13)
Identity Columns
206(2)
Creating Tables That Are Similar to Existing Tables
208(1)
A Word about Declared Temporary Tables
209(1)
Create Table SQL Statement Examples
210(3)
Indexes
213(8)
Clustering Indexes
218(1)
Maltidimensional Clustering (MDC) Table Indexes
219(1)
Type-1 and Type-2 Indexes
220(1)
Views
221(4)
The Task Center (Revisited)
225(3)
Practice Questions
228(7)
Answers
235(4)
Monitoring DB2 Activity
239(94)
Configuring the DB2 System Environment
242(5)
Configuring Instances and Databases
247(31)
The DB2 Database Manager Instance Configuration
247(17)
Database Configurations
264(14)
The Database System Monitor
278(20)
The Snapshot Monitor
280(6)
Event Monitors
286(12)
The Health Monitor and the Health Center
298(3)
Monitoring SQL with the Explain Facility
301(18)
The Explain Tables
302(1)
Collecting Explain Data
303(7)
Evaluting Explain Data
310(9)
Managing SQL Statement Execution with the DB2 Governor and the DB2 Query Patroller
319(2)
The DB2 Governor
320(1)
The DB2 Query Patroller
320(1)
Practice Questions
321(6)
Answers
327(6)
DB2 Utilities
333(86)
DB2 UDB's Data Movement Utilities and the File Formats They Support
335(54)
Delimited ASCII (DEL)
336(1)
Non-Delimited ASCII (ASC)
337(1)
Worksheet Format (WSF)
338(1)
PC Integrated Exchange Format (IXF)
338(1)
Extracting Columnar Data from External Files
339(2)
The DB2 UDB Export Utility
341(7)
The DB2 UDB Import Utility
348(17)
The DB2 UDB Load Utility
365(23)
db2move and db2look
388(1)
Data Maintenance Utilities
389(21)
The REORGCHK Utility
389(6)
The Reorg Utility
395(3)
The Inspect Utility
398(3)
The Runstats Utility
401(5)
The Design Advisor
406(4)
Practice Questions
410(5)
Answers
415(4)
Backup and Recovery
419(50)
Transactions
421(4)
Transaction Logging
425(6)
Logging Strategies
426(5)
Database Recovery Concepts
431(4)
Crash Recovery
431(1)
Version Recovery
432(1)
Roll-Forward Recovery
432(1)
Recoverable and Non-recoverable Databases
433(1)
Online versus Offline Backup and Recovery
434(1)
Incremental Backup and Recovery
434(1)
Performing a Crash Recovery Operation
435(3)
A Word about Soft Checkpoints
438(1)
Backup and Recovery
438(19)
The DB2 UDB Backup Utility
439(3)
The Recovery History File
442(3)
The DB2 UDB Restore Utility
445(6)
The DB2 UDB Rollforward Utility
451(5)
Rebuilding Invalid Indexes
456(1)
Backing Up a Database with Split Mirroring
457(3)
Initializing a Split Mirror with db2inidb
459(1)
Practice Questions
460(5)
Answers
465(4)
Appendix A DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Exam (Exam 701) Objectives
469(4)
DB2 Server Management (19%)
469(1)
Data Placement (17%)
470(1)
Data Access (17%)
470(1)
Monitoring DB2 Activity (16%)
470(1)
DB2 Utilities (17%)
471(1)
Backup and Recovery (14%)
471(2)
Appendix B DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Certification Upgrade Exam (Exam 706) Objectives
473(4)
DB2 Server Management (20%)
473(1)
Data Placement (13%)
474(1)
Data Access (13%)
474(1)
Monitoring DB2 Activity (14%)
474(1)
DB2 Utilities (23%)
474(1)
Backup and Recovery (17%)
474(3)
Index 477

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.