About Discoonection

[Suresh]

Hi All

I am design one web database.
In this database i want to execute one routine At the time of execution
of this routine,User (application server or other database user) should
not access database. means database should be offline to application
server or other user who can access but I should be able to access
database to execute that routine. That routine may be executed by using
some appplication which is running on same databse server or by DBA.So
what is approch to handle such situation in DB2. I am new to DB2.

Thanks

Suresh

[Ian]

Suresh wrote:

Hi All

I am design one web database.
In this database i want to execute one routine At the time of execution
of this routine,User (application server or other database user) should
not access database. means database should be offline to application
server or other user who can access but I should be able to access
database to execute that routine. That routine may be executed by using
some appplication which is running on same databse server or by DBA.So
what is approch to handle such situation in DB2. I am new to DB2.

Use stored procedures; grant execute privileges on the stored
procedures to the appropriate users, but don't grant
select/insert/update/delete privileges on the base tables.

[Pierre Saint-Jacques]

You do not say but I will presume you are using DB2 UDB for
Linux/Windows/Unix and at V8.
In this case, build the routine using an id that has QUIESCE_CONNECT
privilege. Usually that is SYSADMIN and/or DBADM authority.
In the routine, start by issuing the db2 quiesce db command and then connect
and run the routine.

This will force off all applications. Those in the middle of a unitof work
will get rolled back and disconnected. Everybody else gets disconnected.
No request for connections may be accepted by the db except those that have
the privilege mentioned above.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Suresh" <su*******@indiatimes.com> a écrit dans le message de news:
11**********************@i40g2000cwc.googlegroups. com...

Hi All

I am design one web database.
In this database i want to execute one routine At the time of execution
of this routine,User (application server or other database user) should
not access database. means database should be offline to application
server or other user who can access but I should be able to access
database to execute that routine. That routine may be executed by using
some appplication which is running on same databse server or by DBA.So
what is approch to handle such situation in DB2. I am new to DB2.

Thanks

Suresh