Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®

Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®

by Dwaine R. Snow, Thomas X. Phan
Released July 2003
Publisher(s): IBM Press
ISBN: 9780130463883

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

  • Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification.

  • Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more.

  • The appendices contain sample certification exam questions and answers.

    • Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there's one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.

    Now, there's a definitive guide to advanced DB2 UDB database administration that also delivers all the depth and insight you need to prepare for the tough new IBM exam. Straight from the DB2 experts at IBM, this book offers systematic and authoritative coverage of every exam objective and will serve as a reference after you have passed the test.

    For the first time, this book brings together IBM best practices, techniques, tips, guidelines, and rules of thumb for virtually every aspect of advanced DB2 UDB v8 database administration-including all this and more:

  • Ability to design, create, and manage table spaces

  • Ability to design, create, and manage buffer pools

  • When and how to exploit parallelism in DB2 UDB

  • Configuring federated database access

  • Designing and implementing a backup and recovery strategy

  • Ability to implement a standby database

  • Monitoring and tuning DB2

  • Using and managing tables with multidimensional clustering

  • Designing and configuring multiple database partitions

  • Implementing authentication and encryption on a large scale

  • Leveraging parallelism and symmetric multiprocessing

  • Preparing for and executing recovery in an enterprise environment

  • Rapid recovery in the event of table space or table level disasters

  • Effective monitoring and problem determination

  • Maximizing performance and scalability

    • About the CDThe accompanying CD-ROM contains the IBM® DB2® Universal Database Enterprise Server Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus DB2 UDB v8 Enterprise Server Edition documentation in PDF format.

    Table of contents

    1. Copyright
    2. IBM Press Series—Information Management
    3. About Prentice Hall Professional Technical Reference
    4. Foreword
    5. Preface
    6. Data Storage
      1. Some Terminology Used in DB2
      2. The Default Database
      3. Table Spaces
      4. Additional Table Space Options/Parameters
      5. Summary
    7. Data Manipulation
      1. The Buffer Pools
      2. Parallelism
      3. Types of Database Objects
      4. Summary
    8. Database Availability
      1. Ability to Manage Logs
      2. Developing a Backup and Recovery Strategy
      3. Backup Overview
      4. Restore Overview
      5. Rollforward Overview
      6. High Availability Clustering
      7. Availability Enhancements
      8. Ability to Use db2dart
      9. Summary
    9. Database Security
      1. Selecting User Names and Group Names for DB2 Installation
      2. Authentication Methods
      3. Privileges, Authorities, and Authorizations
      4. Firewall Support
      5. What Is LDAP?
      6. Security Implementation and Usage
      7. How DB2 for Windows NT/2000 Works with Windows NT/2000 Security
      8. User Authentication with DB2 for Windows NT
      9. Summary
    10. Multi-Dimensional Clustering
      1. MDC Terminology
      2. Design Guidelines for MDC Tables
      3. MDC Performance Guidelines
      4. Space Usage with MDC Tables
      5. MDC Indexes
      6. Summary
    11. The DB2 Optimizer
      1. Joining in DB2 UDB
      2. Materialized Query Tables
      3. Understanding DB2 Query Access Plans
      4. Summary
    12. Federated Database Access
      1. What Is a Federated System?
      2. Overview of the Tasks to Set Up a Federated System
      3. How Do You Interact with a Federated System?
      4. Setting Up the Federated Server and Database
      5. Working with the Federated Data
      6. Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris
      7. Configuration of a Federated Database System
      8. Nickname Characteristics Affecting Global Optimization
      9. Summary
    13. Performance Tuning
      1. Performance Fundamentals
      2. Configuration Parameter Tuning
      3. Database Configuration Parameter Tuning and Monitoring
      4. Registry Variable Tuning
      5. Other Important Configuration Parameters
      6. Summary
    14. Database Communications
      1. Database Partition Configuration File (db2nodes.cfg)
      2. Default Port Range
      3. Non-Partitioned Database Environment
      4. Installing the DB2 Server
      5. Partitioned Database Environment
      6. Post-Installation Setup
      7. Installing and Configuring DB2 Client to DB2 Server Communications
      8. Installing and Configuring DB2 Client to DB2 Host Communications
      9. Installing DB2 Connect Personal Edition
      10. Configuring DB2 Clients in a Two-Tier Environment
      11. Configuring DB2 Clients in a Three-Tier Environment
      12. FCM Communication Buffers Considerations
      13. Summary
    15. Performance Tuning Examples
      1. Example 1: Create Index Taking Too Long
      2. Example 2: Unable to Get Desired Throughput
      3. Example 3: Query1 Taking Too Long to Run
      4. Example 4: Query2 Taking Too Long to Run
      5. Example 5: Periodic Noticeable Slowdown of Database Response Time
    16. Useful DB2 Commands
      1. System Commands
      2. CLP Commands
      3. ONLINE Utility
    17. parseSQL.pl
    18. exfmtDIF.pl
    19. Comparing Index Advisor Recommended Indexes with Existing Indexes
    20. Configuration Parameters That Can Be Changed Online
    21. Explain Tools
      1. EXPLAIN Tables
      2. EXPLAIN Commands
      3. EXPLAIN Output
    22. Starting and Stopping a DB2 Instance
    23. LDAP Integration in DB2 UDB Using Microsoft Active Directory
      1. Implementation Guidelines
    24. Tuning DB2 UDB in the IBM LDAP Environment
    25. DB2 Support Information
      1. DB2 Support Resources
      2. Opening a PMR
      3. Collecting Diagnostic Information
      4. Sending Diagnostic Information
    26. DB2 Connect Implementation
      1. Installing DB2 Connect Enterprise Edition
    27. Sample Questions
    28. Answers to Sample Questions
    29. About the CD-ROM
      1. License Agreement
      2. Technical Support
    30. Article

    Product information

    • Title: Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®
    • Author(s): Dwaine R. Snow, Thomas X. Phan
    • Release date: July 2003
    • Publisher(s): IBM Press
    • ISBN: 9780130463883