Interested to Buy Any Domain ? << Click Here >> for more details...
Why use RUNSTAT Utility?
- 3 Answers
- 23911 Views
- Merrill Lynch, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sajjan jindal
IT is a DB2 utility used to collect statistics about the
data values in tables which can be used by the optimizer to
decide the access path. It also collects statistics used
for space management. These statistics are stored in DB2
catalog tables.
The RUNSTAT is executed after a load, or after mass
updates, inserts, deletes, or after REORG.
| Is This Answer Correct ? | 35 Yes | 2 No |
Answer / elavarasi
to provide statistical info. abt table,tablespace and index
| Is This Answer Correct ? | 20 Yes | 3 No |
Answer / avinash
It provide the summary information about the
characteristics of data available in table, indexes etc.
DB2 records these information into the CATLOG table and use
this information to decide on the access path to data
during the bind process. To obtain the statistics you can
query the catalog table.
| Is This Answer Correct ? | 8 Yes | 4 No |
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How is deadlock resolved?
What are the various data types available in db2?
What is package versioning? Please give an example.
Where do you specify them?
How is a typical db2 batch pgm executed?
What is an instance in db2?
What does the REORG Utility do?
can any one expalin check point with an example?
What will the DB2 optimizer do?
How can we retrieve the total number of records in RPG & CLLE?
WHAT IS MEANT BY COMMIT COMMAND?
COBOL 
