Dynatrace Managed OneAgent on AIX server for Database DB2

[rchavan1]

Please can anyone help me to understand how the OneAgent on AIX db2 works.

The installation is not as like linux but need to do instrumentation on the technologies like Java etc

but since I am using db2 database on this AIX server once i extract the agent and how my db is getting picked up by oneagent.

If any one share details procedure will be appreciated.

Thank you

[hayden_miedema · Accepted solution]

Hi Rajesh,

Installation of the OneAgent on the AIX server where DB2 is running the will monitor the the DB2 process. This allows indirect monitoring of the database. You should also be able to see the queries going to the database.

HTH,

Hayden

[rchavan1]

Thank you Hayden, if need to restart the db2 process ? will have number of instances of db2 process? since I am doing frist time on the db2 agent installation oneagent on AIX server.

[KevinW]

The OneAgent by default will group all DB2 instances together into a single process group instance called DB2 as of OneAgent v1.307, however you can use Simple Detection rules based on the Environment Variable DB2INSTANCE and DT_CUSTOM_PROP with the Process group Naming, and the DB2ENVLIST setting to import the DT_CUSTOM_PROP value to then split these out into individual DB2 instances names as the instance values.

DB2ENVLIST and DT_CUSTOM_PROP are set in the /db2/<instanceName>/sqllib/db2profile file, usually the last 2 lines.

tail -3 /db2/InstanceName/sqllib/db2profile

export DT_CUSTOM_PROP=DB2_Inst_Name="${DB2INSTANCE}"

export DB2ENVLIST=DT_CUSTOM_PROP

RFE has been opened for Process Group Naming for DB2: https://community.dynatrace.com/t5/Product-ideas/DB2-Process-Group-Instance-Using-already-available-...