Defining a Db2 subsystem

Each OMEGAMON® Collector monitors the Db2 subsystem on which it is installed. The OMEGAMON Collector collects the performance data of the subsystem and stores it in its DB2PM database.

To monitor a Db2 subsystem from Performance Expert Client, you must establish a connection between Performance Expert Client and the OMEGAMON Collector installed on the Db2 subsystem so that Performance Expert Client can access the performance data of this subsystem. You do this by defining the Db2 subsystem:
  1. On the System Overview window, click Monitor > New Db2 System.

    The New Db2 System wizard is displayed.

  2. On the Object tab, click Db2 on z/OS, OS/390 systems, and then click Next.
  3. On the Data Collector tab, specify the connection to the Db2 subsystem on which OMEGAMON Collector is installed:
    Host
    The MVS host name.
    Port
    Specify the port number to which the Performance Expert Client can connect when communicating with the OMEGAMON Collector. The port number specifies the TCP/IP port on which the server listens for incoming sessions of Performance Expert Client for the specified Db2 subsystem.

    If you do not know this information, contact your database administrator (DBA).

  4. Click Next.
  5. On the Db2 Subsystem tab, do one of the following:
    • Click Retrieve to use the Db2 subsystem information defined on the host.

      The Logon window is displayed.

    • In the User ID field, type your MVS host user ID. In the Password field, type your password. Then click OK.

      The Db2 Subsystem page of the New Db2 System window is displayed. For the Name field, OMEGAMON for Db2® Performance Expert supplies the same value as for the Database alias field. Ensure that the name is unique throughout Performance Expert Client.

    • Type the values for the following fields:
      Name
      Type a name for the Db2 subsystem that is unique throughout all Db2 subsystems. If you clicked Retrieve, this field shows the same value as the Database alias field. Ensure that this value is unique throughout Performance Expert Client.
      Database alias
      Type the alias of the Db2 subsystem location. If you clicked Retrieve, this field shows the alias of the Db2 subsystem location as defined on the host. The specified alias will appear in the folders pane of the System Overview window.
      MVS system
      The name of the MVS system.
      Data Sharing Group
      If the Db2 subsystem is a member of a data sharing group, type the group name here.
      Data Sharing Member
      If the Db2 subsystem is a member of a data sharing group, type the member name here.
      Description
      Use this field for a description of the Db2 subsystem. This field is optional.
      Local DB alias
      If you want to use Query Workload Tuner, type the local database alias of the Db2 subsystem.
  6. Click Next.
  7. On the Performance Warehouse tab, you can associate a Performance Warehouse system with the Db2 subsystem you are defining. You must specify a Performance Warehouse system if you want to create SQL activity traces.

    In the Database alias field, type the alias of the Performance Warehouse database that is maintained by the OMEGAMON Collector that monitors this Db2 subsystem. This is the database alias that you specified when cataloging the DB2PM database of the OMEGAMON Collector.

    For further information about cataloging the DB2PM database, see Configuration and Customization.

  8. Click Next.
  9. On the DSM Information tab, you specify the settings for the Data Server Manager (DSM) Server:
    Protocol
    The transfer protocol to be used for the Data Server Manager (DSM) Server. This can be HTTP or HTTPS.
    DSM Server
    Shows the host name of the DSM Server. When the Protocol field has been set to HTTPS, this value should be matched to the host name specified in the public key stored in TrustStore.
    DSM Port
    The port number for the Data Server Manager.
    TrustStore
    The path to the TrustStore file. TrustStore should have the public key for the host name in the DSM Server field. If the Protocol is HTTP, this field is greyed out.
    DSM user
    The user ID for logging into DSM.
    DSM user password
    The user password for logging into DSM.
    DSM connection
    The profile name for the monitored subsystem. For example, VB6A_RS29. When the SSL Secured checkbox is checked, this profile name is the Database connection name in the DSM Database Connections, and this profile should have SSL connectivity as JDBC security.
    SSL Secured
    This checkbox enables SSL Secured connections. Note: there must be a predefined DSM connection in order to use SSL.
    JDBC URL
    The URL for the monitored Db2 subsystem. If the SSL Secured box is checked, this field is greyed out.
    Explain SQLID
    An optional field that tells the tuning service to use the Explain tables pertaining to a specific SQLID. If this field is blank, the PE Client logon user ID will be used as the Explain SQLID.
  10. Click Next.
  11. On the Db2zAI tab, specify the configuration properties for the IBM Db2 AI for z/OS (Db2zAI) integration.
    Note: Db2zAI integration is valid only for Db2 13 and Db2 12 subsystems.
    Protocol
    The transfer protocol (HTTPS only) to be used for the Db2zAI Server. This field is display only (cannot be edited).
    Server
    The host name of the Db2zAI Server.
    SA Port
    The Db2zAI System Assessment HTTPS port number. For more information, see https://www.ibm.com/support/knowledgecenter/en/SSGKMA_1.2.0.1/src/ai/ai_configurenetworkport.html
    UI Port
    The Db2zAI User Interface port number. For more information, see https://www.ibm.com/support/knowledgecenter/en/SSGKMA_1.2.0.1/src/ai/ai_configurenetworkport.html
    User
    The user ID for logging into Db2zAI. This ID must have proper authorization on the Db2zAI connection related to the respective Db2 subsystem connection.
    Password
    The password for logging into Db2zAI.
    Start time (-)
    (Default = 6) The number of hours before the exception timestamp at which point the Db2zAI assessment is started. For example, if an exception occurs at 5pm, and the Start time (-) is 2h and End time (+) is 1h, the assessment period would have a start time of 3pm and an end time of 6pm.
    End time (+)
    (Default = 1) The number of hours after the exception timestamp at which point the Db2zAI assessment is ended. For example, if an exception occurs at 5pm, and the Start time (-) is 2h and End time (+) is 1h, the assessment period would have a start time of 3pm and an end time of 6pm.
  12. Click Finish.

    The Db2 subsystem is shown in the System Overview window under the z/OS folder.