Interested to Buy Any Domain ? << Click Here >> for more details...
What is RUNSTATS?
- 3 Answers
- 7642 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 |
Outputs of explain are with matchcols = 0. What does this signify?
Which catalog tables contain authorization information?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
Explain about dbrm.
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is the physical storage length of timestamp data type?
what is the difference between where clause and having clause
what are the SQL codes u freequently got?
How do I import data from excel to db2?
Return code 100 means?
what is REORG? what is the use?
Explain transactions, commits and rollbacks in DB2.
COBOL 
