Give some example of statistics collected during RUNSTATS?
Answer Posted / 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 View All Answers
Mention the different locking levels that are available in db2.
What are the two types of logging in the db2 database? Explain them.
What is the max length of sqlca?
what is the sqlcode -501
What r the comman abends in db2, jcl and cobol???????
How to execute stored procedure in db2 command editor?
What is the default page size of buffer pools?
What is bufferpool in db2?
What is the physical storage length of date data type?
What is database reorganization?
How to find the number of rows in a db2 table?
What is the syntax for creating a table in the db2 database?
What is a storage group (stogroup)?
What is the meaning concurrency in the db2 database?
What is runstats and reorg in db2?