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 |
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a buffer in memory?
How do you select a row using indexes in db2?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
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?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is db2 catalog database?
what are the SQL codes u freequently got?
How can you find out the # of rows updated after an update statement?
What is db2? Explain.
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What do you mean by between and in? Is between inclusive of specified range values?