DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (IBM DB2 Certification Guide Series) - Softcover

Baklarz, George; Wong, Bill

Softcover

ISBN 10: 0130463612 ISBN 13: 9780130463616

Publisher: IBM Press, 2003

Synopsis

Appropriate for all courses in IBM DB2 Version 8 database administration, and all courses preparing students to pass IBM's new DB2 certification exams (Exam 512: Fundamentals and Exam 513: Administration).

In this book, two of IBM's leading DB2 consultants present the only complete, start-to-finish guide to DB2 Universal Database V8/8.1 administration and development for UNIX, Linux, and Windows platforms, and the first authoritative preparation guide for IBM's latest DB2 certification exams (512 and 513). This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V8 and V8.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB V8 from other databases or earlier versions of DB2; and much more. It also contains an unparalleled collection of IBM tips for maximizing database performance, availability, and efficiency. The accompanying CD-ROM contains a complete trial version of DB2 UDB V8 Personal Edition, as well as bonus study questions for IBM's latest DB2 certification exam.

About this title

From the Back Cover

DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning,enhance business intelligence, and maximize performance, scalability, and reliability.

Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... and authoritative preparation for IBM's newest DB2 certification exam.

This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database v8, including best practices for DB2 database design and development; day-to-day administration and backup; expert techniques for deploying networked, Internet-centered, and XML-based database applications; migrating to DB2 UDB v8; and much more.You'll also find an unparalleled collection of IBM tips and tricks for maximizing the performance, availability, and value of any database system. Coverage includes:

• Manageability and serviceability enhancements, including new tools for storagemanagement and monitoring database health
• Performance improvement withmultidimensional clustering, enhanced prefetching, threading of Java UDFs and storedprocedures, and materialized query tables
• New Setup wizards, configuration assistants, GUItools, and DB2 Administration Server (DAS) improvements
• Availability andscalability enhancements
• New DB2 v8 Replication and Data Warehouse Centers
• Major improvements for developers, including SQL, XML, JDBC, and CLIenhancements

Whether you're a DBA, a developer, a DB2 certification candidate, or all three, DB2Universal Database v8 for Linux, UNIX, and Windows Database AdministrationCertification Guide is the one book you can't afford to be without.

• Straight from IBM, the ultimate guide to running DB2 v8 and preparing for IBM's latest DB2certification exam!
• In-depth coverage of DB2 v8 database administration and development
• Covers new DB2 v8 enhancements in manageability, serviceability, reliability, availability, and performance
• Contains in-depth coverage of new DB2 v8 tools, including the Replication, Data Warehouse, and Development Centers
• Presents expert tips and best practices from IBM's own DB2 customer support organization

About the CD

The CD-ROM included with this book contains a complete trial version of DB2 UDB V8Personal Edition, plus the DB2DEMO program to help explore the many features of DB2.

Synopsis

Straight from IBM, this is the only book to offer complete, start-to-finish coverage of DB2 Universal Database V8 administration and development for UNIX, Linux, Windows, and OS/2 exam. This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V8.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. DB2 Version 8 represents one of the most feature-packed significant releases in DB2's history! With Version 8 key topics such as Performance Enhancements, Manageability Enhancements, etc are addressed.

Edition details

• Publisher: IBM Press
• Publication date: 2003
• ISBN 10: 0130463612
• ISBN 13: 9780130463616
• Binding: Paperback
• Language: English
• Edition number: 5
• Number of pages: 912