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 |
What is a plan and package in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is DCLGEN ?
how can i pull up a query which was previously stored in qmf
How does DB2 determine what lock-size to use?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What are the prerogatives?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
how to fetch first 100 rows in db2
i have a db2 variable how do u declare tht into working storage section ?
What else is there in the PLAN apart from the access path?