Discovery > Discovery Modules > Database > IBM DB2 Database Discovery > DB2 Topology by SQL Adapter

DB2 Topology by SQL Adapter

This section includes details about the adapter.

ClosedID

SQL_APP_Dis_Db2

ClosedInput CIT 
Db2Database
ClosedInput TQL

ClosedTriggered CI Data
Name Value Description
alias_inst_ip_address ${ALIAS_INSTANCE.application_ip:!NA!} The IP address of the DB2 instance owning the corresponding alias, in the case when the trigger is Db2Alias with credentials_id reported.
alias_inst_ipse_ip_address ${ALIAS_INSTANCE_IPSE.bound_to_ip_address:!NA!}

The IpServiceEndpoint IP address used for establishing the SQL connection, in the case when the trigger is Db2Alias with credentials_id reported
alias_inst_ipse_port ${ALIAS_INSTANCE_IPSE.network_port_number:!NA!} The IpServiceEndpoint port used for establishing the SQL connection, in the case when the trigger is Db2Alias with credentials_id reported.
alias_inst_port ${ALIAS_INSTANCE.application_port:!NA!} The port number used by the DB2 instance owning the corresponding alias, in the case when the trigger is Db2Alias with credentials_id reported.
alias_cred_id ${DB2ALIAS.credentials_id:!NA!} The credentials_id used for establishing the SQL connection, in the case when the trigger is Db2Alias with credentials_id reported.
alias_name ${DB2ALIAS.name:!NA!} The alias name used as a DB name for establishing SQL connection, in the case when the trigger is Db2Alias with credentials_id reported.
db_instance_id ${DB_INSTANCE.root_id:!NA!} The Db2Instance CMDB ID, in the case when the trigger is Db2Database with credentials_id reported.
db_ipse_id ${DB_IPSE.root_id:!NA!} The IpServiceEndpoint CMDB ID, in the case when the trigger is Db2Database with credentials_id reported.
db_ipse_ip_address ${DB_IPSE.bound_to_ip_address:!NA!} The IpServiceEndpoint IP address used for establishing the SQL connection, in the case when the trigger is Db2Database with credentials_id reported.
db_ipse_port ${DB_IPSE.network_port_number:!NA!} The IpServiceEndpoint port used for establishing the SQL connection, in the case when the trigger is Db2Database with credentials_id reported.
host_id ${HOST.root_id} The Node CMDB ID containing the target DB2 database.
db_node_ip_address ${IpAddress.ip_address:!NA!} The Node IP address of Db2Database used for establishing a connection, in the case when the trigger is Db2Database with credentials_id reported.
db_cred_id ${SOURCE.credentials_id:!NA!} The DB2Database credentials_id used for establishing the SQL connection, in the case when the trigger is Db2Database with credentials_id reported.
db_id ${SOURCE.root_id} The Db2Database CMDB ID used to restore a CI, in the case when the trigger is Db2Database with credentials_id reported.
db_name ${SOURCE.name} The Db2Database name used for establishing the SQL connection, in the case when the trigger is Db2Database with credentials_id reported.
db_port ${SOURCE.application_port:!NA!} The Db2Database port used for establishing the connection, in the case when the trigger is Db2Database with credentials_id reported.
ClosedUsed Scripts

  • iteratortools.py

  • db2_pyarg_validator.py

  • db2_flow.py

  • db2_host.py

  • db.py

  • command.py

  • db_platform.py

  • process.py

  • db_builder.py

  • db2_discoverer.py

  • db2_sql_base_discoverer.py

  • db2_base_parser.py

  • db2_model.py

  • db2_sql_v9x_discoverer.py

  • db2_sql_discoverer.py

  • db2_topology.py

  • db2_topology_by_sql.py
ClosedDiscovered CITs
  • Composition
  • Containment
  • DB Data File
  • DB Table
  • DB Tablespace
  • DB2 Schema
  • Db2Alias
  • Db2BufferPool
  • Db2Database
  • DB2Instance
  • Db2Partition
  • Db2PartitionGroup
  • IpAddress
  • IpServiceEndpoint
  • Membership
  • Node
  • Process
  • Resource
  • Usage
ClosedParameters
Name Type Description
discoverTables boolean This flag indicates whether the job should discover tables.
discoverSystemTables boolean This flag indicates whether job should discover system tables. If discoverTables is false, this flag is considered false as well.