what is Runstats? Whem will u choose to runatats?
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of dclgen in db2?
What is runstats utility in db2?
Explain various types of locks in db2?
How to test SQL -911 error while developing COB-DB2 program
What is isolation level in db2?
Explain about cursor stability?
What is reorg?
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
How do you stop a db2 database in linux?
What is the difference between cursor stability and repeatable read isolation levels?
What is phantom read in db2?
What is a dbrm in db2?
How does cobol compile db2 program?
What is the syntax for FETCH in DB2 ?
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.