|
INTERVIEW QUESTIONS
MAINFRAME
DB2
DETAILS
Question: When will you chose to run RUNSTATS?
Answer: After a load, or after mass updates, inserts, deletes, or after REORG.
|
|
|
Category |
DB2 Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6704 users |
Added on |
9/9/2014 |
Views |
71535 |
Rate it! |
|
|
Question:
When will you chose to run RUNSTATS?
Answer:
After a load, or after mass updates, inserts, deletes, or after REORG. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is RUNSTATS?
|
View Answer
|
|
How do you insert a record with a nullable column?
|
View Answer
|
|
What does it mean if the null indicator has -1, 0, -2? ?
|
View Answer
|
|
What is the picture clause of the null indicator variable? ?
|
View Answer
|
|
How do you retrieve the data from a nullable column? ?
|
View Answer
|
|
How does DB2 store NULL physically?
|
View Answer
|
|
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
|
View Answer
|
|
When is the access path determined for dynamic SQL?
|
View Answer
|
|
What is dynamic SQL?
|
View Answer
|
|
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
|
View Answer
|
|
How would you print the output of an SQL statement from SPUFI? ?
|
View Answer
|
|
What are the 2 sqlcodes that are returned? ?
|
View Answer
|
|
What is a collection?
|
View Answer
|
|
What are the advantages of using a PACKAGE?
|
View Answer
|
|
What are PACKAGES ? ?
|
View Answer
|
|
What happens to the PLAN if index used by it is dropped?
|
View Answer
|
|
What else is there in the PLAN apart from the access path? ?
|
View Answer
|
|
What is ACQUIRE/RELEASE in BIND?
|
View Answer
|
|
What is a DBRM, PLAN ?
|
View Answer
|
|
What is ALTER ?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All DB2 Interview Questions & Answers - Exam Mode /
Learning Mode
|