check if the Db is quiesced

[t***@yahoo.com.br]

Hi all,

is there a way to check if the DB is quiesced?

My command set to backup is:

[code]
CONNECT TO SCRY;
UNQUIESCE DATABASE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE SCRY TO "E:\DB2\SCRY\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO SCRY;
CONNECT RESET;
[/code]

if I don´t put "UNQUIESCE DATABASE", but the database is "QUIESCED",
I got an error. if I put, I got other error, like this:

[code]
UNQUIESCE DATABASE

SQL1373W Cannot unquiesce instance or database "SCRY", because it is not

quiesced.
[/code]

Is there a way to check this, like "IF DB IS QUIESCED" THEN....

thanks!

[Priyanka]

Hi,

Try to use db2pd tool


Thanks and Regards,
Priyanka

[t***@yahoo.com.br]

thanks!!!!! :-)