DB2 105 Implementation Exploitation Author:Philip K. Gunning 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 appli... more »cations. 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.« less