 |
MC Press Online eBookStore |
|
DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Studfy Guide (Exam 731) |
| Author: Roger E. Sanders | | Publisher: MC Press Online | | Publication Date: October 2007 | | Subject: Computer: Database Management & Development |
|
|
|
|
|
| | About this title |
In DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide, Roger E. Sanders—one of the world's leading DB2 authors and an active participant in the development of IBM's DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 UDB DBA Certification exam (Exam 731). This comprehensive study guide steps you through all of the topics that are covered on the test, including Server Management, Data Placement, Database Access, Analyzing DB2 Activity, DB2 Utilities, High Availability, Security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.
Taking and passing the DB2 9 UDB DBA Certification exam (Exam 731) provides validation that you have mastered the next level of DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification.
The book includes sample questions in each chapter and a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.
With the DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, you will:
- Gain the knowledge necessary to pass the DB2 9 UDB DBA Certification exam (Exam 731)
- Learn how to effectively implement and administer a DB2 database containing XML data
- Create, maintain, and administer database objects like table, views, and indexes
- Receive an explanation of every topic included on the test…by someone involved in the creation of the actual exam
- Find 150 practice questions based on the actual exam's format and approach, along with comprehensive answers to the test questions to help you gain understanding
|
| About author |
 Roger E. Sanders —
Roger E. Sanders is the President of Roger Sanders Enterprises, Inc., and a Senior Consultant Corporate Systems Engineer with EMC Corporation. He has been writing technical articles and books for more than 14 years and is the author of 22 books on database technology.
For the past nine years, Roger has authored the Distributed DBA column in IBM Data Management Magazine (formerly DB2 Magazine), and he has written numerous tutorials and articles for IBM's developerWorks Web site, as well as for publications such as Certification Magazine and IDUG Solutions Journal. Roger's work has been published by well-known publishing houses such as McGraw-Hill, Prentice Hall, IBM, CMP Media, EMC, TDA Group, and MC Press.
In October 2008, Roger was recognized as an IBM Information Champion for his exceptional contributions to the IBM Information Management community. In 2011, he was recognized as an IBM developerWorks Professional Author.
|
| Contents |
Forward
Preface
Chapter 1: IBM DB2 9 Certification
DB2 9 Certification Roles
The Certification Process
Chapter 2: Server Management
Working with Instances
Configuring the DB2 System Environment
Configuring Instances and Databases
Configuring Communications
DB2 Discovery
Taking Control of a Server
Using the Task Center
Automatic Maintenance
Utility Throttling
Self-Tuning Memory Manager
Problem Determination
Practice Questions
Answers
Chapter 3: Data Placement
Servers, Instances, and Databases
Creating a DB2 9 Database
Table Spaces
Schemas
Range Clustering and Range Partitioning
Working with XML Data
Data Row Compression
Practice Questions
Answers
Chapter 4: Databases Access
Tables
Constraints
Creating Tables and Defining Constraints
Viewes
Indexes
A Word About the System Catalog
DB2 9's Comprehensive Tool Set
Practice Questions
Answers
Chapter 5: Analyzing DB2 Activity
The Database System Monitor
The Health Monitor and the Health Center
Monitoring SQL with the Explain Facility
Other Troubleshooting Tools
Practice Questions
Answers
Chapter 6: DB2 Utilities
DB2'S Data Movement Utilities and the File Formats They Support
Maintenance Utilities
Other Utilities
Practice Questions
Answers
Chapter 7: High Availability
Transactions
Transaction Logging
Database Recovery Concepts
Performing a Crash Recovery Operation
Backup and Recovery
Backing Up a Database with Split Mirroring
High Availability Disaster Recovery (HADR)
Practice Questions
Answers
Chapter 8: Security
Controlling Database Access
Authentication
Authorities and Privileges
Granting Authorities and Privileges
Authorities and Privileges Needed to Perform Common Tasks
Securing Data with Label-Based Access Control (LBAC)
Practice Questions
Answers
Appendix A: DB2 9 for LUW Database Administration Exam (Exam 731) Objectives
Appendix B: Sample Test |
| Related titles |
|
|
| |
|
|
|
|
If download option is selected, Adobe Acrobat 5.0 or later is required to read our e-books*
* Windows PC, Mac OS9/OSX, and Linux |
| |
|
|
