Interested to Buy Any Domain ? << Click Here >> for more details...
What does the RUNSTATS Utility do?
- 4 Answers
- 20605 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 foreign keys in db2?
What is QUIESCE?
How can you classify the locks in db2?
List down the data types in the db2 database.
What is cursor stability in db2?
what's the best lock size that you could use when you create a tablespace?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
what types of copies can be made with the COPY Utility ?
what is utility for parm lib
What is catalog database in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
COBOL 
