Interested to Buy Any Domain ? << Click Here >> for more details...
Why use RUNSTAT Utility?
- 3 Answers
- 23929 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 |
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How to connect to db2 database from windows command line?
What is a clustered index?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Is db2 a programming language?
What is the purpose of using commit?
What is read-only cursor?
What is a view? Why use it?
Explain correlated sub-queries.
Explain the contention situations caused by locks?
What is a data page?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
COBOL 
