Interested to Buy Any Domain ? << Click Here >> for more details...
Why use RUNSTAT Utility?
- 3 Answers
- 24059 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 static sql? what is dynamic sql? Give me details
Normalization in DB2 – first normal form, second normal form
What is coalesce in db2?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What kind of database is db2?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
How to execute stored procedure in db2 command editor?
how can u understand the end of the table ?
Can you access the DB2 Directory table using SQL?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
COBOL 
