Why might full image copies be faster to implement than an
incremental image copy?
Answer Posted / 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 |
Post New Answer View All Answers
What is database manager in db2?
What is meant by union and union all?
What is sqlca?
Can we update view in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to check sequence on a table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the difference between nvl and coalesce?
Mention the downsides of page level lock.
What is null indicator in db2?
Is the primary key a clustered index?
Why db2 is called db2?
Why do we use cursor?
What are packages in db2?
What is the function of logging in the db2 database?