What is a recovery log?
Answer / s
changes to the table are logged in a the active logs and
archived when the active logs become full. In recovery
situations the tablespace is restored using the image copy
and applies the log records from the active/archive logs to
current time.
| Is This Answer Correct ? | 4 Yes | 0 No |
Mention some fields that are a part of sqlca.
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
Explain what are the various isolation levels possible?
Where is the output of EXPLAIN stored?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
How to view db2 table structure?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is the SQL Communications Area and what are some of its key fields?
What is phantom read in db2?
What is the default page size of buffer pools?
What is a synonym ?
What does a deadlock mean in DB2?