IBM Db2 on Linux database discovery

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • ServiceNow Discovery uses the Db2 on Linux discovery pattern to find IBM Db2 instances on Linux 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 Linux 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

    Configure SSH credentials for the Linux server.

    In addition, ensure that the user has the permissions to run the following commands:

    Identification for Db2 UDB entry point types
    ". /" + $process.environmentVariables.HOME.value + "/sqllib/db2profile; " + $process.environmentVariables.HOME.value + "/sqllib/bin/db2level"
    "source " + $installed_dir + "db2profile"
    "db2 list database directory | grep \"Database name\" | grep -i \"" + $entry_point.instance + "\" | head -1"
    "db2level | grep \"DB2 v\""
    Identification for Db2 UDB entry point types - NONE
    "cat " + $installed_dir + "/db2dump/db2diag.log | grep \"INSTANCE:\" | grep " + $entry_point.instance + " | head -1"
    "db2level | grep \"DB2 v\""
    Identification for Db2 on z/OS
    "netstat -a | grep " + $entry_point.port
    "ls -d /*/* |grep " + $id

    Data collected by Discovery during horizontal discovery

    The Identification for Db2 UDB entry point types and Identification for Db2 UDB entry point types – NONE sections collect the following tables and fields:
    Table and field Description
    name The Db2 instance name
    tcp_port TCP port
    installed_dir Installation directory
    version Db2 version
    The Identification for Db2 on Z/OS section collects the following tables and fields:
    Table and field Description
    name The Db2 instance name
    tcp_port TCP port
    installed_dir Installation directory
    The Dependency Views map shows all discovered IBM Db2 instances in your organization and the relationships between them.
    IBM db2 dependency view

    CI relationships

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