Interested to Buy Any Domain ? << Click Here >> for more details...
What does the RUNSTATS Utility do?
- 4 Answers
- 20683 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
| Is This Answer Correct ? | 30 Yes | 3 No |
Answer / andank
RUNSTATS does not reclaim space nor orders the records.
Here is info from the DB2 Manual:
The RUNSTATS online utility gathers summary information
about the characteristics of data in table spaces, indexes,
and partitions. DB2 records this information in the DB2
catalog and uses it to select access paths to data during
the bind process. It is available to the database
administrator for evaluating database design and to aid in
determining when table spaces or indexes must be
reorganized.
Output: RUNSTATS updates the DB2 catalog with table space
or index space statistics or prints a report.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / srinivasa yadav
RUNSTAT: IT GIVES THE LATEST INFORMATION OF THE
INDEXES,TABLESPACES etc
| Is This Answer Correct ? | 10 Yes | 1 No |
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What r the comman abends in db2, jcl and cobol???????
can you use symbolic parameters in JOB?
Where are plans stored?
What is index in db2?
What is a storage group (stogroup)?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What happens in bind step in a db2 program?
Which is faster delete or truncate?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
COBOL 
