DB2 SQL ERROR - SQLCODE & SQLSTATE is hidden

[akerimd]

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

Thank you,

[andre_f]

Hi @akerimd 

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.

[kalle_lahtinen · Accepted solution]

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.

[akerimd]

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.

[kalle_lahtinen]

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.