MC Press Online
Welcome to MC Press Online!
Need help with our eBooks?
Home  |  Cart  |  My Account  |  Support    
Click here, to go to our main store

  MC Press Online eBookStore   

DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Studfy Guide (Exam 731)

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

Free Preview    Email to Friend
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583470770  
 Reg.: $
64.95 per N pages
 You Save: 
$26.30 (40%)
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
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.


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

Chapter 3: Data Placement
Servers, Instances, and Databases
Creating a DB2 9 Database
Table Spaces
Range Clustering and Range Partitioning
Working with XML Data
Data Row Compression
Practice Questions

Chapter 4: Databases Access
Creating Tables and Defining Constraints
A Word About the System Catalog
DB2 9's Comprehensive Tool Set
Practice Questions

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

Chapter 6: DB2 Utilities
DB2'S Data Movement Utilities and the File Formats They Support
Maintenance Utilities
Other Utilities
Practice Questions

Chapter 7: High Availability
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

Chapter 8: Security
Controlling Database Access
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

Appendix A: DB2 9 for LUW Database Administration Exam (Exam 731) Objectives
Appendix B: Sample Test
Related titles
Administering Informix Dynamic ServerAdministering Informix Dynamic Server
DB2 9 for DevelopersDB2 9 for Developers
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide (Exam 734)DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide (Exam 734)
DB2 9 Fundamentals: Certification Study Guide (Exam 730)DB2 9 Fundamentals: Certification Study Guide (Exam 730)
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
Identity Management: A Primer
Identity Management: A Primer
DB2 9 for Developers
DB2 9 for Developers
IBM Business Analytics and Cloud Computing
IBM Business Analytics and Cloud Computing

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

  Secure Shopping  
money-back 30 days guarantee

All orders for eBooks are filled and customer/technical
support is provided by

Copyright © 2001-2011 by Publishers Row. All rights reserved.
Our Privacy Policy and Terms of Use