You are previewing DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide.
O'Reilly logo
DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide

Book Description

In DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade 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 short—but notoriously challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736). This specialized study guide steps you through all of the topics that are covered on the exam, including server management, data placement, XML concepts, activity analysis, high availability, database security, and much more. Everything new to DB2 9 that you will need to know in order to successfully pass the exam is covered in this book. Taking and passing the DB2 9 for LUW DBA Certification Upgrade exam (Exam 736) provides validation that you have mastered DB2 9. Passing this exam also earns you the IBM Certified Database Administrator or Advanced Database Administrator certification. This concentrated guide includes an extensive set of practice questions in each chapter 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 Upgrade Certification Study Guide, you will: • Gain the knowledge necessary to pass the DB2 9 for LUW DBA Upgrade Certification exam (Exam 736) • Discover the changes to DB2 9 that you’ll need to know in order to be successful when taking the exam • Receive an explanation of every topic included on the test…by someone involved in the creation of the actual exam • Find 60 practice questions based on the actual exam’s format and approach, along with comprehensive answers to the test questions to help you gain understanding

Table of Contents

  1. Copyright
    1. Dedication
  2. Acknowledgments
  3. About the Author
  4. About This Book
    1. Conventions Used
  5. Foreword
  6. Preface
  7. 1. IBM DB2 9 Certification
    1. IBM Certified Database Administrator – DB2 9 for Linux, UNIX, and Windows
    2. DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade exam (Exam 736) Objectives
      1. Section 1 - Server Management (29%)
      2. Section 2 - Data Placement (21%)
      3. Section 3 - XML Concepts (13%)
      4. Section 4 - Analyzing DB2 Activity (16%)
      5. Section 5 - High Availability (10.5%)
      6. Section 6 - Security (10.5%)
    3. Taking the DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade exam (Exam 736)
  8. 2. Server Management
    1. Instance and Database Configurations
      1. The Configuration Advisor
      2. The AUTOCONFIGURE Command
    2. Configuring Communications
      1. Manually Configuring Communications
      2. Cataloging and Uncataloging a Node
    3. Automatic Maintenance
    4. Utility Throttling
      1. Obtaining Information About Running Utilities
      2. Changing a Running Utility’s Impact Priority
    5. Self-Tuning Memory Manager
    6. Practice Questions
    7. Answers
  9. 3. Data Placement
    1. Creating a DB2 9 Database
      1. What Happens When a DB2 9 Database Is Created
      2. The Complete CREATE DATABASE Command
    2. Table Spaces
      1. Creating New Table Spaces
      2. Modifying Existing Table Spaces
    3. Range-Partitioned Tables
    4. Data Row Compression
      1. Enabling a Table for Data Row Compression
      2. Building a Compression Dictionary
      3. Estimating Storage Savings from Data Row Compression
    5. Practice Questions
    6. Answers
  10. 4. XML Concepts
    1. Working with XML Data
      1. The XML Data Type and XML Columns
      2. Manipulating XML Data
    2. XML Indexes
    3. DB2’s Data Movement Utilities
      1. The Export Utility
      2. The Import Utility
      3. db2move and db2look
    4. Practice Questions
    5. Answers
  11. 5. Analyzing DB2 Activity
    1. The Database System Monitor
      1. The Snapshot Monitor
        1. Snapshot monitor switches
        2. Capturing snapshot data
        3. Capturing snapshot monitor data using SQL
        4. A word about the SNAP_WRITE_FILE() stored procedure
      2. Event Monitors
        1. Activating event monitors
    2. Other Troubleshooting Tools
      1. The DB2 Bind File Description Tool
      2. The DB2 Memory Tracker
      3. The DB2 Problem Determination Tool
    3. Practice Questions
    4. Answers
  12. 6. High Availability
    1. Transactions and Transaction Logging
    2. Database Recovery Concepts
      1. Crash Recovery
      2. Version Recovery
      3. Roll-Forward Recovery
      4. A Word About the Recovery History File
    3. The DB2 Recover Utility
    4. High Availability Disaster Recovery (HADR)
      1. Requirements for HADR Environments
      2. Setting Up an HADR Environment
      3. Automatic Client Reroute and HADR
    5. Practice Questions
    6. Answers
  13. 7. Security
    1. Controlling Database Access
      1. Authentication
        1. Where Does Authentication Take Place?
      2. Authorities and Privileges
    2. Securing Data with Label-Based Access Control (LBAC)
      1. Security Administrator authority
      2. Implementing Row-Level LBAC
        1. Defining a security label component
        2. Defining a security policy
        3. Defining security labels
        4. Creating a LBAC-protected table
        5. Granting security labels to users
        6. Putting row-level LBAC into action
      3. Implementing Column-Level LBAC
        1. Defining security label components, security policies, and security labels
        2. Creating a LBAC-protected table and granting privileges and security labels to users
        3. Creating LBAC-protected columns
        4. DB2LBACRULES rules
        5. Granting exemptions
        6. Putting column-level LBAC into action
      4. Combining Row-Level and Column-Level LBAC
    3. Practice Questions
    4. Answers
  14. More DB2 Books from MC Press