topic DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden in Open Q&A

DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

akerimd — Mon, 07 Nov 2022 15:26:03 GMT

Hello, the db team has a request from me, how can I make the *****' s in the outgoing warnings visible as follows.

Thank you,

Re: DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

andre_f — Tue, 08 Nov 2022 08:44:12 GMT

You could check if users who have the permission "View sensitive request data" can see this data. Usually data is masked like this for people with insufficient permission - see here.

Then you can adjust the permissions.

Re: DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

kalle_lahtinen — Tue, 08 Nov 2022 10:24:04 GMT

Hi,

I think in this case the asterisks could simply indicate a variable, i.e. Dynatrace is lumping those different exception messages together in one row, even if the SQLCODE for example might differ between DB calls. To view the precise values, try opening the Distributed Traces view. You can add a filter "Failed state = only failed" there, to only show the relevant traces.

Re: DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

akerimd — Sun, 18 Dec 2022 13:48:45 GMT

We have a DB2 database and the db team selects the relevant database and sees ******** like below,

in the codes in the failure analysis section from the detail section, how can I make it visible. I've tried the suggestions above but haven't found a solution yet, Please help me thank you.

Re: DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

kalle_lahtinen — Mon, 19 Dec 2022 07:35:22 GMT

The solution was to look at individual traces, did you try that? I'm not aware of any way to make them visible on the failure analysis page.