Put database in single user mode

[mghale]

Hi,

I wanted to know if there is a way in DB2 UDB/AIX v. 8.2.2 to
activate/start a database in a single user mode similar to how you can
start the entire instance in Admin Mode.

I want to take a database offline. I use the force command but there
are apps that constantly try to reconnect. I want to set the database
to only allow an admin to access it to run my tasks.

Thanks in advance!

Martin

[Artur]

You can use QUIESCE DATABASE command. Only users with quiesce_connect
privileges (and users with administrative authorities) will be able to
connect to the database.

[Norbert Munkel]

Hi,

mghale wrote:

I want to take a database offline. I use the force command but there
are apps that constantly try to reconnect. I want to set the database
to only allow an admin to access it to run my tasks.

You want to search the DB2 Infocenter for

QUIESCE DATABASE

Example:

(As instance owner)

db2 connect to <mydb> using <password>
db2 quiesce database immediate force connections

This will force all active user-connections and gives an SQL-Error if a
ordenary user tries to connect to the database.

To make the database available again, connect to it and type

db2 unquiesce database

Hope that helps.

regards,

Norbert

[Norbert Munkel]

Artur wrote:

You can use QUIESCE DATABASE command. Only users with quiesce_connect
privileges (and users with administrative authorities) will be able to
connect to the database.

Thank you for putting me right. You don't have to be the instance owner.
You just need to have the priviledges mentioned above, which means
that users whith same priviledges would still be able to connect to the
database.

Should not be a REAL problem in a real world scenario.

cu,

Norbert

[mghale]

Thanks everyone for the fast response!!!! Your help is greatly
appreciated.

Martin

[Pierre Saint-Jacques]

After you start the instance, do:
db2 connect to dbname in exclusive mode

From then on only connection using this id can connect or do stuff.
Even users with QUIESCE CONNECT won't be able to connect.
I think (not sure) that this is a SYSADMIN authority requirement.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Norbert Munkel" <[e-mail]> a écrit dans le message de news:
dg*************@news.t-online.com...

Artur wrote:

You can use QUIESCE DATABASE command. Only users with quiesce_connect
privileges (and users with administrative authorities) will be able to
connect to the database.

Thank you for putting me right. You don't have to be the instance owner.
You just need to have the priviledges mentioned above, which means that
users whith same priviledges would still be able to connect to the
database.

Should not be a REAL problem in a real world scenario.

cu,

Norbert