What's the difference between DB2 active log and archive
log? Thanks a lot...

Answers were Sorted based on User's Feedback



What's the difference between DB2 active log and archive log? Thanks a lot.....

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

What's the difference between DB2 active log and archive log? Thanks a lot.....

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

Post New Answer

More DB2 Interview Questions

What is cursor with hold option in db2?

0 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


define clustering index.

0 Answers  


Is db2 a mainframe?

0 Answers  


What are bind parameters in db2?

0 Answers  






What is view db2?

0 Answers  


If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  


What is difference between rollback and commit?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


What is page size in db2?

0 Answers  


What is the difference between using bind () and rebind () methods of naming class?

0 Answers  


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


Categories