What is QUIESCE?
Answers were Sorted based on User's Feedback
Answer / s
QUIESE is used to establish a consistency point for the
named tablespaces. It issues a drain lock to disallow any
further processing and allows the currently executing UOW
to commit. Writes all the changed pages from the buffer to
DASD. The RBA is noted in the SYSCOPY.
Is This Answer Correct ? | 9 Yes | 0 No |
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is catalog database in db2?
How can you do the explain of a dynamic sql statement?
What is null indicator in cobol db2?
How can you count the number of rows from a table tab?
What is the SQL Communications Area and what are some of its key fields?
What is the purpose of the WHENEVER statement?
what needs to be done if a table is in copy pending / check pending status?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Where besides the DB2 catalog is database object information stored by DB2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to fetch the last row from the table in SQL (db2)?