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
is it compulsory commitment control in journal?
What is the default page size of buffer pools?
What is a cursor in programming?
What is difference between isnull and coalesce?
What are union and union all?
Outputs of explain are with matchcols = 0. What does this signify?
What is page size in db2?
What does runstats do in db2?
What is database manager in db2?
How do I connect my db2 database to ibm?
B37 abend during spufi?
What is copy pending and check pending in db2?
Mention some fields that are a part of sqlca.
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
What are the various isolation levels possible?