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 |
Explain the benefits you can get from mainframe connect?
what is the difference between declaring the cursor in WS section and Procedure division?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is node in db2?
Define db2 and its databases?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
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?
what needs to be done if a table is in copy pending / check pending status?
What is pagespace?
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.
What is copy pending and check pending in db2?