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 |
When DB2 connection fails, will online program work or give errors.
What is temporal table in db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What is REORG? When is it used?
How to resolve -502 sql code in DB2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Mention the location where the output received from explain statement is stored.
wht r the requirements for writing a cobol-db2 pgm ?
how to get duplicate records from tables?write qurey for this?
what are the SQL codes u freequently got?
What is the latest version of ibm db2?
is it compulsory commitment control in journal?