What's the difference between DB2 active log and archive
log? Thanks a lot...
Answers were Sorted based on User's Feedback
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 |
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 |
how to get duplicate records from tables?write qurey for this?
What are some SQL aggregates and other built-in functions?
Which component is responsible for processing sql statements and selecting access paths?
Is it possible to precompile if db2 goes down?
How to insert more than one record using insert?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is a data page?
What information can you find in SYSIBM.SYSLINKS table?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is a db2 tablespace?
What is the difference between using bind () and rebind () methods of naming class?
When is the access path determined for dynamic SQL?