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 connect db2 database to datastage?
What is the command used by TSO users to invoke DB2?
Name some fields from SQLCA
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is db2 stogroup?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
what is plan? is plan executable or package?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
how to resolve -805. give clear explination for that
What is nvl in db2?