Spotlight on SAP ASE 2.12 - User Guide

Setting up a connection profile

Before Spotlight can monitor a DB2 database or database partition, you must connect to that system. If you have not connected to the database or database partition in Spotlight before, you must set up a connection profile for that system.

For an overview of the process, see To connect to systems in Spotlight basics help. For Spotlight on IBM^® DB2^® LUW, use the procedure below.

Note: Options in the DB2 Monitor Switch Settings section of the Properties window are not used for connections to DB2 version 9. For version 9 and later, you need to alter the status of instance-level monitor switches to collect the desired data.

To set up a connection profile

1. Click the Connect icon in the Spotlight toolbar to open the Spotlight Connection Manager.

2. In the Connections bar on the left, click Spotlight on IBM DB2 LUW to display the connections currently defined for DB2 for LUW databases and database partition.

3. In the Spotlight on IBM DB2 LUW pane on the right, double-click New connection.

4. In the New Connection window, identify the connection:

   Select connection type	Select Spotlight on IBM DB2 LUW.
   New connection name	Enter a unique name for the connection. This name will identify the connection on the Spotlight browser.

5. Click OK to open the Properties window for the new connection. The Details tab on this window is in focus.

6. In the DB2 Details section, enter the information that connects Spotlight to the DB2 database or specific database partition:

   DB2 Instance	The name of the DB2 instance as defined on the database server.
   DB2 Database	Enter the alias of the DB2 database that you want to monitor in this connection.
   DB2 Auto Monitor Nodes	For a multiple-partition database, select this option if you want the Connection Manager to set up a separate connection automatically for every partition (node) for the database. (The alternative for monitoring a multiple-partition database is to select an option in the DB2 Node field.) When you select DB2 Auto Monitor Nodes, the DB2 Node field is disabled.
   DB2 Auto Monitor Active Databases	Select this option if you want Spotlight to monitor all active databases residing in the instance in which the database or database partition for which you are creating this connection resides. When Spotlight connects to this database or database partition, it also connects to all the other active databases in the instance. These databases are listed in the browser pane. You can monitor their home pages and drilldowns just as you can for the database whose connection you set up.
   DB2 Node	For a multiple-partition database, select Global if you want the Connection Manager to establish a single connection that aggregates statistics for all partitions for the database. Or select the number for the specific partition to establish a connection for that database partition only. For a single-partition database, select Global.
   DB2 User	Enter the user ID with which to connect to the DB2 database.
   DB2 Password	Enter the password with which to connect to the DB2 database.

7. In the SQL Archive Options section, set the options that run the Spotlight SQL Statement Archiver for this connection; these are used for static SQL statements:

   Archive Default Startup	To turn the Archiver on or off for this connection, select Archive SQL statements or Do not archive SQL statements, respectively.
   Archive Capacity	Enter the number of distinct static SQL statements that the Archiver will collect before it starts dropping statements. Enter 0 (zero) if you want to set no limit on the number of distinct SQL statements that the Archiver can collect.

8. In the Method to Retrieve Data section, select an option from which to retrieve data.

   Shapshot Routines	Select this option to use the snapshot function to retrieve data from the server.
   Monitor Functions	Select this option to use the mon-table to retrieve data from the server.

9. In the OS Details section, provide the information that Spotlight needs to monitor the operating system on which the database or database partition runs. For detailed information about connecting to a specific operating system type, refer to the Spotlight on Unix, Spotlight on Windows, or Spotlight on Windows Clusters help (accessed from the Help|Contents option).

   OS Monitor	Select this option if you want Spotlight to monitor the operating system on which the database or database partition runs. When you select this option, specific fields listed below are enabled.
   OS Type	Choose the operating system type of the target machine. For Unix machines, make sure that either RECEX or SSH is installed.
   OS Local Machine	(For a Windows target machine only) Select this option if the machine you are currently using is the one you want to monitor. If you select this option, you need to complete only the OS Address field.
   OS Domain	(For a Windows target machine only) Enter the domain to which the specified user (in the OS User field) belongs. If you entering no user in the OS User field, leave this field blank.
   OS Address	Enter the address of the target machine: For a Windows machine, enter its IP address, hostname , or URL. For a Linux or Unix machine, enter its connection string.
   OS User	Enter a valid user ID or account to log on to the target machine. For Windows machines, Spotlight needs to use an account with the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the target machine allows this.
   OS Password	Enter the password used to log on to the target machine.
   OS Port	(For a Unix SSH target machine only) Enter the port number that Spotlight will use for its SSH (secure shell) connection to the Unix host. The default value is 22.

10. Select Save password details (for this connection) to save the user ID and password information with this connection. Each time you open this connection in Spotlight, you will not have to provide the user ID and password.

If you unselect this option, you are prompted to provide the DB2 User and DB2 password values each time you open this connection in Spotlight. If Spotlight monitors the operating system also for this connection, you are prompted to provide the OS User and OS Password information as well.

11. Click OK to add the new connection to the list of DB2 for LUW connections.