what is Runstats? Whem will u choose to runatats?



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

Post New Answer

More DB2 Interview Questions

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


Explain the EXPLAIN statement?

1 Answers  


What is EXPLAIN?

1 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


How to execute stored procedures?

0 Answers  






How can deadlocks be resolved?

0 Answers  


What are delete-connected tables?

1 Answers  


What is an instance in db2?

0 Answers  


What are PACKAGES ?

3 Answers  


List out the buffer pools in db2

0 Answers  


Explain what are the various isolation levels possible?

0 Answers  


Why do we bind in db2?

0 Answers  


Categories