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 use of COMMAREA ?Minimum how much data we can pass from it?
Explain in detail about buffer manager and its functionalities?
What is -904 sql code? How to resolve it?
how do you resolve -805?
Can we able to find all the Table names under a Particular Plan?
What is dclgen in db2?
What language is db2 written in?
How many sub queries can you combine together ?
What's the maximum number of characters that a tablename can have?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
How do you pull up a query which was previously saved in qmf?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?