Spotlight® on DB2 for LUW

Version 6.7.1

Release Notes

September 2009

Welcome to Spotlight on DB2 for LUW	New in this Release	Resolved Issues and Enhancements	Known Issues	Third Party Known Issues
Upgrade and Compatibility	System Requirements	Global Operations	Getting Started	For More Information

Welcome to Spotlight on DB2 for LUW

This document describes the enhancements and resolved issues included in Spotlight on DB2 for LUW 6.7.1. It also lists known issues in the product, describes workarounds for these issues, and specifies up-to-date system requirements.

Spotlight on DB2 for LUW is a real-time monitoring solution from Quest Software. Designed to let DBAs keep watch on all critical DB2 components from a single interface, it features an accurate visual representation of the DB2 environment. From graphic overview screens, you can observe real-time activity across the Linux, Unix, and Windows databases in a DB2 instance. Various components show the changing status of connections, wait events, locking, memory, disk I/O, and performance bottlenecks. Alarms call attention to emerging problems based on thresholds you can specify. Drilldowns provide the information you need to diagnose these problems. You can use this information to quickly resolve performance issues as they occur.

New in This Release

Spotlight on DB2 for LUW 6.7.1 is a maintenance release containing primarily internal fixes and enhancements to the 6.7 release.

For a description of customer issues resolved in this release, see Resolved Issues and Enhancements in 6.7.1.
For a review of the new features and updates in the previously released Spotlight on DB2 for LUW 6.x releases, click the following links:

6.7

6.5.1

6.5

6.2.1

6.2

6.0

Updates and New Features in Spotlight on DB2 for LUW 6.7

Performance enhancements - Performance enhancements in this release include faster times for retrieving sub-drilldown information.
Support for DB2 for LUW 9.7 - Spotlight provides tolerance-level support for DB2 for LUW 9.7.
New metrics to support DB2 for LUW 9.7 - This release includes the following metrics for DB2 for LUW 9.7:
- On the Workload sub-drilldown in the Workload Management Analysis drilldown, new lifetime, execution-time, and queue-time statistics for coordinator activity.
- In the Workload Management Analysis drilldown, a new Address column to identify the IP addresses for workload occurrences.
- On the Details sub-drilldown on the Tablespace Analysis drilldown, a new Paths Dropped indicator to specify whether a tablespace resides in containers that no longer exist.
New Log Write Time per Transaction graph - This new visual on the Log Status sub-drilldown in the Database Analysis drilldown shows how much total commit time is spent writing information from the tablespace to the log. This graph replaces the Avg Log Space per Transaction graph on this sub-drilldown.
Diagnostic drilldown - This new drilldown retrieves event, diagnostic log, and notification messages for DB2 for LUW databases 9.5 and later. Because the volume of diagnostic information can be extensive, the drilldown lets you specify filters to extract the information you want to view. You can filter by internal or external messages, times ranges, facility type, or degree of impact.

Updates and New Features in Spotlight on DB2 for LUW 6.5.1

FDCC compliancy - Spotlight has received FDCC (Federal Desktop Core Configuration) certification.
Monitoring fixes applied - This release includes fixes to improve monitoring performance, especially in database-partitioned environments. Refer to Resolved Issues and Enhancements in 6.5.1 for the list of customer issues resolved in this release.
Knowledge Xpert links in help updated - The help links to Knowledge Xpert have been updated to support Knowledge Xpert 10.1 or greater.
Latest release of the Spotlight on Unix plug-in - The newest version of the Spotlight on Unix plug-in is installed with Spotlight on DB2.

Updates and New Features in Spotlight on DB2 for LUW 6.5

Improved performance for DB2 for LUW connections - Spotlight on DB2 takes advantage of new DB2 technology that allows the management of 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 the Database Analysis, Database Manager Summary, Client Applications Analysis, and Top SQL drilldowns.
Support for the latest release of Quest SQL Optimizer for DB2 LUW - Spotlight on DB2 integrates with the new 3.0 release of Quest SQL Optimizer for DB2 LUW to help you tune poorly performing SQL.
Latest release of the Spotlight on Unix plug-in - The newest version of the Spotlight on Unix plug-in is now available.
Workload Management Analysis drilldown - This new 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 - This new sub-drilldown provides DB2 Workload Management statistics about workload activity for each application connection.

Updates and New Features in Spotlight on DB2 for LUW 6.2.1

New option to monitor locks on all applications - The Client Application Analysis drilldown provides the option to collect lock information for all active applications in the database. Simply select Collect lock information for all applications on the Locking sub-drilldown.
New Toad Edition license - The Spotlight Toad Edition license is now available. This single-seat Spotlight license is offered in conjunction with a single-seat Toad for DB2 DBA license. It allows the user to open Spotlight sessions within Toad to monitor single-partition DB2 for LUW databases.

Updates and New Features in Spotlight on DB2 for LUW 6.2

Easier-to-read Spotlight Browser - A redesigned tree in the Spotlight browser makes the list of monitored databases and their partitions easier to read.
Option to monitor all active databases - A new option in the Connection Manager lets you monitor all databases belonging to the DB2 instance to which the database or database partition you are defining a connection for resides.
LDAP support - Connection Manager supports connections to LDAP databases. When you select the option to set up an LDAP connection, Connection Manager reads the LDAP server catalog to populate the list of available LDAP instances and databases from which to select your connection information.
Support for DB2 for LUW 9.5 - Spotlight on DB2 now supports DB2 for LUW 9.5.
Integration with Knowledge Xpert - Spotlight on DB2 What's This? help now links to Knowledge Xpert topics to provide more in-depth descriptions of DB2 operations.
Integration with Toad for DB2 - Certain Spotlight drilldowns let you open a Toad for DB2 session (or a Quest Central for DB2 session) to alter an object, review object properties, or update database configuration parameters.
Integration with SQL Optimizer - The Top SQL and Client Application Analysis drilldowns let you open Quest SQL Optimizer (or Quest Central for DB2 SQL Tuning) to tune problem application SQL.

Updates and New Features in Spotlight on DB2 for LUW 6.0

Updates in 6.0

Enhancements for Spotlight on DB2 for LUW 6.0 include the following:

Improved performance - Startup for Spotlight on DB2 has been enhanced to be significantly faster than previous versions.
Tree views in drilldowns - Drilldowns for databases, tablespaces, and buffer pools now use a tree view to show information across database partitions. At the top level of the tree is an aggregate row with consolidated information. At the lower level of the tree are rows with information for each database partition. Lower level rows descend from the aggregate row, which can be expanded and collapsed.
Criteria tab in drilldowns - Drilldowns for databases, tablespaces, buffer pools, and client applications now include a Criteria tab. As you view drilldowns, you can filter them based on criteria specified in the Criteria tab. Filtering lets you narrow the scope of the list shown in a drilldown. You can use it to focus on objects with a certain level of activity, certain attributes, or a certain current state. For example, you might filter a drilldown to see databases with the greatest I/O, tablespaces with the most direct writes, buffer pools with the lowest hit ratio, or applications that are currently connected.
Delta changes for metrics - A number drilldown columns now show delta changes for statistics. The delta is the change to a value since the last refresh of the interface. Delta changes are used primarily for I/O-related statistics.
Database display option - The drilldown for databases now includes the Show All Active Databases option. This lets you choose whether to display the active databases and partitions in an instance or all databases and partitions, whether active or inactive. The option is available on the shortcut menu that is brought up by right clicking a drilldown row.

Features in 6.0

New functionality for Spotlight on DB2 for LUW 6.0 includes many new features that are designed for use with DB2 for LUW 9. These features appear in the interface when Spotlight is connected to a version 9 database. Most incorporate metrics that are specific to DB2 for LUW 9. The main features related to version 9 databases are as follows:

HADR panel - The new HADR panel on the instance home page shows status and configuration for databases involved in high availability disaster recovery management. The information includes HADR role (standard or primary), current state, sync mode, status, number of missed heartbeats, timeout duration, and log gap. The Missed Beats component lights up when heartbeats are missed.
Buffer Pool Analysis drilldown - The I/O Times sub drilldown has been added to the Buffer Pools Analysis drilldown. The new sub drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a certain buffer pool.
Client Applications Analysis drilldown - The Lock Chains sub drilldown has been added to the Lock Chains sub drilldown. The new sub drilldown provides details about an application's lock relationships with other applications. It shows which applications are holding locks that an application is waiting for, which applications are waiting for locks held by an application, and whether locks are held by indoubt transactions.
Database Analysis drilldown - The History, Reorgs, and Utilities sub drilldowns have been added to the Database Analysis drilldown. The History sub drilldown shows the command history for all partitions of a database. The Reorgs sub drilldown lets you monitor table reorganizations for a certain database. The reorganizations include those that are currently in progress as well as those that are paused, stopped, or completed. The Utilities sub-drilldown shows the status of running utilities for a database or partition. You can use it to monitor the status and progress of backup, load, rebalance, restore, RUNSTATS, crash recovery, and rollforward recovery operations.
Database Manager Drilldown - Contacts, Paths, and Registry sub drilldowns have been added to the Database Manager drilldown. The Contacts sub drilldown lists individual contacts and contact groups that receive email or pager notifications after a task completes. The Paths sub drilldown shows the database paths used for database manager files and directories. The Registry sub drilldown shows the current DB2 registry settings for all partitions of a certain database.
Tablespace Analysis drilldown - The I/O Times, Quiescers, and Ranges sub drilldowns have been added to the Tablespace Analysis drilldown. The I/O Times sub drilldown provides graphs that contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a certain tablespace. The Quiescers sub drilldown provides information about the quiescer activity currently in progress. The Reorg sub drilldown allows you to monitor table reorganizations for a database. The reorganizations include those that are currently in progress as well as those that are paused, stopped, or completed. The new Tablespace Partition Information pane in the Details sub drilldown shows information is for a tablespace as it exists on a certain database partition.
Top SQL drilldown - This drilldown has been redesigned. At the top level, it now contains the Current SQL tab, Dynamic SQL tab, and Static SQL tab. At the sub-drilldown level, it contains the new Unit of Work tab for current SQL, the new Dynamic SQL Details tab for dynamic SQL, and the SQL Details tab for static SQL. The Current SQL tab shows metrics for statements that are currently executing in a database or partition. The Dynamic SQL tab shows metrics for dynamic SQL statements that are currently executing or have executed since a database was started. The Static SQL tab shows metrics for static SQL statements that are currently or have been executed since the current session was started. The drilldown is no longer filtered based on user-specified criteria. In addition, SQL Archive options in connection profiles now apply only to the Static SQL tab.

Resolved Issues and Enhancements

Click the following links to view the issues resolved and enhancements implemented in these Spotlight for LUW releases:

Current release 6.7.1

Resolved Issues and Enhancement in 6.7.1

The following issues and enhancements are addressed in the current release of Spotlight on DB2 LUW:

Feature	Resolved Issue	Change Request
Installation and startup	This fix includes the following: A resolution for the MSI installation issue. A workaround to disable the Spotlight Assistant at startup. A fix that properly enables the SQL Optimizer button on machines that use commas as decimal separators.	ST#62,134 Case#715713
General	The internal error "Interface not supported" no longer occurs in situations where a user navigates quickly between entries in a drilldown and the between the various sub-drilldowns for an entry.	ST#65,653 Case#740631
General	If you have not made changes to a connection, Spotlight no longer prompts you unnecessarily to save changes when you close the connection.	ST#66,593
Database Manager Summary drilldown	The range check error causing an exception on the Database Manager Summary drilldown is resolved.	ST#65,621 Case#703453
History browser	Viewing drilldown details via the History browser is no longer generating an "Interface not supported" error.	ST#56,180 Case#670846

Resolved Issues and Enhancements in 6.7

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.7:

Feature	Resolved Issue	Change Request
Database Manager drilldown	Selecting sub-drilldowns in the Database Manager Summary drilldown for a large database no longer causes internal errors.	ST#61,452 Case#701309
Databases drilldown	Graphs now display information properly on the Caching sub-drilldown.	ST#51,439 Case#636633
Buffer Pools drilldown	(DB2 for LUW 8) The Tables sub-drilldown now captures correct index tablespace information.	ST#48,801 Case#620443

Resolved Issues and Enhancements in 6.5.1

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.5.1.

Feature	Resolved Issue	Change Request
General	Customer issue involving table STMT refresh error is resolved.	ST#51,085 Case# 632811
	Spotlight links to Knowledge Xpert have been updated to work with latest Knowledge Xpert release.	ST#55,364 Case#666482
	Spotlight performance is improved when monitoring databases that contain a large number of tablespaces.	ST#57,312 57,586, 57,587 57,591 Case#676037
Database home page	The DMS Storage Utilization component is now displaying the correct storage amount.	ST#56,184 Case#670177, 658937
Database home page	The DMS Storage Utilization component no longer displays negative values.	ST#51,715 Case#635109
Client Applications drilldown	Table refresh error that occurs when attempting to view UOW details is resolved.	ST#51,716 Case#634961
Client Applications drilldown	Accessing the Lock Chains sub-drilldown no longer produces an error.	ST#55,676 Case#667944

Resolved Issues and Enhancements in 6.5

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.5.

Feature	Resolved Issue	Change Request
General	The "Load support for this column type not yet implemented..." error that occurred when refreshing the STMT table is fixed.	ST#51,085 Case#632811
Database home page	Spotlight is no longer showing an inaccurate high amount of DMS storage utilization on the home page.	ST#44,944 Case#529909, 612125, 656609
Database home page	The issue with the DMS utilization component showing negative values, a grayed-out cylinder, and a grayed-out Show Details option is resolved.	ST#51,715 Case#635109
Client Applications drilldown	The Table Statement Refresh error when attempting to open the Unit of Work Details sub-drilldown is no longer generated.	ST#51,716 Case#634961

Resolved Issues and Enhancements in 6.2.1

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.2.1.

Feature	Resolved Issue	Change Request
General	This release addresses the slow performance that was occurring when you switched between DB2 instances.	ST#50,147 Case#621197
Tablespaces drilldown	(DB2 for LUW 9 or greater) The File System Caching property on the Details sub-drilldown now displays the correct Yes or No setting for a given database environment.	ST#47,774 Case#612139
Tablespaces drilldown	When monitoring multiple databases belonging to the same DB2 instance, Spotlight no longer erroneously lists containers for databases other than the current database on the Containers sub-drilldown.	ST#47,775 Case#612141

Resolved Issues and Enhancements in 6.2

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.2.1.

Feature	Resolved Issue	Change Request
General	The calibration issue causing errors, including the "Overflow while converting variant of type... " exception, has been resolved.	CR#192890; ST#44,922 Case#450496; 422023; 440751; 451023
	Issues with Spotlight data not refreshing automatically are resolved.	CR#194115; ST#44,923 Case#459415
	Fixes have been added to correct high memory usage.	CR#201876; ST#44,928 Case#482005
	The refresh error generated when two Spotlights are monitoring the same instance has been resolved.	CR#202468; ST#44,929 Case#488887
	Home page elements (including Last Backup and Active Log values) are now reporting correct information.	CR#203481; ST#44,930 Case#488688; 505705; 506242; 591372; 592681
	High memory and CPU usage has been resolved.	CR#223573; ST#44,942 Case#541385
	The exception "Overflow while converting variant type" that occurs at various points in Spotlight has been resolved.	CR#223576; ST#44,943 Case#535406; 544871; 492903; 556224; 550222; 565196; 577622; 578816
	The refresh error "TUdbDataTableBufferpoolSQL" has been resolved.	CR#223705; ST#44,945 Case#506866; 575043; 577416
	Spotlight is no longer causing high spikes in CPU usage.	CR#223706; ST#44,946 Case#456078
Connection Manager
	Connection Manager supports connections to LDAP databases. When you select the option to create an LDAP connection, Connection Manager reads the LDAP catalog to provide a list of available databases from which to choose your connection.	CR#222998; ST#44,940 Case#547889
	You can now migrate connections from previous Spotlight installations, including Spotlight connections set up in Quest Central for DB2.	CR#230380; ST#44,955 Case#591753
Database home page	DMS space usage values are now in sync with space values in the Tablespaces drilldown.	CR#145488; ST#44,910 Case#364483
	Spotlight now uses the correct page size for tablespaces when calculating DMS space values.	CR#155772; ST#44,915 Case#392355; 585299
	The DMS Used Space statistic now matches data in the Tablespaces drilldown.	CR#195653; ST#44,924 Case#461892
	Spotlight now displays correct log Utilization and Secondaries values.	CR#206244; ST#44,933 Case#488691; 524249
	The abnormally high DMS Utilization value is now displaying correctly.	CR#223704; ST#44,944 Case#529909
	The mouse-over description for Deadlocks in the Database Information sections now correctly states that this is the total "since the database was started or statistics were reset."	CR#229219; ST#44,952 Case#578871
Alarm Log	Clicking the ? for a metric shows a help detail of its alarm (if the metric warrants an alarm).	CR#206657; ST#44,934 Case#496322
Bufferpool Analysis drilldown	The drilldown now reports bufferpool data correctly.	CR#198831; ST#44,925 Case#474767; 480037
Bufferpool Analysis drilldown	The drilldown is now displaying and reporting on all buffer pools.	CR#225058; ST#44,950 Case#540971; 584056
Client Applications drilldown	The Statistics tab maintains correct column-sort behavior between refreshes.	CR# 188837; ST#44,921 Case#454414
	The Details tab reports accurate connection start and complete times and the UOW start and stop times.	CR# 201183; ST#44,926 Case#484408
	The drilldown is not showing the correct agent ID and package and statement information for applications holding locks.	CR# 210667; ST#44,936 Case#494052
Database Manager Summary drilldown	The "Invalid column name..." exception is fixed.	CR#230179; ST#44,953 Case#582048
Databases drilldown	The drilldown is now reporting on all elements (specifically, Buffer Pool Log Space Cleaners Triggered and Lock List Utilization) on the sub-drilldowns.	CR#155431; ST#44,914 Case#391636
Databases drilldown	The "Overflow while converting variant of type..." exception that occurs when accessing the drilldown has been resolved.	ST#45,826 Case#597378
Top SQL drilldown	The drilldown now reports unit of work SQL.	CR#187419; ST#44,919 Case#450632
	Slow performance in retrieving SQL has been resolved.	CR#224859; ST#44,949 Case#552826
	Spotlight's inability to collect SQL data when monitoring several instances in the Spotlight session is resolved.	ST#47,158 Case#601319-1
Documentation	The Installation Guide, Release Notes, and online help now list the authorities and privileges needed to run Spotlight on DB2 for LUW 8 and 9 databases.	CR#216518; 44,937 Case#526472
Documentation	The problem character (initially a dash, but translated as the 3/4 character) has been removed from the balloon help topics.	CR#224221; 44,948 Case#554227

Resolved Issues and Enhancements in 6.0.1

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.0.1.

Feature	Resolved Issue	Change Request
General	(For DB2 for LUW 9 databases only) Spotlight no longer generates an invalid column type error during a refresh.	CR#228069 Case#566530
Connection Manager	You can now set up connections to LDAP databases using a workaround.	CR#222998 Case#547889
Connection Manager	Spotlight no longer generates a "Datasource error inconnection" error when you attempt to connect to DB2 for LUW 9 databases.	CR#225057 Case#544757
Databases drilldown	(For DB2 for LUW 8 databases only) Spotlight no longer generates an overflow error when converting a variant of the DOUBLE type into an INTEGER type on the Details sub-drilldown.	CR#223576 Case#492903, 535406, 544871, 550222, 556224, 565196
Client Applications drilldown	The drilldown now provides an option to return only active applications.	N/A

Resolved Issues and Enhancements in 6.0

The following issues and enhancements were addressed in Spotlight on DB2 for LUW 6.0.

Feature	Resolved Issue	Change Request
Improved performance	In addition faster performance at startup, performance has been improved in components such as the Client Applications drilldown. Previously, performance in this drilldown was sometimes slow during collection of lock data for tasks on which thousands of locks were held.	CR#197482 Case# 456681, 468236, 479548 & 512683
Partition IDs	The correct numbers for database partitions are now shown in drilldowns that display the unique identifiers for partitions.	CR# 195654 Case# 468229, 469836 & 482437
Automatic refresh of drilldowns	Drilldowns are now automatically refreshed with data when they are opened. Previously, a "No Data" message was sometimes incorrectly shown when a drilldown was opened.	CR# 195655 Case# 441353, 457475, 46981, 473236, 482449, 489002, 90555, 490877 & 495174
Support for very large buffer pools	Spotlight on DB2 now displays information for very large buffer pools, such as those whose size is shown with seven-digit integers. Previously, when a very large buffer pool was selected, either a "No Data" message was shown or an arithmetic overflow or exception occurred.	CR# 145192 Case# 367542, 374301, 379351, 408018 & 409856
Buffer Pool Analysis drilldown	The Buffer Pools drilldown now shows correct hit ratios.	N/A
Tablespaces drilldown	Tablespace information is now shown in the Tablespaces drilldown when data is available. Previously, a "No Data" message was sometimes shown when data was available.	CR# 195655 Case# 441353, 457475, 469841, 473236, 482449, 489002, 490555, 490877 & 495174
Timestamp in the Top SQL drilldown	The correct timestamp is now shown in the Last Time Executed column of the Top SQL drilldown. This column is available when Spotlight on DB2 is connected to a DB2 8.1 database.	Case# 504712
EOleConversion error in Databases Drilldown	An EOleConversion error no longer occurs in the Details sub drilldown for the Databases drilldown. Previously, the error occurred when English language settings were not selected in the Windows Regional and Language Options.	N/A
Help for Alarm Log	The help topic for the Alarm Log now displays when the help icon is clicked in the title bar.	CR# 167961 Case# 408177

Known Issues

The following issues are known to exist at the time of this release.

Feature	Known Issue	Change Request
Connection profiles	After an upgrade to Spotlight on DB2 LUW 6.2 or later, connection profiles from previous versions might no longer connect to their target databases. If you encounter this issue, try saving the profiles. If they still do not connect to their target databases, create new profiles using the Connection Manager in version 6.2 or later of Spotlight on DB2 for LUW. However, before creating new profiles, delete old profiles and their folders on the Spotlight client machine. (This requirement also applies when you delete connection profiles for which the DB2 Auto Monitor Nodes option is selected.) Profile folders have the same names as their connections. To determine the path to the Folders profile that contains them, check the Spotlight console Options window. The path is shown in the File locations pane. The window is opened by selecting View \| Options \| Spotlight Console. The default path to the Profiles folder is as follows: C:\Documents and Settings\All Users\Application Data\Quest Software\Shared\Profiles	N/A
Monitor switches	When monitoring DB2 for LUW 9 databases, the connection profile monitor switch options have no effect on monitor switches. The method of data collection on version 9 databases requires the user to alter the status of instance level monitor switches to collect the desired data.	N/A
Alarm Log	The Alarm Log does not display alarms for connections to DB2 for LUW 9 databases under all circumstances. In order to display alarms for connection profiles for version 9 databases, you need to do one of the following: Select the All Connections view from the list at the top of the drilldown. or Select the DB2 for LUW 9 database for which you want to view alarms in the Live Connections list. Then display the Alarm Log and select the connection profile for the database from the list at the top of the window.	N/A
Alarm Log	The Alarm Log does not display alarms for automatically created connection profiles when the All Connections view is selected. (Connection profiles can be automatically created using by the UDB Auto Monitor Nodes option.) In order to display alarms for these connection profiles, you need to: Select a database with an automatically created profile in the Live Connections list. Display the Alarm Log. Select the connection profile for the database from the list at the top of window.	N/A
Knowledge Xpert integration	To enable Knowledge Xpert links in the Spotlight help, you must have Knowledge Xpert 10.1 or greater installed. Additionally, you must uninstall any previous versions of Knowledge Xpert on your machine, including the Knowledge Xpert installed with Quest Central for DB2. Knowledge Xpert 10.1 does not work with Quest Central for DB2. Therefore, to enable the Knowledge Xpert links in Spotlight, you no longer have Knowledge Xpert integration with Quest Central for DB2.	ST#57,295
Foglight integration	Invoking this release of Spotlight from Foglight is not supported. A Quest Central for DB2 fix pack to address this issue should be available in the near future.	N/A

Third-Party Known Issues

The following are known IBM DB2 for LUW issues that affect Spotlight on DB2.

Feature	Known Issue	APAR Numbers
Event monitors	THE DB2 UDB INSTANCE MAY CRASH AFTER A TRAP IN THE FUNCTION LOAD_DCS_APPLID_INFO. THIS HAPPENS MORE ON WINDOWS THAN ON OTHER PLATFORMS… The crash occurs when the Event Monitor is trying to access an application that has not fully initialized or is in the process of terminating. In either case, the application client’s SETI pointer is NULL. Fix: Version 8, FixPak 11	IY76570
Counters	In DB2 for LUW 8 ESE (multiple-node) environments, you might experience some counters that show negative numbers. This is an intermittent problem, primarily affecting statistics counters in the Client Applications and Databases drilldowns. Fix: No fix as yet	68754.756
Percent of Max component	When Spotlight monitors a DB2 for LUW 8 database, the Percent of Max component shown on the Client Apps panel of the database and node home pages might show inconsistent percentage values. These inconsistencies occur because the maxappls database configuration parameter in DB2 for LUW 8 can be a system-controlled value. The default setting of Automatic for this parameter in DB2 means that DB2 dynamically assigns resources as needed to support new applications. It is recommended that you turn off the default alarm for the metric behind the Percent of Max component in Spotlight. See Viewing and editing metrics in the Spotlight Basics online help for details on disabling the capture of a specific metric or on disabling its thresholds that can generate alarms.	N/A
Circular loopback databases	Spotlight encounters issues when it monitors a DB2 for LUW database that is cataloged as a circular loopback in the database directory.	N/A

Upgrade and Compatibility

If you have a previous version of the Spotlight on DB2 for LUW client installed on your machine, you can choose to upgrade the previous version to 6.7.1 or install version 6.7.1 in a different directory (the advanced option in the client installation wizard). If you install in a different directory, you can run the 6.7.1 version side by side with previous versions of Spotlight on DB2 for LUW or with other installations of version 6.7.1. In addition, you can run Spotlight on Oracle and Spotlight on SQL Server side by side with Spotlight on DB2 for LUW.

System Requirements

To install and run Spotlight on DB2 for LUW, ensure your system meets the following minimum hardware and software requirements. Refer to the Spotlight on DB2 for LUW Installation Guide for detailed system requirement information, including recommended DB2 maintenance levels.

Requirements for the client computer

Requirements for servers with monitored databases

Requirements for the Quest Central for DB2 Agent

Requirements for integration with Knowledge Xpert

Additionally, Spotlight users need the authority described in Required Authority or Privileges.

Requirements for the Client Computer

Operating System	• Windows 2003 (32-bit) Note: This version is recommended for monitoring local databases only. • Windows XP (32-bit) • Windows Vista (32-bit)
Memory	512 MB RAM (minimum); 1 GB (recommended) For multi-partitioned environments, upgrade memory as needed.
Hard Disk Space	60 MB of free hard-disk space
DB2 Client	IBM DB2 for Linux, Unix, and Windows (LUW) Runtime Client 8.1 or later, installed using the typical method installation

Requirements for Servers with Monitored Databases

DB2 Data Server

• IBM DB2 for Linux, Unix, or Windows (LUW) Enterprise Server Edition (ESE) 8.1 (with FixPak 1 applied) or later (64-bit); 9.1 or later (64-bit)

• For a DB2 for LUW 8 server on which you want to monitor SMS space, Toad for DB2 Agent 5.1 or later (or Quest Central for DB2 Agent 4.5 or later)

Requirements for the Toad for DB2 Agent or Quest Central for DB2 Agent

To enable Spotlight to monitor SMS tablespaces in a DB2 for LUW 8 environment, you must install either the Toad for DB2 Agent or the Quest Central for DB2 Agent 4.5 or later on each DB2 for LUW 8 server whose databases you are monitoring.

Note: Spotlight does not require the agent to monitor SMS tablespaces in a DB2 for LUW 9.1 or later environment. Additionally, agent installation is not required when the Spotlight client and the DB2 for LUW 8 server are installed on the same machine or when a 4.5 or later version of the Quest Central for DB2 Agent already exists on the server.

Both agents run on any of these platforms:

Operating System

• Microsoft Windows 2000, 2003 (32-bit), XP (32-bit), Vista (32-bit)
• Sun Solaris 7 or later
• IBM AIX 4.3 or later
• SuSE Linux Enterprise Server 8 and 9 for zLinux
• SuSE Linux Enterprise Server 8 and 9 United Linux for Intel x86
• SuSE Linux (2.6 Kernel) on AMD64 (x86_64)
• RedHat Enterprise Linux AS 3.0 and 4.0 zLinux (32-bit)
• Red Hat Enterprise Linux AS 2.1, 3.0, and 4.0 for Intel x86
• RedHat Enterprise Linux AS 4.0 (2.6 Kernel) on AMD64 (x86)

Note: For Red Hat Linux, you must install the compat-libstdc++-7.3-2.96.122.i386.rpm compatibility library. You will find this package on the RedHat Advanced Server 3.0 installation CDs.

Note: For Sun Solaris 7 servers, you must apply Sun Solaris 7 patch 106327. If this patch is not already applied, you can apply it as part of the agent installation and configuration process described in Spotlight on DB2 for LUW Installation Guide.

Requirements for Integration with Knowledge Xpert

To take advantage of links to Knowledge Xpert topics in Spotlight's What's This? help on the home pages, you must have Knowledge Xpert for DB2 10.1 or later installed. Additionally, you must uninstall any previous versions of Knowledge Xpert on your machine.

Required Authority or Privileges

To Install Spotlight

To install Spotlight on a Windows 2003 machine, the installer must be either a Standard user (belonging to the Power Users Group) or an Administrator.

To Install the Quest Central for DB2 Agent

To install the Toad for DB2 Agent or the Quest Central for DB2 Agent on a Windows machine, the installer must have administrative privileges on that machine.

To Run Spotlight

Spotlight either calls DB2 snapshot APIs (for DB2 for LUW 8) or invokes IBM table functions (for DB2 for LUW 9.1 or later) to collect the raw processing data that it then translates into meaningful performance information. To run Spotlight, you need any one of the following authorities on each DB2 instance you are monitoring:

SYSMAINT
or
SYSCTRL
or
SYSADM
or
SYSMON (or privileges equivalent to SYSMON authority)

Note: Spotlight on DB2 installation does not create any database objects. Therefore, aside from the required user authority, Spotlight does not grant or require any additional privileges on objects.

Additionally, to monitor a DB2 for LUW 9.5 or later database, Spotlight requires that the user ID connected to the database must have EXECUTE privilege on the following table functions:

WLM_GET_ACTIVITY_DETAILS
WLM_GET_QUEUE_STATS
WLM_GET_SERVICE_CLASS_AGENTS
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES
WLM_GET_SERVICE_SUBCLASS_STATS
WLM_GET_SERVICE_SUPERCLASS_STATS
WLM_GET_WORK_ACTION_SET_STATS
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES
WLM_GET_WORKLOAD_STATS

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America.

Getting Started

Refer to the following sections for information about starting Spotlight on DB2 for LUW:

Contents of the Release Package

Installation Instructions

MSI Installation of Spotlight on DB2

Contents of the Release Package

The Spotlight on DB2 for LUW 6.7.1 release package contains the following products:

Spotlight on DB2 for LUW 6.7.1
Product documentation, including:
- Spotlight on DB2 for LUW Installation Guide
- On-line help

Installation Instructions

Spotlight on DB2 for LUW 6.7.1 has its own installation executable. This is available on the Spotlight installation CD or can be downloaded from either http://www.quest.com/spotlight-on-db2/ or http://support.quest.com (SupportLink). For additional information, refer to the Spotlight on DB2 for LUW Installation Guide, also available on SupportLink. The guide includes instructions for installing both the Spotlight client and the Quest Central for DB2 Agent. (Instructions for installing the Toad for DB2 Agent are found in the Toad for DB2 LUW Agent Installation Guide.) The agent must be installed if you want to monitor SMS (system-managed space) tablespaces on DB2 for LUW 8 database servers.

After you install Spotlight on DB2 for LUW, you can run it as a standalone product, as a component of Quest Central for DB2, or as a component of Toad for DB2.

MSI Installation of Spotlight on DB2

MSI installers are available on Spotlight for DB2. These installers can be run silently, and produce an installation that can be captured and re-used via automatic deployment techniques.

Contact Quest Software for more information about Spotlight MSI installation.

For More Information

Contacting Quest Software:

Email	info@quest.com
Mail	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web	http://www.quest.com

Refer to our Web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

Quickly find thousands of solutions (Knowledgebase articles/documents).
Download patches and upgrades.
Seek help from a Support engineer.
Log and update your case, and check its status.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

www.quest.com

Email: legal@quest.com

Refer to our web site for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.