|
INTERVIEW QUESTIONS
MAINFRAME
DB2
DETAILS
Question: What is COPY PENDING status?
Answer: A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.
|
|
|
Category |
DB2 Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7819 users |
Added on |
9/9/2014 |
Views |
70628 |
Rate it! |
|
|
Question:
What is COPY PENDING status?
Answer:
A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility. 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 |
|
When do you use the IMAGECOPY?
|
View Answer
|
|
What is IMAGECOPY ?
|
View Answer
|
|
What is REORG? When is it used?
|
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
|
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
|