---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# IBM Db2 on Windows database

# IBM Db2 on Windows database discovery {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

ServiceNow
Discovery uses the Db2 on Windows discovery pattern to find IBM Db2 instances on Windows servers.
Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).

Discovery uses this pattern to run horizontal discovery. The pattern is triggered automatically by classification using these Db2 identifiers: tcp_port, name, installed_dir

## Prerequisites {#ibm-db2-windows-discovery__section_ybt_bn4_xkb}

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\\""
{#ibm-db2-windows-discovery__ul_hj3_31y_hnb}

## Data collected by Discovery during horizontal discovery {#ibm-db2-windows-discovery__section_qpx_dn4_xkb}

The discovered data includes the following tables and fields.
{#ibm-db2-windows-discovery__table_dvm_gn4_xkb__entry__2}

| 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. |
[ ]

{#ibm-db2-windows-discovery__table_dvm_gn4_xkb}

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

<br />

## CI relationships {#ibm-db2-windows-discovery__section_epg_ln4_xkb}

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

