By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

How switch db into read-only mode?

P: n/a
without filling all disks :-)

Andy

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
bka
revoke all insert/update/load/delete privileges from all users with
REVOKE statements.

Nov 12 '05 #2

P: n/a
complete readonly can also be attained by using write suspend mode.

db2 "connect to <database_name>"
db2 "set write suspend for database"

no write activity will happen at all after this.

use write resume for resuming updates|inserts|deletes

db2 "set write resume for database"

rgds,
dotyet

bughunter@ru wrote:
without filling all disks :-)

Andy


Nov 12 '05 #3

P: n/a
"bka" <ba*******@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
revoke all insert/update/load/delete privileges from all users with
REVOKE statements.

This will not work if you have any static SQL packages that only need
execute access to run.
Nov 12 '05 #4

P: n/a
It's not a real read-only. I need got error on insert/update/delete
operations...

Nov 12 '05 #5

P: n/a
Hello.

Try this:

quiesce tablespaces for table <some_table> share;

all tablespaces (and all tables in them) where this table resides will
be placed in readonly mode.
repeat this command until you lock all remaining tablespaces.

Sincerely,
Mark B.

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.