Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is dpf in db2?
How to check table size in db2 sap?
Mention the different locking levels that are available in db2.
What is package in cobol db2?
What are host variables in db2?
What is dbrm in db2 database?
What is the difference between dbm cfg and db cfg file in db2 ?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How can record locking be achieved in those DB2 versions which do not support it?
What is access path 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 a Foreign Key?
What are bind parameters in db2?
Explain what are the various isolation levels possible?
