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



What happens to a tablespace when its recovery infromation has been removed and a full recovery is..

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

What happens to a tablespace when its recovery infromation has been removed and a full recovery is..

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

Post New Answer

More DB2 Interview Questions

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


How to view db2 table structure?

0 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,






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

3 Answers   IBM,


What are concurrency issues?

0 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,


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?

6 Answers   Perot Systems,


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


Categories