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 |
How can we define a table? How can we apply SEARCH ALL on it ?
What are the bind parameters ibm db2?
What do the initials DDL and DML stand for and what is their meaning?
What does db2 blu stand for?
What is referential integrity?
Mention the location where the output received from explain statement is stored.
What does CURRENTDATA option in bind indicate
cobol-db2 runjcl please?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is host variable?
What Utility is used to migrate DB2 from one release to the next?
How can you quickly find out the # of rows updated after an update statement?