This is probably a FAQ question but I cannot find the answer.

To minimize the effect of downtime during maintanance window I would like to put the DB into read-only state. What is the way to do that?

Thank you in advance.

Alexander.

SET--WRITE--+-SUSPEND-+--FOR--+-DATABASE-+------------------><
'-RESUME--' '-DB-------'


Command Parameters
SUSPEND
Suspending I/O writes will put all table spaces into a new state SUSPEND_WRITE state. Writes to the logs are also suspended by this command. All database operations, apart from online backup and restore, should function normally while database writes are suspended. However, some operations can wait while attempting to flush dirty pages from the buffer pool or log buffers to the logs. These operations will resume normally once the database writes are resumed.