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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define clustering index.

614


What is rebind in db2?

572


How to rename a table in DB2 ?

635


Which component is responsible for db2 startup and shutdown?

622


What is sqlca’s maximum length?

664






Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6808


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3112


What is the result of open cursor statement?

634


What is schema in db2?

572


Explain the function of data manager.

632


What is reorg?

615


What is the clustering index in the db2 database?

580


What is dpf in db2?

660


What is the latest version of ibm db2?

733


Explain in detail about buffer manager and its functionalities?

556