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 |
Q3. How will you fetch duplicate values from a DB2 table?
How to view db2 table structure?
Where can you declare a cursor in a cobol-db2 program?
The only place of VSAM KSDS in DB2 is?
What's the maximum number of volumes that can be added to a STOGROUP?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What are concurrency issues?
My SQL is not performing well. Describe how will you fine tune it?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
How do you retrieve the first 5 characters of firstname column of db2 table emp?