ServiceNow Discovery uses the Db2 on Windows discovery pattern to find IBM Db2 instances on Windows servers.

Discovery uses this pattern to run horizontal discovery. You can use the pattern on the ServiceNow AI Platform using the Istanbul release or later.

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Prior to the Yokohama release, the Db2 on Windows was discovered by probe. From the Yokohama release, the pattern is triggered automatically by classification using these Db2 identifiers: tcp_port, name, installed_dir

Prerequisites

Ensure that the user has the permissions to run the following commands:
  • "\"" + $installed_dir + "\bin\db2cmd\" /c /w /i db2 list database directory"
  • "\"" + $installed_dir + "\bin\db2cmd\" /c /w /i db2 list database directory | findstr \"Database name\" | findstr /i " + $entry_point.instance
  • "\"" + $installed_dir + "\bin\db2level\""

Data collected by Discovery during horizontal discovery

The discovered data includes the following tables and fields.

Table and fieldDescription
name Name of the Db2 instance.
tcp_port TCP port.
installed_dir The installation directory.
version Db2 version.
db_name Name of the database.
pid Process ID of the Db2 instance.

The Dependency Views map shows all discovered IBM Db2 instances in your organization and the relationships between them.


IBM Db2 Windows Dependency view

CI relationships

The IBM Db2 on Windows pattern does not create any CI relationships.