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 a predicate?
What is bind in db2?
what is dynamic cursor?gives syntax for this?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is the difference between using bind () and rebind () methods of naming class?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Define check constraint.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is declare cursor?
Is the primary key a clustered index?
What is a composite index and how does it differ from a multiple index?
What is the advantage in De-normalizing tables in DB2?