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 |
What is the maximum length of sqlca?
What is release/acquire in bind?
What is referential integrity?
How do you find the maximum value in a column in db2?
What is the role of schema in the db2 database?
How to create a table using embedded sql?
What is reorg in DB2
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What are the levels of isolation available with DB2V4
What are the rules for db2 programming?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).