Specifies whether subsequent connections are read-only.
- db2cli.ini keyword syntax:
- ReadOnlyConnection = 0 | 1
- Default setting:
- 0
- Equivalent connection attribute:
- SQL_ATTR_READ_ONLY_CONNECTION
- 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