MC Press Online
Welcome to the MC Press Online!
Need help with our eBooks?
Contact PublishersRow.com
Click here, to go to our main store

  MC Press Online eBookStore  

DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)
preview of book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)
text of book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)

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

Author:
Publisher: MC Press Online
Publication Date: October 2007
Subject: Computer: Database Management & Development
Number of Pages: 897

Free Preview    Email to Friend   Add to wish list
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583470770  
$44.17
 
 Reg.: $
64.95 per N pages
 You Save: 
$20.78 (32%)
 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 the author of 22 books on relational database technology (21 on DB2 for Linux, UNIX, and Windows; one on ODBC). He has worked with DB2 for Linux, UNIX, and Windows--IBM's relational database management product for open systems—since it was first introduced on the IBM PC as part of OS/2 1.3 Extended Edition (1991), and he has been designing and developing databases and database applications for more than 20 years.

Roger authored a regular column ("Distributed DBA") in IBM Data Magazine (formerly DB2 Magazine) for 10 years, and he has written numerous tutorials and articles for IBM's developerWorks website as well as for publications such as Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group). He has delivered a variety of educational seminars and presentations at DB2-related conferences and has participated in the development of 21 DB2 certification exams.

From 2008 to 2014, Roger has been recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2010 he received recognition as an IBM developerWorks Contributing Author, in 2011 as an IBM developerWorks Professional Author, and in 2012 as an IBM developerWorks Master Author, Level 2 for his contributions to the IBM developerWorks community. (Only four individuals worldwide have received this last distinction.) Roger lives in Fuquay Varina, North Carolina.

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
Administering Informix Dynamic ServerAdministering Informix Dynamic Server
DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)
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)
DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)
 
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)
Understanding AS/400 System Operations
Remote System Explorer, The

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