what is Runstats? Whem will u choose to runatats?
Answer / s
RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.
Is This Answer Correct ? | 4 Yes | 0 No |
Explain various types of locks in db2?
What is check constraint in db2?
What is scrollable cursor in db2?
What is cursor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
how will you retrieve first record in table
Mention and explain the contention situations caused by locks?
In which column of which DB2 catalog would you find the length of the rows for all tables?
Which isolation level provides highest data integrity?
What is bufferpool in db2?
What is node in db2?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.