Specifies whether subsequent connections
are read-only.
- Equivalent CLI keyword
- ReadOnlyConnection
- Equivalent IBM® data server
provider for .NET connection string keyword
- Not available.
- IBM data server driver configuration
file (db2dsdriver.cfg) syntax
- <parameter name="ReadOnlyConnection" value="0 | 1"/>
- Default setting
- 0
- Usage notes
-
- 0
- The default value. Specifies that new connections are not read-only.
Access to database objects are controlled by the authority that is
associated with a user ID on the server.
- 1
- Specifies that all new connections are read-only.
If a read-only connection fails over to another member
or member of another group, the connection remains read-only. You
cannot specify the ReadOnlyConnection keyword
when you are connecting to Informix® database
servers. If
you are connecting to
DB2® for i servers,
you must apply the following fix (PTF) on the server.
- For DB2 for i V6R1
server, PTF SI51729.
- For DB2 for i V7R1
server, PTF SI51732.
DB2 10.5 for Linux, UNIX, and Windows