What happens to a tablespace when its recovery infromation
has been removed and a full recovery is no longer possible?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s
Tablespace in intact. You can make a image copy of the
tablespace to make it recoverable.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the maximum length of sqlca?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Explain about mirror activator disk mirroring?
How are write I/Os from the buffer pool executed?
what is the difference between where clause and having clause
What is the SQL Communications Area and what are some of its key fields?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is the role of union all and union
What is schema in db2?
can any body explain about plan and pakage in detail....
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)