asked on

Automatically backup data

Hi all,

I need to find the best solution -
back up data on a table basis every hour (or every day) automatically, to a backup table in the same instance. Cannot be triggers, that would affect performance too much.

Any help is appreciated

Kent Olsen

Hi darrgyas ,

Depending on your needs and the amount of data involved, you might consider replication. That's a process where you have another database, usually on another server, and when updates are applied to one database, the changes are automatically applied to the other.

If you really need to copy data from a key table (or tables) on a regular basis, there are a number of considerations.

1. How much data will you copy (number of row and total size of the data).
2. Do you need to copy the entire table?
3. Can you copy only the new rows and can you identify them?
4. Are you going to delete data behind the copy?
5. Will the new table be completely reloaded or is the data added to existing data?

There are more questions, but that should be a great start.

Kent

Member_2_276102

And what platform is DB2 on? That goes specifically to the element of triggers which might be your best choice if performance is an issue.

Tom

darrgyas

ASKER

The platform is Windows, DB2-Express-C 9.74

Each table is being written to appr 200 times a second, average record is appr 200 bytes
I don't need the entire table - just the new rows
I can identify the new rows by the timestamp
The data from the original table will not be deleted
The new data will be added to the backup table

ASKER CERTIFIED SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

darrgyas

ASKER

Thank you