Configuring IBM Db2 Monitoring

Download this manual as a PDF file

This section describes how to configure and discover IBM Db2 databases for monitoring by Skylar One using the "IBM: Db2" PowerPack.

Use the following menu options to navigate the Skylar One user interface:

Prerequisites for Monitoring IBM Db2

To configure the Skylar One system to monitor IBM Db2 databases using the "IBM: Db2" PowerPack, you must first perform the following prerequisites, which are based on your operating system.

After you have configured Skylar One to monitor IBM Db2 databases and you have discovered an IBM Db2 server and all associated component devices, make sure that the ports for the IBM Db2 instance are open to the Skylar One Data Collector.

Prerequisites for Linux/Unix Users

  1. Create a shell session and SSH into the Db2 database you want to monitor.

  2. Create a new group to monitor by entering the following command:

    sudo groupadd <group_name>

  3. Create a new user for the group you created by entering the following command:

    sudo useradd -u <user_id> -g <group_name> -m -d /home/<user_name> <user_name>

  4. Set a password for the user you created by entering the following command:

    sudo passwd <user_name>

  5. Log in with the instance admin user. For example: su - db2inst1

  6. Run the following commands:

    db2 update database manager configuration using SYSMON_GROUP <group_name>

    db2stop

    db2start

  7. Connect to your database with the following command:

    db2 connect to <db_name>

  8. Run the following command to grant the DATAACCESS privilege to the user:

    db2 "grant DATAACCESS ON DATABASE TO USER <user_name>"

    NOTE: If you do not want to grant DATAACCESS privilege to the user, ScienceLogic provides a Bash and SQL scripts in a .zip file in the PowerPack download folder that grants the user permissions required to monitor Db2 databases.

    • The Bash script grants required permissions to monitor Linux Db2 databases. To use the Bash script in the Linux Db2 server:
      • Copy the Bash script named grant_mon_per.sh to the Linux Db2 server.
      • Give the execute permission to the script with: chmod +x grant_mon_per.sh
      • Log in with the instance administrator user, for example: su -db2inst1.
      • Run the script with the following command in the same directory where you copied the script above. Replace the required information before running the command:
      • ./grand_mon_per.sh <DB_NAME> <DB_USER> <mon_user_name>
        • DB_NAME: Database name you want to grant permissions
        • DB_USER: The Db2 instance admin user. For example: su - db2inst1
        • mon_user_name: The new user name that you want to grant the permissions to.
      • Enter the database password of the instance admin user. The required permissions should be configured.

  9. Verify permissions with the following commands:

    db2 connect to <db_name> user <user_name> using <user_password>

    db2 "select SUBSTR(AUTHORITY,1,30), D_USER, D_GROUP, D_PUBLIC, ROLE_USER, ROLE_GROUP, ROLE_PUBLIC, D_ROLE from table (sysproc.auth_list_authorities_for_authid(CURRENT_USER, 'U'))"

    NOTE: Repeat steps 5 - 8 for each Db2 instance.

The user you create will likely need to use KornShell (for Unix systems) or Bash (for Linux systems).

If you are unsure of the shell directory, you can use the command which ksh to determine the KornShell directory, or which bash to determine the Bash directory.

After you have determined shell directory, run the following commands, replacing <shell_directory> with the KornShell or Bash directory:

sudo useradd -u <user_id> -g <group_name> -s <shell_directory> -m -d /home/<user_name> <user_name>

You should not use Shell (sh) as the shell for the user. Using Shell for the user shell could result in shell-related errors appearing in the Device Log.

Prerequisites for Windows Users

NOTE: Before performing the steps for the Windows prerequisites, ensure that you have followed the steps in the Configuring Windows Servers for Monitoring with PowerShell section of the Monitoring Windows Systems with PowerShell manual.

Windows users will need to create a local user and group for the Db2 database. If you have already done so, proceed to adding the group to the instance database manager.

To create the user and group:

  1. Click Start and select Run.
  2. In the Run window, enter lusrmgr.msc and click OK.
  3. In the Local Users and Groups pane, select the Users folder.
  1. Click the Action menu and select New User.... Enter the new user's information in the New User window and click Create.
  2. In the Local Users and Groups pane, select the Groups folder.
  3. Click the Action menu and select New Group.... Enter the new group's information in the New Group window and click Create.
  4. To add the new user to the group, double-click on the group name.
  5. Click the Add... button under the Members window and enter the username. Click OK.

NOTE: You may need to add the user to the Administrators group in order to use PowerShell remoting if you don't have a PowerShell group/policy in place for non-adminstrative users.

Next, you will need to add the group you created to the instance database manager:

  1. Log in to the Db2 database as the instance admin user.

  2. Open the Db2 admin shell.

  3. Run the following commands:

    db2 update database manager configuration using SYSMON_GROUP <group_name>

    db2stop

    db2start

     

Next, you will grant the DATAACCESS privilege to the new user:

  1. Log in to the Db2 database as the instance admin user.

  2. Open the Db2 admin shell.

  3. Run the following commands:

    db2 connect to <database>

    db2 "grant DATAACCESS on database to user <user_name>"

NOTE: If you do not want to grant DATAACCESS privilege to the user, ScienceLogic provides a Bash and SQL scripts in a .zip file in the PowerPack download folder that grants the user permissions required to monitor Db2 databases.

NOTE: You will need to grant this access to each database.

NOTE: Perform the steps to add the group to the instance database manager and to grant the DATAACCESS privilege for each Db2 instance that you will monitor.

Creating Credentials for IBM Db2

To monitor Db2 databases using Skylar One, you must create two credentials. These credentials enable Skylar One to collect data from your Db2 databases. The types of credentials that are required for monitoring depend on the type of database being monitored:

In addition, if the password has changed for the account with access to the Db2 database, you will need to update the corresponding Database credential.

Skylar One will use SSH or PowerShell at the beginning, and then the client provided by IBM. Skylar One uses the instance database manager user to connect to the Db2 database.

Creating an SSH/Key Credential (Linux and Unix Users)

Linux and Unix users must create an SSH/Key credential.

NOTE: If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create an SSH/Key credential:

  1. Go to the Credentials page (Manage > Credentials).

  1. Locate the DB2 SSH Example credential, click its Actions icon () and select Duplicate. A copy of the credential, called DB2 SSH Example copy appears.
  2. Click the Actions icon () for the DB2 SSH Example copy credential and select Edit. The Edit Credential page appears. Update the following fields:

  1. Supply values in the following fields:

The private key can have a maximum of 64 characters per line. Therefore, you cannot use keys in the OpenSSH format, because that format uses 70 characters per line. When you attempt to save the credential, Skylar One will validate that the private key entered is in the correct format. You will be able to save the credential only if the private key is correctly formatted.

NOTE: If you are using a PEM key in the SSH/Key credential, then in your SOAP/XML credential you must fill in the HTTP Auth User and HTTP Auth Password fields with credentials for the same user.

  1. Click the Save & Close button.

NOTE: The credential ID will appear in the Credentials page (Manage > Credentials) after it has been saved. Take note of the ID as you will need it when creating the SOAP/XML credential. If you cannot see the ID column in the Credentials page, click the gear icon () in the upper-left corner of the page and select Id to view the column.

Creating an SSH/Key Credential (Linux and Unix Users) in the Skylar One Classic User Interface

Linux and Unix users must create an SSH/Key credential.

To create an SSH/Key credential:

  1. Go to the Credential Management page (System > Manage > Credentials).
  2. Click the wrench icon () for the "DB2 SSH Example" credential. The Credential Editor modal page appears.
  3. Supply values in the following fields:

The private key can have a maximum of 64 characters per line. Therefore, you cannot use keys in the OpenSSH format, because that format uses 70 characters per line. When you attempt to save the credential, Skylar One will validate that the private key entered is in the correct format. You will be able to save the credential only if the private key is correctly formatted.

NOTE: If you are using a PEM key in the SSH/Key credential, then in your SOAP/XML credential you must fill in the HTTP Auth User and HTTP Auth Password fields with credentials for the same user.

  1. Click the Save As button.
  2. When the confirmation message appears, click OK.

NOTE: The credential ID will appear at the top of the window after it has been saved. Take note of the ID as you will need it when creating the SOAP/XML credential.

Creating a PowerShell Credential (Windows Users)

Windows users must create a PowerShell credential.

If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create a PowerShell credential:

  1. Go to the Credentials page (Manage > Credentials).

  1. Locate the DB2 PowerShell Example credential, click its Actions icon () and select Duplicate. A copy of the credential, called DB2 PowerShell Example copy appears.
  2. Click the Actions icon () for the DB2 PowerShell Example copy credential and select Edit. The Edit Credential page appears.
  3. Supply values in the following fields:

The following fields reflect fields that appear in generic PowerShell credentials and might not yet appear in the DB2 PowerShell Example copy credential.

  1. Click the Save & Close button.

Creating a PowerShell Credential (Windows Users) in the Skylar One Classic User Interface

Windows users must create a PowerShell credential.

To create a PowerShell credential:

  1. Go to the Credential Management page (System > Manage > Credentials).
  2. Click the wrench icon () for the "DB2 Powershell Example" credential. The Credential Editor modal page appears.
  3. Supply values in the following fields:
  1. Click the Save As button.

Creating a SOAP/XML Credential (Linux and Unix Users)

After configuring the SSH/Key credential, you must then create a SOAP/XML credential.

NOTE: If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create the SOAP/XML credential:

  1. Go to the Credentials page (Manage > Credentials).

  1. Locate the DB2 Soap with SSH Example credential, click its Actions icon () and select Duplicate. A copy of the credential, called DB2 Soap with SSH Example copy appears.
  2. Click the Actions icon () for the DB2 Soap with SSH Example copy credential and select Edit. The Edit Credential page appears. Update the following fields:

  1. Update the values in the following fields:

NOTE: If the HTTP Auth User and HTTP Auth Password fields are blank, then the Dynamic Applications in the IBM: Db2 PowerPack will use the credentials provided in the SSH/Key credential.

NOTE: In versions of the PowerPack prior to version 103, headers required the "<DB_NAME>" value. This value is no longer needed and can be deleted after you upgrade the PowerPack.

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

NOTE: By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder name/program files">

  1. Click the Save & Close button.

Creating a SOAP/XML Credential (Linux and Unix Users) in the Skylar One Classic User Interface

After configuring the SSH/Key credential, you must then create a SOAP/XML credential.

To create the SOAP/XML credential:

  1. Go to the Credential Management page (System > Manage > Credentials).
  2. Click the wrench icon () for the "DB2 Soap with SSH Example" credential for Linux/Unix users. The Credential Editor modal appears.
  3. Update the values in the following fields:

Basic Settings

NOTE: If the HTTP Auth User and HTTP Auth Password fields are blank, then the Dynamic Applications in the IBM: Db2 PowerPack will use the credentials provided in the SSH/Key credential.

HTTP Headers

NOTE: In versions of the PowerPack prior to version 103, headers required the "<DB_NAME>" value. This value is no longer needed and can be deleted after you upgrade the PowerPack.

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

NOTE: By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder name/program files">

  1. Click the Save As button.

Creating a SOAP/XML Credential for an SSL Certificate (Linux and Unix Users)

After configuring the SSH key, you must create a SOAP/XML credential with an SSL certificate if your Db2 server contains an SSL connection.

NOTE: If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create the SOAP/XML credential:

  1. Go to the Credentials page (Manage > Credentials).
  2. Locate the DB2 Soap SSL with SSH Example credential, click its Actions icon () and select Duplicate. A copy of the credential called DB2 Soap SSL with SSH Example copy appears.
  3. Click the Actions icon () for the DB2 Soap SSL with SSH Example copy credential and select Edit. The Edit Credentials page appears.

 

  1. Update the values in the following fields:

NOTE: If the HTTP Auth User and the HTTP Auth Password fields are blank, then the Dynamic Applications in the IBM: Db2 PowerPack will use the credentials provided in the SSH key.

In versions of the PowerPack prior to version 103, headers required the <DB_NAME> value. This value is no longer needed and an be deleted after you upgrade the PowerPack.

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder/name/program files">

The certificate path should be a path of the "Collector Unit" where the SSL certificate is located. For example: /tmp/certificate.cer. The permissions for the SSL certificate file should be at least "read" and "write" for the owner, and "read" for the group and others. The permissions for the directory that contains the SSL certificate should be at least "read", "write", and "execute" for the owner, and "read" and "execute" for the group and others.

  1. Use default values for all other fields.
  2. Click Save & Close.

Creating a SOAP/XML Credential for an SSL Certificate (Linux and Unix Users) in the Skylar One Classic User Interface

After configuring the SSH key, you must create a SOAP/XML credential with an SSL certificate if your Db2 server contains an SSL connection.

To create the SOAP/XML credential:

  1. Go to the Credential Management page (System>Manage>Credentials).
  2. Click the wrench icon () for the "DB2 Soap SSL with SSH Example" credential for Linux/Unix users. The Credentials Editor modal appears.
  3. Update the values in the following fields:

Basic Settings

NOTE: If the HTTP Auth User and the HTTP Auth Password fields are blank, then the Dynamic Applications in the IBM: Db2 PowerPack will use the credentials provided in the SSH key.

In versions of the PowerPack prior to version 103, headers required the <DB_NAME> value. This value is no longer needed and an be deleted after you upgrade the PowerPack.

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder/name/program files">

  1. Use default values for all other fields.
  2. Click the Save As button.

Creating a SOAP/XML Credential (Windows Users)

After configuring the PowerShell credential, you must then create a SOAP/XML credential.

NOTE: If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create the SOAP/XML credential:

  1. Go to the Credentials page (Manage > Credentials).

  1. Locate the DB2 Soap with PowerShell Example credential, click its Actions icon () and select Duplicate. A copy of the credential, called DB2 Soap with PowerShell Example copy appears.
  2. Click the Actions icon () for the DB2 Soap with PowerShell Example copy credential and select Edit. The Edit Credential page appears. Update the following fields:

  1. Update the values in the following fields:

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a Database credential.

NOTE: By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder name/program files">

  1. Click the Save & Close button.

Creating a SOAP/XML Credential (Windows Users) in the Skylar One Classic User Interface

After configuring the PowerShell credential, you must then create a SOAP/XML credential.

To create the SOAP/XML credential:

  1. Go to the Credential Management page (System > Manage > Credentials).
  2. Click the wrench icon () for the "DB2 Soap with PowerShell Example" credential for Windows users. The Credential Editor modal page appears.
  3. Update the values in the following fields:

Basic Settings

HTTP Headers

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a Database credential.

NOTE: By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder name/program files">

  1. Click the Save As button.

Creating a SOAP/XML Credential for an SSL Certificate (Windows Users)

After configuring the PowerShell credential, you must create a SOAP/XML credential with an SSL certificate if your Db2 server contains an SSL connection.

NOTE: If you are using a Skylar One system prior to version 11.1.0, the new user interface does not include the Duplicate option for sample credential(s). ScienceLogic recommends that you use the classic user interface and the Save As button to create new credentials from sample credentials. This will prevent you from overwriting the sample credential(s).

To create the SOAP/XML credential:

  1. Go to the Credentials page (Manage > Credentials).
  2. Locate the DB2 Soap SSL with PowerShell Example credential, click its Actions icon () and select Duplicate. A copy of the credential called DB2 Soap SSL with PowerShell Example copy appears.
  3. Click the Actions icon () for the DB2 Soap SSL with PowerShell Example copy credential and select Edit. The Edit Credentials page appears.

 

  1. Update the values in the following fields:
    • Name. Type a new name for the credential.
    • All Organizations.Toggle on (blue) to align the credential to all organizations, or toggle off (gray) and then select one or more specific organizations from the What organization manages this service? drop-down field to align the credentials with those specific organizations.
    • URL. Leave the default value of https://%D.
    • HTTP Auth User. If you are inserting the database username and password in the PowerShell credential, leave this field blank.
    • HTTP Auth Password. If you are inserting the database username and password in the PowerShell credential, leave this field blank.
    • HTTP Headers. Add the following headers by clicking + Add a header:
      • instance: <Instance Name>:<Port>
      • For example:instance:db2inst1:6000
      • instance:<Instance Name2>:<Port2>
      • For example: instance:db2inst2:6000
      • powershell:<PowerShell Credential ID>

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder/name/program files">

The certificate path should be a path of the "Collector Unit" where the SSL certificate is located. For example: /tmp/certificate.cer. The permissions for the SSL certificate file should be at least "read" and "write" for the owner, and "read" for the group and others. The permissions for the directory that contains the SSL certificate should be at least "read", "write", and "execute" for the owner, and "read" and "execute" for the group and others.

 

  1. Use default values for all other fields.
  2. Click Save & Close.

Creating a SOAP/XML Credential for an SSL Certificate (Windows Users) in the Skylar One Classic User Interface

After configuring the PowerShell credential, you must create a SOAP/XML credential with an SSL certificate if your Db2 server contains an SSL connection.

To create the SOAP/XML credential:

  1. Go to the Credential Management page (System>Manage>Credentials).
  2. Click the wrench icon () for the "DB2 Soap SSL with PowerShell Example" credential for Windows users. The Credentials Editor modal appears.
  3. Update the values in the following fields:

Basic Settings

NOTE: You can create a header for each Db2 instance you have.

NOTE: During the discovery process, these headers will either find an existing Database credential that matches the user, password, port, and default database, or it will create a new Database credential.

By default, the SOAP/XML credential deletes any white space before and after the colon (:) in the credential headers. If you want to include paths with white spaces in the credential, surround the path with double quotes after the colon. For example: <base_db2_path:"/opt/folder/name/program files">

The certificate path should be a path of the "Collector Unit" where the SSL certificate is located. For example: /tmp/certificate.cer. The permissions for the SSL certificate file should be at least "read" and "write" for the owner, and "read" for the group and others. The permissions for the directory that contains the SSL certificate should be at least "read", "write", and "execute" for the owner, and "read" and "execute" for the group and others.

  1. Use default values for all other fields.
  2. Click the Save As button.

Updating the Database Credential

If the password has changed for the account with access to the Db2 database, you must also update the corresponding Database credential in Skylar One. Otherwise, you can skip this section.

To update the Database credential:

  1. Go to the Credentials page (Manage > Credentials).
  2. Search for and locate the credential that includes the name and port of the database with the updated password, then click the credential's Actions icon () and select Edit/Test.
  3. In the Edit Credential page that appears, type the new password in the Password field.
  4. Click Save & Close.

Discovering IBM Db2 Component Devices

To discover an IBM Db2 database:

  1. On the Devices page () or the Discovery Sessions page (Devices > Discovery Sessions), click the Add Devices button. The Select page appears:

Image of the Add Devices wizard, page 1

  1. Click the Unguided Network Discovery button. Additional information about the requirements for discovery appears in the General Information pane to the right.
  1. Click Select. The Add Devices page appears.
  2. Complete the following fields:
  1. Click Next. The Credentials page of the Add Devices wizard appears:

Image of the Add Devices wizard, page 2

  1. On the Credentials page, locate and select the SOAP/XML credential you created for the Db2 database.
  1. Click Next. The Discovery Session Details page of the Add Devices wizard appears:

Image of the Add Devices wizard, page 2

  1. Complete the following fields:

In the Advanced options section, click the down arrow icon () to complete the following fields:

  1. Click Save and Run if you enabled the Run after save setting, or Save and Close to save the discovery session. The Discovery Sessions page (Devices > Discovery Sessions) displays the new discovery session.
  2. If you selected the Run after save option on this page, the discovery session runs, and the Discovery Logs page displays any relevant log messages. If the discovery session locates and adds any devices, the Discovery Logs page includes a link to the Device Investigator page for the discovered device.

Discovering IBM Db2 Component Devices in the Skylar One Classic User Interface

To discover an IBM Db2 database:

  1. Go to the Discovery Control Panel page (System > Manage > Classic Discovery or System > Manage > Discovery in the classic user interface).
  2. In the Discovery Control Panel, click the Create button. The Discovery Session Editor page appears.
  1. Optionally, you can enter values in the other fields on this page. For more information about the other fields on this page, see the Discovery & Credentials section.
  2. Click the Save button to save the discovery session and then close the Discovery Session Editor window.
  3. The discovery session you created appears at the top of the Discovery Control Panel page. Click its lightning-bolt icon () to run the discovery session.
  4. The Discovery Session window appears. When the cluster root device(s) are discovered, click the device icon () to view the Device Properties page for each device.

Verifying Discovery and Dynamic Application Alignment

To verify that Skylar One has automatically aligned the correct Dynamic Applications during discovery:

  1. After the discovery session has completed, go to the Devices page or the Device Manager page (Devices > Classic Devices, or Registry > Devices > Device Manager in the classic user interface) and find the device(s) you discovered. When you have located the device, click on its name or click on its edit icon ().
  2. Click the Collections tab.
  3. All applicable Dynamic Applications for the Db2 devices are automatically aligned during discovery.

    It can take several minutes after the discovery session has completed for Dynamic Applications to appear in the Dynamic Application Collections page.

To verify alignment of the IBM Db2 Dynamic Applications:

  1. After discovery has completed, go to the Discovery Logs page (Devices > Discovery Sessions > click the Actions button for that session > click Show Logs) and click on the IP address of the device. If you are in the classic user interface, click the device icon for the IBM Db2 device (). From the Device Investigator page for the IBM Db2 device, or the Device Properties page if you are in the classic user interface, click the Collections tab. The Dynamic Application Collections page appears.

    It can take several minutes after the discovery session has completed for Dynamic Applications to appear in the Dynamic Application Collections page.


  1. All applicable Dynamic Applications are automatically aligned to the root device and component devices during discovery:

You should see the following Dynamic Application aligned to the root device:

  1. IBM DB2: Server Discovery

You should see the following Dynamic Application aligned to the Db2 server:

You should see the following Dynamic Application aligned to the Db2 instance:

You should see some or all of the following Dynamic Applications aligned to the Db2 database:

You should see the following Dynamic Applications aligned to the Db2 tablespace:

NOTE: The IBM Db2 PowerPack uses db2ilist to discover all Db2 instances, but the Dynamic Applications will be aligned to only the instances specified in the SOAP/XML credential headers.

Viewing IBM Db2 Component Devices

In addition to the Device Manager page (Devices > Classic Devices, or Registry > Devices > Device Manager in the classic user interface), you can view the IBM Db2 server and all associated component devices in the following places in the user interface: