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
- 5519 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 |
what is different three logs in DB2?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What do you mean by NOT NULL? When will you use it?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Mention and explain the contention situations caused by locks?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do you Load a table ?? and what is Load replace ?
how to resolve -805 . how to see dbrm and package not found
what is REORG? what is the use?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
COBOL 
