IBM DB2 sensor
The IBM® DB2® sensor discovers IBM DB2 Universal Database (UDB) servers.
Sensor name that is used in the GUI and logs
Db2Sensor and Db2WindowsSensor
Prerequisites
The sensor assumes the following prerequisites:
- Discovery of the computer system must succeed.
- DB2 must be installed in the instance owner's home directory.
Security issues
The DB2 user credentials must belong to the DB2 administration group.
Discovery is performed by using shell scripts that run the following DB2 commands:
- db2
- Command line processor invocation command
- db2ilist
- List instances command
- db2set
- DB2 profile registry command
- db2licm
- License management tool command
- db2level
- Show DB2 service level command
- db2
- get dbm cfg
Limitations
Incorrect characters can be discovered if you are using a 32-bit DB2 on a 64-bit Windows operating system. This character encoding problem is due to a limitation of the 64-bit Windows operating system, which hides commands such as chcp from 32-bit applications such as the db2cmd.exe program.
If more than one version of DB2 is installed on the same Windows computer system, the sensor cannot discover the IBM DB2 Universal Database (UDB) server.
TADDM runs the topology building process on a periodic basis. Until the topology building process has completed after a discovery, the database names that are displayed for remote systems might not be unique. After the topology build process has completed, the database name contains both the port number and the IP address of the remote database.
Model objects created
The sensor creates the following model objects:
- app.db.db2.Db2AdminServer
- app.db.db2.Db2Alias
- app.db.db2.Db2BufferPool
- app.db.db2.Db2ConfigValue
- app.db.db2.Db2Container
- app.db.db2.Db2Database
- app.db.db2.Db2DatabaseConfigValue
- app.db.db2.Db2Instance
- app.db.db2.Db2InstanceConfigValue
- app.db.db2.Db2Module
- app.db.db2.Db2Schema
- app.db.db2.Db2Server
- app.db.db2.Db2ServerProcess
- app.db.db2.Db2System
- app.db.db2.Db2SystemConfigValue
- app.db.db2.Db2TableSpace