Give some example of statistics collected during RUNSTATS?



Give some example of statistics collected during RUNSTATS?..

Answer / sadiq afroze

Number of rows in the table, Percent of rows in clustering
sequence, Number of distinct values of indexed column,
Number of rows moved to a nearby/fairway page due to row
length increase

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

Explain the benefits you can get from mainframe connect?

0 Answers  


what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


What is node in db2?

0 Answers  


Define db2 and its databases?

0 Answers  






what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


What is read-only cursor?

1 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


What is pagespace?

1 Answers  


What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,


What is copy pending and check pending in db2?

0 Answers  


Categories