Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to a tablespace when its recovery infromation
has been removed and a full recovery is no longer possible?
- 2 Answers
- 5701 Views
- I also Faced
- E-Mail Answers
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 |
Define sqlca.
Why use RUNSTAT Utility?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is meant by isolation level?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Outputs of explain are with matchcols = 0. What does this signify?
Can we insert update delete in view?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is bufferpool in db2?
Q3. How will you fetch duplicate values from a DB2 table?
What does db2 plan contain?
What is the difference between cursor and select statement?
COBOL 
