Windows performance objects

You use performance objects to monitor and view database information about a database instance or application, or a DCS database or application.

Windows provides the following performance objects:
  • Database Manager

    This object provides general information for a single Windows instance. The database instance being monitored appears as the object instance.

    For practical and performance reasons, you can only get performance information from one database instance at a time. The database instance that the Performance Monitor shows is governed by the db2instance registry variable in the Performance Monitor process. If you have multiple database instances running simultaneously and want to see performance information from more than one, you must start a separate session of the Performance Monitor, with db2instance set to the relevant value for each database instance to be monitored.

    If you are running a partitioned database environment, you can only get performance information from one database partition server at a time. By default, the performance information for the default database partition (that is, the database partition that has logical port 0) is displayed. To see performance information of another database partition, you must start a separate session of the Performance Monitor with the DB2NODE environment variable set to the database partition number of the database partition to be monitored.

  • Databases

    This object provides information for a particular database. Information is available for each currently active database.

  • Database Applications

    This object provides information for a particular database application. Information is available for each currently active database application.

  • DCS Databases

    This object provides information for a particular DCS database. Information is available for each currently active database.

  • DCS Applications

    This object provides information for a particular DCS application. Information is available for each currently active DCS application.

Which of these objects will be listed by the Windows Performance Monitor depends on what is installed on your Windows computer and what applications are active. For example, if the database manager is installed has been started, the Database Manager object will be listed. If there are also some databases and applications that are currently active on that computer, the Databases and Database Applications objects are listed as well. If you are using your Windows system as a Db2 Connect gateway and if DCS databases and DCS applications are currently active, the DCS Databases and DCS Applications objects are listed.