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 cursor with hold option in db2?
how to execute qcmdexc in rpgle?plz write code also?
define clustering index.
Is db2 a mainframe?
What are bind parameters in db2?
What is view db2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is difference between rollback and commit?
wt is view ? wht r the restrictions for view ?
What is page size in db2?
What is the difference between using bind () and rebind () methods of naming class?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?