Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 and analyzing SQL explain information. Then, we will also touch upon different partitioning techniques available in DB2, and what a developer needs to know, to make sure that the application is well suited for such an environment.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint