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
What do you mean by rollback?
What are the bind parameters ibm db2?
When the like statement is used?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Mention the downsides of page level lock.
What is difference between isnull and coalesce?
Why select is not preferred in embedded sql programs?
Is ibm db2 open source?
What is a page in db2?
Name the various locking levels available?
What is a Foreign Key?
How can you find out the # of rows updated after an update statement?
What is the physical storage length of the data types date, time, and timestamp?
What is null value in db2?
What are the various data types available in db2?