Quest-Spotlight for DB2

1.1 Supported Platforms

• Operating Systems
  - Windows Server 2008 (32-bit or 64-bit) (Recommended for monitoring local databases only)
  - Windows Server 2012 (32-bit or 64-bit)
  - Windows Server 2016 (32-bit or 64-bit)
  - Windows Vista (32-bit or 64-bit)
  - Windows 7 (32-bit or 64-bit)
  - Windows 8 (32-bit or 64-bit)
  - Windows 8.1 (32-bit or 64-bit)
  - Windows 10 (32-bit or 64-bit)

• Firewall Requirement
  - Windows Server
  a) Port 135 (WMI) to Destination and WMI Random port 49152 - 65535 to Spotlight Client
  b) Spotlight requires the network setting “File and Print Sharing” to be enable
  - Database Monitor

  a) Database Port

• Hardware Require (Minimum)
  - Hard Disk space : 100 MB of disk space for installation
  - 512 MB of RAM minimum
  - 1 GB recommended Memory

• Video card and monitor capable of supporting a resolution of 1024 x 768 pixels or higher.

• Sound card and speakers : Spotlight can use sound to alert you when a threshold is reached. You must have a soundcard and speakers installed on your PC for this feature to work.

• Database Server
  IBM DB2 for LUW Runtime Client 9.5 or later, installed using the typical installation method.

• Browser Require
  Internet Explorer 6.0 or later

• Application Virtualization
  Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.

1.2 Required user authorities or privileges

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

• To monitor any DB2 database
  Spotlight invokes DB2 table functions to collect the raw processing data that it then translates into meaningful information about database performance. To call these APIs or invoke the table functions, Spotlight requires that the user ID that connects to the database have one of the following authorities on the DB2 instance containing the database:
  - SYSMAINT
  - SYSCTRL
  - SYSADM
  - SYSMON (or privileges equivalent to SYSMON authority)

• Additional privileges needed to monitor DB2 for LUW 9.5 or later databases
  In order for Spotlight to monitor a DB2 for LUW 9.5 or later database, the user ID that connects to the database must have EXECUTE privilege on the following table functions:
  - MON_GET_ACTIVITY_DETAILS (DB2 LUW 10.0 or later)
  - WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES_V97 (DB2 LUW 10.0 or later)
  - WLM_GET_SERVICE_SUBCLASS_STATS_V97 (DB2 LUW 10.0 or later)
  - WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97 (DB2 LUW 10.0 or later)
  - WLM_GET_WORKLOAD_STATS_V97 (DB2 LUW 10.0 or later)
  - 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

This chapter explains how to access the Spotlight on IBM DB2 LUW installation files and install Spotlight on a Windows machine. It also describes how to perform a silent install of Spotlight on IBM DB2 LUW.

2.1 Install Spotlight for DB2

Spotlight on IBM DB2 LUW is installed on a Windows machine that has a DB2 for LUW client already
installed. From this location, Spotlight can monitor IBM DB2 for LUW database residing on this same
machine or on a remote Linux, Unix, or Windows DB2 database server, as long as the databases on the
remote servers are cataloged on the DB2 client.

To Install Spotlight on a Windows machine :

1. Finding Installers : Download product from the Website or Log in Support Portal

2. Run the installer Click run as Administrator , Click Next

3. Click accept the license agreement , Click Next

4. Enter User Name, Organization , Click Next

5. Select Directory Location for install, Click Next

6. Begin installation process, installation complete Click Finish

2.2 Install Spotlight on IBM DB2 LUW silently

Enter the following command:
Spotlight_On_IBM_DB2_LUW_x_x_x_x.msi /qn INSTALLDIR=”” AllUsers="", where /qn =quiet,no UI, parameters INSTALLDIR specifies the directory and AllUsers specifies either All users (="1")or only the current user (="").
For example:
C:\Documents and Settings\Administrator>”C:\Documents and Settings\Administrator\ Desktop\ Spotlight_On_IBM_DB2_LUW_x_x_x_x.msi /qn INSTALLDIRR=”C:\Test|” AllUsers=""

3.1 Activate License Key- Spotlight for DB2

To license Spotlight on IBM DB2 LUW, you will need a license key and the site message.

• Obtain the License :
  The required license key is delivered in one of three ways:
  1. If you purchased Spotlight you receive an e-mail with the license key and site message shortly after
  the download has completed.
  2. If Spotlight was delivered in a package, the license key and site message are included with that
  package.
  3. If Spotlight was delivered as part of a trial, your sales representative should provide you with the
  license key.

• Specify the license to authorize your use of Spotlight
  After you have started Spotlight, you can authorize your use of Spotlight in one of two ways:
  1. If you attempt to open a feature from the Spotlight console, Spotlight displays a message window
  that states that Spotlight on IBM DB2 LUW is unlicensed. You can launch the authorization process
  from this message window.
  2. You can launch the authorization process from the About Spotlight window.

• To authorize your use of Spotlight from license message window
  1. From the message window that states you need to license Spotlight, click the Authorize button.
  2. On the Product Authorization window, provide the authorization (license) key, and then the site
  message.
  3. Click OK.

• To authorize your use of Spotlight from the About Spotlight window
  1. From the Spotlight console, select Getting Started Guide | About Spotlight.
  2. On the Installed products tab, click View/change product license for Spotlight on IBM DB2 LUW.
  3. On the License Viewer window, click Change this license for the installed version of Spotlight
  whose license you want to update.
  4. On the Product Authorization window, provide the authorization (license) key, and then the site
  message.
  5. Click OK to save the license information.
  6. Close the remaining windows.