Chapter 7. Advanced DB2 Application Features and Practices
In this chapter, we will focus on following recipes related to advanced database features that include:
- Working with OLAP functions
- Using optimizer profiles
- Using explain utilities
- Using section explain information
- Interpreting db2exfmt output
- Application development in partitioned databases
Introduction
In this chapter, we will focus on some advanced DB2 features that are useful for analyzing and troubleshooting application performance. We will discuss some OLAP functions, which are very powerful in computing complex use cases in a very simple manner. Then we will discuss how we can influence DB2 optimizer to choose our guidelines. We will also look at different tools available for capturing ...
Get IBM DB2 9.7 Advanced Application Developer Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
