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
How many types of page locks can be held in db2?
What is the syntax for FETCH in DB2 ?
What is database manager in db2?
What is runstats db2?
How to find the number of rows in db2 tables?
What does sqlcabc has?
What is buffer pool and list some of them?
What is a storage group (stogroup)?
Define data page.
Name the various locking levels available?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is database reorganization?
How to test SQL -911 error while developing COB-DB2 program
i want to maintain uniqueness on pdf without make lf??????????
What is cobol db2?