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

is it compulsory commitment control in journal?

2013


What is the default page size of buffer pools?

650


What is a cursor in programming?

596


What is difference between isnull and coalesce?

620


What are union and union all?

541






Outputs of explain are with matchcols = 0. What does this signify?

619


What is page size in db2?

563


What does runstats do in db2?

607


What is database manager in db2?

551


How do I connect my db2 database to ibm?

602


B37 abend during spufi?

982


What is copy pending and check pending in db2?

578


Mention some fields that are a part of sqlca.

603


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1597


What are the various isolation levels possible?

649