Interested to Buy Any Domain ? << Click Here >> for more details...
What does the RUNSTATS Utility do?
- 4 Answers
- 20666 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 |
What are the various isolation levels possible?
How to resolve -502 sql code in DB2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is the physical storage length of date data type?
how we will do null data selection in cobol-db2 program
Which command is used to connect to a database in DB2 ? Give the Syntax.
On which levels locks can be applied?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
Explain transactions, commits and rollbacks in DB2.
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
COBOL 
