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
- Copyright
- IBM Press Series—Information Management
- About Prentice Hall Professional Technical Reference
- Foreword
- Preface
- Data Storage
- Data Manipulation
- Database Availability
-
Database Security
- Selecting User Names and Group Names for DB2 Installation
- Authentication Methods
- Privileges, Authorities, and Authorizations
- Firewall Support
- What Is LDAP?
- Security Implementation and Usage
- How DB2 for Windows NT/2000 Works with Windows NT/2000 Security
- User Authentication with DB2 for Windows NT
- Summary
- Multi-Dimensional Clustering
- The DB2 Optimizer
-
Federated Database Access
- What Is a Federated System?
- Overview of the Tasks to Set Up a Federated System
- How Do You Interact with a Federated System?
- Setting Up the Federated Server and Database
- Working with the Federated Data
- Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris
- Configuration of a Federated Database System
- Nickname Characteristics Affecting Global Optimization
- Summary
- Performance Tuning
-
Database Communications
- Database Partition Configuration File (db2nodes.cfg)
- Default Port Range
- Non-Partitioned Database Environment
- Installing the DB2 Server
- Partitioned Database Environment
- Post-Installation Setup
- Installing and Configuring DB2 Client to DB2 Server Communications
- Installing and Configuring DB2 Client to DB2 Host Communications
- Installing DB2 Connect Personal Edition
- Configuring DB2 Clients in a Two-Tier Environment
- Configuring DB2 Clients in a Three-Tier Environment
- FCM Communication Buffers Considerations
- Summary
- Performance Tuning Examples
- Useful DB2 Commands
- parseSQL.pl
- exfmtDIF.pl
- Comparing Index Advisor Recommended Indexes with Existing Indexes
- Configuration Parameters That Can Be Changed Online
- Explain Tools
- Starting and Stopping a DB2 Instance
- LDAP Integration in DB2 UDB Using Microsoft Active Directory
- Tuning DB2 UDB in the IBM LDAP Environment
- DB2 Support Information
- DB2 Connect Implementation
- Sample Questions
- Answers to Sample Questions
- About the CD-ROM
- Article
Product information
- Title: Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®
- Author(s):
- Release date: July 2003
- Publisher(s): IBM Press
- ISBN: 9780130463883
You might also like
book
DB2® for z/OS® Version 8 DBA Certification Guide
A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 …
book
DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide
IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and …
book
DB2® Universal Database for OS/390® Version 7.1 Certification Guide
IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide! The only comprehensive IBM(r) …
book
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition
IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL …