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 Advanced Database Administration: Certification Study Guide (Exam 734)
preview of book DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide (Exam 734)
text of book 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)

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

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: 9781583470800  
$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 this book, Roger E. Sanders and Dwaine R. Snow—two of the world's leading DB2 authors and active participants in the development of IBM's DB2 certification exams—cover everything you need to know to pass the DB2 9 Advanced Database Administration for Linux, UNIX and Windows exam (Exam 734). This exam is the final step needed to attain certification to be an IBM Certified Advanced Database Administrator - DB2 9 for Linux, UNIX, and Windows.

This comprehensive study guide explains all of the topics that are covered on the exam: database design, data partitioning and clustering, high availability, diagnostics, performance and scalability, database security and data encryption, connectivity and networking, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Taking and passing the DB2 9 Advanced Database Administration for Linux, UNIX and Windows exam (Exam 734) provides validation that you have extensive experience as a DBA and thorough knowledge of DB2 9. Certification proves you are capable of performing advanced database administration tasks—such as troubleshooting, performance tuning, and security management—that are highly sought by employers.

This book includes sample questions in each chapter plus a complete practice test that closely models the actual exam, along with an answer key that provides a full explanation of why the chosen answer is correct (and why the other answers are wrong). No other source gives a reader this much help in preparing for Exam 734.

With DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide, you will:
  • Gain the knowledge necessary to pass the DB2 9 Advanced Database Administration for Linux, UNIX and Windows exam (Exam 734)
  • Discover the changes to DB2 9 that you'll need to know about to be successful when taking the exam
  • Receive an explanation of every topic included on the test--by experts involved in the creation of the actual exam
  • Be given 120 practice questions based on the actual exam's format and approach, along with comprehensive answers to the test questions to help you gain understanding
  • Find appendices with information beyond the test requirements on monitoring buffer pool activity, using MQTs, employing advanced joining techniques, and using the Explain Tools
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
Foreword
Preface
About This Book

Chapter 1: IBM DB2 9 Certification
DB2 9 Certification Roles
The Certification Process

Chapter 2: Database Design
Servers, Instances, and Databases
Creating a Non-partitioned DB2 Database
Creating a Partitioned DB2 Database
Buffer Pools
Table Spaces
Expanding a Database's Boundaries with Federated Systems
Practice Questions
Answers

Chapter 3: Data Partitioning and Clustering
Parallelism
Partitioned Databases—A Closer Look
Partition Groups
Partitioning Keys and Partitioning Maps
Range Clustering and Range Partitioning
Multidimensional Clustering
Combining Database Partitioning, Table Partitioning, and Multidimensional Clustering
A Word About the Design Advisor
The Balanced Configuration Unit (BCU)
Practice Questions
Answers

Chapter 4: High Availability and Diagnostics
Transactions
Transaction Logging
Database Recovery Concepts
Performing a Crash Recovery Operation
Backup and Recovery
Backing Up and Restoring a Partitioned Database
Testing the Integrity of a Backup Image
Backing Up a Database with Split Mirroring
Managing Log fi les With a User Exit Program
High Availability Disaster Recovery (HADR)
Problem Determination Tools
Practice Questions
Answers

Chapter 5: Performance and Scalability
Basic Performance Tuning
Tuning the DB2 System Environment
Configuring Instances and Databases
Self-Tuning Memory Manager
Indexes
Object Statistics and the RUNSTATS Utility
Another Look at Parallelism
The DB2 Optimizer
Optimizer Techniques
Writing Better Queries
A Word About Joins
Locking
Analyzing DB2 Query Access Plans
Another Access Plan—With Details
Taking Control of the Server
Deep Compression
Practice Questions
Answers

Chapter 6: Security
Controlling Database Access
Authentication
Authorities and Privileges
Granting Authorities and Privileges
Authorities and Privileges Needed to Perform Common Tasks
Securing Data Using Encryption
Securing Data with Label-Based Access Control (LBAC)
DB2's Audit Facility
Practice Questions
Answers

Chapter 7: Connectivity and Networking
Configuring Communications
DB2's Directory Files
Cataloging Remote Servers and Databases
Configuring Communications to System z and System i Database Servers
DB2 Discovery
Fast Communications Manager (FCM) Communications
Troubleshooting Communications Errors
Practice Questions
Answers

Appendix A: DB2 9 for LUW Advanced Database Administration Exam (Exam 734) Objectives
Appendix B: Monitoring Buffer Pool Activity
Appendix C: Using Materialized Query Tables (MQTs)
Appendix D: Joining in DB2
Appendix E: Explain Tools
Appendix F: Sample Test
Related titles
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 Database Administration: Certification Study Guide (Exam 731)DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)
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 »»
Programming in ILE RPG
SOA for the Business Developer
DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)

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