Customizing Application Performance Analyzer for use with DB2 Universal Database

This chapter describes the tasks for configuring the optional DB2® component. These tasks are required only if you plan to use any of the following Application Performance Analyzer features:
  • DB2 EXPLAIN
  • Report plan and package BIND timestamps
  • Display actual host variable names in SQL statements instead of :H.

We recommend that you work closely with a DB2 administrator to complete the following tasks:

  1. Deciding which authorization ID to use
  2. Binding a DB2 package and plan
  3. Enabling DB2 EXPLAIN
  4. Providing DB2 authorization
  5. Updating the Application Performance Analyzer-started task
  6. Updating the started task configuration settings