ReadOnlyConnection IBM data server driver configuration keyword

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

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 IBM i servers, you must apply the following fix (PTF) on the server.

For Db2 for IBM i V6R1 server, PTF SI51729.
For Db2 for IBM i V7R1 server, PTF SI51732.