Interested to Buy Any Domain ? << Click Here >> for more details...
Why might full image copies be faster to implement than an
incremental image copy?
- 4 Answers
- 7032 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Full image copy uses tablespace scan to make a copy.
Incremental copy has to access the space map pages to check
if the page has been updated or not before copying the
page.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / andank
I think the question is wrong. Full image Copies are not
faster than incremental image copies.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mehdee
- Incremental image copies are for very large DB2 tables,
and it will not work if you are also loading data into it.
It will work only if this very large DB2 table is being
updated or inserted or deleted. Now that for the backup
purpose we do image copy every day, you can tell that the
daily updated or inserted or deleted rows are no match to
the number of rows that this DB2 table contains. And since
these image copies will be on tapes then you can tell how
faster and more efficient is to do incremental image copies.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahesh vasudevan
It all depends on the size of the tablespace. Full image
copy gives us full recovery consitent state. In case of
Incremental image copy the page needs to be checked against
the condition provided for incremental image copy and in
addition to it just by merging the incremental image copies
we can not get a full recovery of tablespaces...additional
archive log records and prior full image copies are
required. so from the recovery point of view full image copy
would be faster than these incremental image copy.....by the
way the question should be very precise and not be vauge as
it has been posted.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is rct?
Is db2 a mainframe?
Define db2.
Explain how can you do the explain of a dynamic sql statement?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
List down the data types in the db2 database.
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a db2 table?
COBOL 
