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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How connect db2 database to datastage?

757


How do I optimize a query in db2?

609


How to check last update on table in db2?

624


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

781


What is deadlock in db2?

572






What is database alias db2?

593


Explain package in db2 and its advantages?

589


How do I start db2 in windows?

554


How to find the number of rows in a db2 table?

642


How to resolve deadlock issue

17927


How to fetch the last row from the table in SQL (db2)?

1027


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

618


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2264


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

569


How to restart a DB2 program?

1353