Interested to Buy Any Domain ? << Click Here >> for more details...
What is RUNSTATS?
- 3 Answers
- 7708 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
RUNSTATS is a utility to collect statistics of the
tablespace that will be used by the optimizer to generate
best cost access paths.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / srinivasa yadav
RUNSTATS:- RUNSTATS IS A UTILITY
IT IS GET THE LATEST INFORMATION OF TABLESPACE,
INDEX AND e.t.c
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kathir
this utility is giving information about the tablespace and
indexspace of statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
What does the REORG Utility do?
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
What is the difference between cursor and select statement?
What are the Isolation levels possible ?
How to resolve -803 sql code in DB2?
What is isolation level in db2?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How can you get the number of rows impacted by the last executed query?
What is a bind card?
What is the difference between CS and RR isolation levels?
How many Buffer pools are there in DB2 and what are they?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
COBOL 
