DB2: Universal Database Handbook for Windows and Unix Linux8 (IBM Press Series--Information Management) (Paperback)

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, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, 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. The book contains an extensive collection of IBM's most useful tips and tricks, designed to save DBAs and developers time and money -- while at the same time optimizing database performance and availability. 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. The IBM Press DB2 series presents not only the new features in Version 8, but also gives technical details about the new features, tips and tricks, and detailed examples.

IBM DB2 Universal Database V8 offers breakthrough availability, manageability, performance, and scalability. Now, straight from IBM, there's a start-to-finish guide to DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows.

This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, 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.

Using real-world examples, this book shows how to take full advantage of DB2 V8's most powerful enhancements. Philip K. Gunning brings together IBM's best tips and techniques for saving time and money in every facet of database design, development, deployment, and administration.

Coverage includes:

• Leveraging DB2 V8's new Wizards, Advisors, and other automation/self-management features
• Using the enhanced DB2 XML Extender to build next-generation B2B applications
• Quickly creating Stored Procedures and UDFs with the new Development Center
• Exploiting multidimensional clustering, prefetching, materialized query tables, Java threading, and other performance improvements
• Using the DB2 improved monitoring and logging facilities
• Maximizing availability via online table and index reorganization and dynamic configuration
• Understanding the latest changes in the DB2 product family