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 the purpose of using commit?
What are the benefits of using the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what is the sqlcode -501
What is rebind in db2?
Are view updateable?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is netezza database?
What is dbrm? What it contains? When it will be created?
What does db2 blu stand for?
What is the result of open cursor statement?
What is the maximum number of columns in a db2 table?
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Comment whether the cursor is closed during commit or not.
