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
Can you tell me how can you find out the # of rows updated after an update statement?
How do you find the maximum value in a column in db2?
Mention the location where the output received from explain statement is stored.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the default page size of buffer pools?
What is db2 bind?
Are views updateable?
How to resolve deadlock issue
Mention the different locking levels that are available in db2.
How do I start db2 in windows?
What is package in cobol db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is isolation level in db2?
What is dbrm library?
What is alias in db2?