Hi:
FYI:
db2=> SET WRITE {SUSPEND | RESUME} FOR DATABASE
This suspends I/O for the database for all users ..
including you ;)
My 2 cents..
-- VJ
--- "Dimoline, Simon" <[EMAIL PROTECTED]>
wrote:
> Many thanks,
> Simon
>
> -----Original Message-----
> From: John McLean [mailto:[EMAIL PROTECTED]]
> Sent: 06 October 2001 21:51
> To: [EMAIL PROTECTED]
> Subject: Re: DB2EUG: DB2 command for read only
>
>
> Simon,
>
> You can assign Groups or Users privileges to read,
> update etc. Go to the
> control center
> and you will see the privilege options available.
>
> John
>
----------------------------------------------------------------------------
> ------------------
>
> Dimoline, Simon wrote:
>
> > Dear User Group,
> > Can someone help with advice on how best to put a
> db2 database into
> > read-only mode. This concept is common on many
> other types of database but
> I
> > cannot find a command to do this for DB2. I am
> running version 4 (on unix)
> > so maybe it is too old!
> > Basically, I want to exclude users from doing
> updates on the database
> during
> > certain periods.
> > Many thanks in advance,
> > Simon.
> >
> > "This communication is intended solely for the
> addressee and is
> confidential and not for third party unauthorised
> distribution."
> >
> > =====
> > To unsubscribe, send 'unsubscribe' to
> [EMAIL PROTECTED]
> > For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
> =====
> To unsubscribe, send 'unsubscribe' to
> [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
> "This communication is intended solely for the
> addressee and is confidential and not for third
> party unauthorised distribution."
>
> =====
> To unsubscribe, send 'unsubscribe' to
> [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
