DB2 Topology by SQL Job

ID: SQL_APP_Dis_Db2

db2withuser.xml

In the diagram above, Db2Database should have reported credentials dictionary entry(credentials_id).

db2_alias_with_user.xml

In the diagram above;

• Db2Database_1 should not have reported credentials dictionary entry(credentials_id).
• Db2Alias should have reported credentials dictionary entry(credentials_id).

• Set up credentials.

  This job uses SQL credentials defined for the DB2 database.

If a connection is established, discovery occurs in the following order:

1. This job retrieves DB2 major and minor versions (the SERVICE_LEVEL field of TABLE(sysproc.env_get_inst_info())).

2. This job instantiates the discoverer of the appropriate DB2 version (the 9x discoverer is used if the discoverer of the provided version is not available).

3. This job retrieves the full DB2 version information (RELEASE_NUM, SERVICE_LEVEL, BLD_LEVEL, PTF, FIXPACK_NUM fields of TABLE(sysproc.env_get_inst_info())) and the full version is reported to the application_version attribute of DB2.

4. This job retrieves DB Data File(SYSIBMADM.CONTAINER_UTILIZATION). FileSystem is also modeled if DB Data File is located on a Windows host (the disk name of the path is taken from the path of DB Data File and assigned to the mountpoint attribute of FileSystem).

5. This job retrieves opened sessions (TABLE(SNAP_GET_APPL_INFO(db_name, partition_number))).

   • The address and port of the client are parsed from APPL_ID field.

   • APPL_NAME is used as a process name.

   • Sessions with client APPL_NAME=db2jcc_application or APPL_NAME=db2jccThread are considered to be default client name and not reported.

6. This job retrieves the following CITs:

   • Db2 Schemas (SYSCAT.SCHEMATA)

   • Db2PartitionGroups (SYSCAT.DBPARTITIONGROUPS)

   • Db2Partitions (TABLE(DB_PARTITIONS()))

   • Db2Partition to Db2PartitionGroup relation (SYSCAT.DBPARTITIONGROUPDEF)

   • Db2BufferPools(SYSCAT.BUFFERPOOLS). Data is also taken from the table SYSCAT.BUFFERPOOLDBPARTITIONS to report correctly customized Db2BufferPools.

   • DB Table (SYSCAT.TABLES). Only Table (untyped) and Typed table types are discovered.