LOCK TABLE access clarification [CR 463204]

The following information will be added to the “Usage” section of the “LOCK TABLE statement” section in Chapter 6, “SQL Statements”:

LOCK TABLE statements run on tables in the IQ main store on the write server do not affect access to those tables from connections on query servers. For example:

On a write server connection, issue the command:

LOCK TABLE wrt1 WITH HOLD IN EXCLUSIVE MODE

sp_iqlocks on the write server confirms that the table wrt1 has an exclusive (E) lock.

The result of sp_iqlocks run on a connection on a query server does not show the exclusive lock on table wrt1. The user on this connection can see updates to table wrt1 on the write server.

Other connections on the write server can see the exclusive lock on wrt1 and attempting to select from table wrt1 from another connection on the write server returns the error “User DBA has the row in wrt1 locked.”