Hi,

I want to make a already existing DB2 table to be read-only. Can anyone let me know the command for doing that?

I am using DB2 - V8.1/Linux OS

Thanks,
Arunvijay.

You could use the REVOKE statement to revoke insert, update, and delete authorization from certain users or groups.

Or you create a small program that locks the table in shared mode, which will also prevent DBAs from bypassing the privilege checking. (But then, a SYSADM could force this program and it wouldn't be water-tight.)

I wonder if that would cause the logs to go into secondary extents because the transaction is still open?

No, it wouldn't. Since the lock does not cause a log record to be written, the locking transaction does not refer to any active log file.

Doesn't DB2 have to record the beginning of the UOW? Maybe not, but in any case, I don't think it is a good idea to hold locks like that.

The beginning of the UOW is needed only when the first data modification occurs. In fact, transactions with only queries do not appear at all in the log - at least that's how things worked in DB2 LUW V8, and I doubt that this changed in V9.

And I fully agree: holding locks like that is not smart at all, for example, if lock timeout is set to infinity...