DB2 Topology by SQL Job

This job discovers the physical elements within a DB2 database.

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Discovery Flow

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

This job retrieves DB2 major and minor versions (the SERVICE_LEVEL field of TABLE(sysproc.env_get_inst_info())).
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).
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.
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).
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.
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.