IBM Db2 on Windows database discovery

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 Washington DC release, the Db2 on Windows was discovered by probe. From the Washington DC 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 field	Description
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.

CI relationships

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