topic Re: IBM integration bus not showing DB calls in Open Q&A

IBM integration bus not showing DB calls

Yosi_Neuman — Wed, 18 Sep 2019 08:10:55 GMT

Hi guys

Installed agent on AIX with IIB on it

We can see PP but there is no DB statements in them as customer expected.

The IIB is using ODBC to connect the the sql server.

See below screenshot of the PP shows the Write to Tables that should be a DB statement

Is there any explanation for that?

Thanks in advance

Yos

Re: IBM integration bus not showing DB calls

MAkimov — Wed, 18 Sep 2019 09:45:11 GMT

IBM Integration Bus is not-supported ODBC call.

End-to-end tracing for message flows triggered by web requests, web services or IBM MQ.

Re: IBM integration bus not showing DB calls

Babar_Qayyum — Wed, 18 Sep 2019 10:11:55 GMT

Hello @Mikhail A.

It means Dynatrace SaaS/Managed also doesn't support similar to AppMon.

Do we have any road map for this?

Regards,

Babar

Re: IBM integration bus not showing DB calls

wmperez — Mon, 30 Aug 2021 16:52:49 GMT

Good afternoon Makinov,

We are experiencing the same issue reported by Yosi_Neuman, one of our principal execution groups is connecting to multiple databases MSSQL and Oracle, but we are not able to see this calls on the pureptahs, we just catch exceptions if the flow presents an exception on a "store procedure " execution, it is a plus for the agent to bring this visibility as it is available for other technologies.

In this case we have 5 adapters that connect to databases and no traces to what they are doing. Check the image below.

Best regards

Re: IBM integration bus not showing DB calls

rishabh_yadav2 — Mon, 22 Nov 2021 08:57:11 GMT

any recent addition to this pointer?

Re: IBM integration bus not showing DB calls

wmperez — Mon, 22 Nov 2021 12:48:41 GMT

Hello rishabh_yadav2,

According to an answer from support, we should use the DatabaseNode instead of a ComputeNode on IBM Message Broker, this does not show a purepath with the database connection but you can see the query that is being called from the DatabaseNode, execution time and other related metrics.

Regards

Re: IBM integration bus not showing DB calls

rishabh_yadav2 — Tue, 23 Nov 2021 07:26:53 GMT

Hey wmperez

That's the actual challenge that I am going through we have ComputeNode and post that I am failing to get the DB Queries.

Re: IBM integration bus not showing DB calls

wmperez — Tue, 23 Nov 2021 12:40:53 GMT

Good morning,

One of the product managers explain this when we report this issue "We support monitoring of DatabaseRetrieve and DatabaseRoute nodes, but unfortunately we currently cannot trace generic database calls that are triggered inside ComputeNodes", this means you will have to change your code to achieve this visibility.

Basically what you will get is the SQL statement and performance metrics about this SQL statement...

Best regards

Re: IBM integration bus not showing DB calls

Malaik — Tue, 27 Dec 2022 15:16:25 GMT

Hello

Is there any news on this.

Im facing the same need now and I cant retrieve any DB call.

What workaround did you made ?