This is IBM's definitive guide to the newest version of DB2 Universal Database. It contains end-to-end coverage for every DB2 developer and administrator--and for anyone who wants to achieve IBM DB2 certification. Covers the latest UDB 6.21 features for all platforms: Windows, UNIX, and OS/2--including installation, networking, security, SQL, data integrity, recovery, optimization, and more.

DB2 Universal Database version 7.1 for UNIX, Linux, Windows and 0S/2 Database Administration Certification Guide, 4th edition.

bull; Covers all the material you need to know to pass the exam using sample exam questions and answers bull; Written by a DB2 Certified expert who was involved in the development of the Version 8 certification exams and the author of 7 best-selling DB2 titles! bull; Part of the IBM Press DB2 Series

The first start-to-finish guide to IBM's brand-new DB2 Application Developer certification exam! Write DB2 applications using Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, Perl DBI, stored procedures, and more! Leverage new DB2 extenders for searching documents, XML composition/decomposition; managing multimedia databases, and more. Complete cross-platform coverage for UNIX, Linux, Windows and OS/2 environments! IBM has just expanded its highly successful DB2 certification program to include a developer's exam -- and this is the first book to offer start-to-finish preparation! The book covers every DB2 Application Developer exam objective, and includes a complete sample exam. Start by reviewing the DB2 client/server environment, comparing the multiple programming interfaces available to DB2 application developers, and understanding when to choose each. Next, walk through the fundamentals of DB2 application development with Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, and the Perl DBI. Learn how to create effective stored procedures, and when to use them. Discover how to use DB2 extenders to enhance your application's functionality, adding more effective search features, XML support, multimedia archive management, and more. Steve Sanyal is a Software Developer for the DB2 Universal Database Application Development Team at the IBM Toronto Lab. He specializes in JDBC, SQLJ and CLI/ODBC, and leads IBM's project to develop Java and XML-based performance and troubleshooting tools for DB2. David Martineau is a Staff Software Developer providing technical support for the DB2 UDB Application Development Team. He has provided sample code for DB2 UDB using interfaces such as ADO, CLI and Net.Data. Michael Kyprianou has worked with DB2 Universal Database and its predecessors since 1995. He is an IBM Advanced Technical Expert in DB2 DRDA and certified in DB2 UDB Database Administration and Application Development. Kevin Gashyna is a DB2 Universal Database application development specialist specializing in DB2 Extenders and Net.Data.

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 CDThe 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.