Interested to Buy Any Domain ? << Click Here >> for more details...
Why use RUNSTAT Utility?
- 3 Answers
- 23741 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 |
What is a bind in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Explain packages.
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is a data page?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How many buffer pools are there in DB2?
Which catalog table stores referential constraints?
What is a SELECT statement?
what is plan? is plan executable or package?
How do I add a column to an existing table in db2?
my project is insurance management system,how to explain my work environment in interview?
COBOL 
