What happens to a tablespace when its recovery infromation
has been removed and a full recovery is no longer possible?
Answer Posted / vat
it goes into 'COPY' - Copy Pending status. You would have
to perform a full image copy to reset the status. That's
why you never do MODIFY RECOVERY and delete ALL image copies
of the table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
List out the buffer pools in db2
Why db2 is called db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the use of db2?
What is view db2?
When the like statement is used?
What is db2 and what is the use of db2 optimizer?
Define declaration generator (dclgen).
Can you tell me how can you find out the # of rows updated after an update statement?
What are the prerogatives?
Define data page.
What is runstats utility in db2?
Explain various types of locks in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How to execute stored procedure in db2 command editor?