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 |
Mention the location where the output received from explain statement is stored.
What parameters are used to control the free space in DB2?
Can one database have multiple instances?
What is cobol db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
Explain the use of the WHERE clause?
Which components manage deadlocks in db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How can you get the number of rows impacted by the last executed query?
what is + sign and -ve sign for sql code ?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.