Isolation level at the database level for IBM DB2 LUW
2
votes
1
answer
647
views
How do I determine the default isolation level for our 11.5 DB2 instance running on Linux?
I see there is a "special register" from [this IBM documentation](https://www.ibm.com/docs/en/db2/11.5?topic=registers-current-isolation) , however I'm not a DB2 expert so I'm not sure where to look for that, or how to "see" values for "special" registers.
I also looked at [this](https://www.ibm.com/docs/en/db2/11.5?topic=mpf-mon-get-connection-details-table-function-get-connection-metrics-as-xml-document) , but I am having no luck understanding how to obtain the current isolation from that either.
Asked by Hannah Vernon
(70988 rep)
Oct 18, 2023, 08:15 PM
Last activity: Oct 18, 2023, 09:09 PM
Last activity: Oct 18, 2023, 09:09 PM