Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DB2 active log and archive
log? Thanks a lot...
- 2 Answers
- 13340 Views
- IBM, I also Faced
- E-Mail Answers
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 |
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is the use of dclgen in db2?
What is rct?
What is a lock?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Is it possible to create an Instance in DB2 using DB2 Control Center ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is a DB2 access path?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
COBOL 
