I want to know what does "quiesce" in "db2 luw" means, how can I use it in linux and how it can affect the access to the tablespaces
I want to know how to tell whether or not a tablespace in a ddl was quiesced or not.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
To Quiesce means to pause/alter an application/device to allow the application/device to achieve a consistent state.
In terms of DB2 the Quiesce command should force all the users off the specified database and should flush all the buffers to disk (been a while since I've used DB2).
While the database is a Quiesced mode there are users who can still access the database such as SYSADMIN and SYSMAINT.
Quiesce mean locking a database from creating of external connection through any applicaton, if we quiesce any database in db2 then we are restricting other application users to access that database, means a user cannot connect his/her application from that database and will not be able to fire any query on that database.
Also, All other connection from the database those are connected are released after quiesce.