Overview

A practical how-to guide with particular emphasis on SQL and performance and a hands-on understanding of how to work with this specific database management system developed by IBM, this book provides DB2 database administrators and developers with the essential information to implement, exploit, support, and maintain DB2 10.5 databases and applications. It introduces BLU Acceleration, a collection of technology innovations from the IBM Research and Development Labs that speed up reporting and analytics. Readers will also learn about DB2 10.5 enhancements in SQL, performance, high availability, manageability, monitoring and tuning, workload management, server client and drivers, packaging, and DB2 pureScale, as well as troubleshooting and problem determination. Two chapters are dedicated to application development in the areas of stored procedures and triggers, including implementation, monitoring, and tuning--information lacking in most books on those topics. The chapter on SQL tuning is unique in that it provides real-life SQL problem scenarios and practical DB2 SQL tuning solutions, techniques, methodology, and examples based on the author's extensive experience helping clients succeed with DB2.

Full Product Details

9781583473740

Table of Contents

Reviews

Author Information

Philip K. Gunning is the principal of Gunning Technology Solutions, which provides DB2 consulting to firms throughout North America and Europe, and is active in the International DB2 User Group, where he serves on the Solutions Journal editorial board. He is the author of DB2 9 for Developers and DB2 Universal Database v8 Handbook for Windows, UNIX, and Linux. He lives in Sinking Spring, Pennsylvania.

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available