|
INTERVIEW QUESTIONS
MAINFRAME
DB2
DETAILS
Question: What is REORG? When is it used?
Answer: REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.
|
|
|
Category |
DB2 Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9062 users |
Added on |
9/9/2014 |
Views |
70656 |
Rate it! |
|
|
Question:
What is REORG? When is it used?
Answer:
REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented. 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 |
|
Give some example of statistics collected during RUNSTATS?
|
View Answer
|
|
When will you chose to run RUNSTATS?
|
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
|