July 2003
Intermediate to advanced
800 pages
20h 8m
English
book
Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®
by Dwaine R. Snow, Thomas X. Phan
Overview
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.