ReadOnlyConnection CLI/ODBC configuration keyword

Specifies whether subsequent connections are read-only.

db2cli.ini keyword syntax:
ReadOnlyConnection = 0 | 1, true | false
Default setting:
0
Equivalent connection attribute:
SQL_ATTR_READ_ONLY_CONNECTION
Usage notes:
 
0, false
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, true
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.