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
- 13477 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 |
what is + sign and -ve sign for sql code ?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Can SQL statements/queries be included in a copybook?
how can i pull up a query which was previously stored in qmf
How many types of page locks can be held in db2?
Where would you find information about the type of database authority held by the user?
What is a recovery log?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What will happen, while trying to close the closed cursor.
What is index cardinality?
How would you print the output of an SQL statement from SPUFI?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
COBOL 
