What's the difference between DB2 active log and archive
log? Thanks a lot...
Answers were Sorted based on User's Feedback
Answer / parul
DB2 writes each log record to a disk data set called the
active log. When the active log is full, DB2 copies the
contents of the active log to a disk or magnetic tape data
set called the archive log.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / stewie
active log--captures all the info/activities happening on DB2
archive log--is the copy of the active log
| Is This Answer Correct ? | 11 Yes | 8 No |
What is the database descriptor?
What is dclgen (declaration generator)?
What is the difference between dbm cfg and db cfg file in db2 ?
What is cursor?
What is the meaning concurrency in the db2 database?
how to resolve -805 . how to see dbrm and package not found
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 optimizer?
What will happen, while trying to close the closed cursor.
what is the role of the cursor in db2?
how to identify the pseudo conversation by seeing the program
How do I add a column to an existing table in db2?