Answer Posted / sajjan jindal
IT is a DB2 utility used to collect statistics about the
data values in tables which can be used by the optimizer to
decide the access path. It also collects statistics used
for space management. These statistics are stored in DB2
catalog tables.
The RUNSTAT is executed after a load, or after mass
updates, inserts, deletes, or after REORG.
| Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
Why do we use cursor?
Comment whether the cursor is closed during commit or not.
What is syscat in db2?
What is null in db2?
What is the role of data manager in the db2 database?
What is table space in db2?
What is a dbrm in db2?
Explain about dbrm.
What is explain in db2?
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 the purpose of rollback and commit?
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 do you pull up a query which was previously saved in qmf?
Before you give the explain statement, what are the prerogatives?
Define declaration generator (dclgen).
