Pushing a default DB2 Isolation Level to users of Toad Data Point

Toad for IBM DB2
1

We use Toad Data Point 3.4 in our shop. We would like to push a default DB2 Isolation Level out to all our users of Toad. Is this possible? Does the default/current setting exist in some configuration file that can be manipulated?

I know the interactive way of changing the isolation level from within Toad.

Thanks,

Scott

2

Hello Scott,

Toad settings are set under your user profile.

Default isolation parameter can be found in DB2.xml file:

C:\Users<>\AppData\Roaming\Quest Software\Toad Studio <>\ModuleSettings\DB2.xml

<SOAP-ENV:Envelope xmlns:xsi="www.w3.org/…/XMLSchema-instance&quot; xmlns:xsd="www.w3.org/…/XMLSchema&quot; xmlns:SOAP-ENC="schemas.xmlsoap.org/…/&quot; xmlns:SOAP-ENV="schemas.xmlsoap.org/…/&quot; xmlns:clr="schemas.microsoft.com/…/1.0&quot; SOAP-ENV:encodingStyle='schemas.xmlsoap.org/…/&quot;>

SOAP-ENV:Body

<a1:DB2Settings id=“ref-1” xmlns:a1="schemas.microsoft.com/…/ToadDB2%2C%20Version%3D6.1.0.16569%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull&quot;>

…

Read Committed

…

</a1:DB2Settings>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

It affects newly created connections.

Isolation level is also part of connection configuration. To accomplish you task you could also distribute pre-set connection file for your users.

**

C:\Users<>\AppData\Roaming\Quest Software\Toad Studio <>\Connections.xml

3

…

Read Committed

True

Libor

3

Thank you Libor!!