Features and Benefits

Spotlight on DB2 LUW 6.5

• Improved performance for DB2 for LUW connections - Spotlight on DB2 takes advantage of new DB2 technology that allows you to manageme multiple instance attachments with little impact on performance. 
• Full support of DB2 for LUW 9.5 metrics - New statistics for OLAP functions, RUNSTATS activities, and workloads are available on Spotlight's Database Analysis, Database Manager Summary, Client Applications Analysis, and Top SQL drilldowns.
• Workload Management Analysis drilldown - Provides a comprehensive look at DB2 Workload Management (WLM) information and statistics captured for your DB2 for LUW 9.5 database. The drilldown covers five major WLM areas -- service classes, workloads, work classes, work actions, activities, and threshold queues -- that you can explore through summary information and sub-drilldowns.
• New Workload Activities sub-drilldown added to the Client Applications Analysis drilldown - Provides DB2 Workload Management statistics about workload activity for each application connection.