This chapter lists the hardware and software requirements for installing Spotlight on IBM DB2 LUW.
System requirements for Spotlight
System requirements for each DB2 database you want to monitor
Required user authorities or privileges
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.
The Windows machine on which you intend to install the Spotlight on IBM DB2 LUW client must meet the requirements listed below.
The client machine platform must be one of the following:
Note: Recommended for monitoring local databases only.
Note: We recommend using an Administrator account to run Spotlight. If you use a non-administrator windows account to run Spotlight, the login account must belong to the "DB2ADMIN" or "DB2USER" user group. We do not recommend using a non-administrator windows account to run Spotlight.
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Hard Disk Space |
100 MB of disk space for installation |
|
Monitor |
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. |
| CD-ROM requirement | If you are installing Spotlight from compact disc, the CD-ROM drive should be attached to the machine on which you are installing Spotlight. If a local CD-ROM is not available, you can use a drive mapped to a network device. |
| Browser |
Internet Explorer 6.0 or later |
| Database Server | IBM DB2 for LUW Runtime Client 9.5 or later, installed using the typical installation method. |
| Application Virtualization | Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2. |
Spotlight monitors the following IBM DB2 for LUW Enterprise Server Edition (ESE) databases (64-bit), installed either on the client machine where Spotlight is installed or on remote servers:
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.
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:
Note:Spotlight on IBM DB2 LUW installation does not create any database objects. Therefore, aside from the required user authority, Spotlight does not grant or require any additional privileges on DB2 objects.
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
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
