By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Archiving Older Data

P: n/a
We have an environment where we have two databases with identical
structures. In practice we like to keep the data on one of them small
for performance reasons. We have been identifying records over a
certain age, extracting the data, inserting it into the secondary
database and deleting it from the primary database. This has worked
for us in the past through a custom program that reads the system
catalogs, determines the FK relationships and builds queries to
traverse the relationship tree to extract all related records from
associated tables.

Our program is showing its age and not meeting the performance levels
we need. Before we commit resources to revamp it, I wanted to see if
anyone knew of any commercial utilities, or other solutions, that
would aid our situation. Any input would be appreciated. (8.2 FP14,
AIX 5.3)

Regards,

Evan

Aug 13 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"esmith2112" <es********@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
We have an environment where we have two databases with identical
structures. In practice we like to keep the data on one of them small
for performance reasons. We have been identifying records over a
certain age, extracting the data, inserting it into the secondary
database and deleting it from the primary database. This has worked
for us in the past through a custom program that reads the system
catalogs, determines the FK relationships and builds queries to
traverse the relationship tree to extract all related records from
associated tables.

Our program is showing its age and not meeting the performance levels
we need. Before we commit resources to revamp it, I wanted to see if
anyone knew of any commercial utilities, or other solutions, that
would aid our situation. Any input would be appreciated. (8.2 FP14,
AIX 5.3)

Regards,

Evan
IBM has a product that does that called DB2 Data Archive Expert for
Multiplatforms.
http://www-306.ibm.com/software/data...iveexpert.html
Aug 14 '07 #2

P: n/a
On 13 Aug., 21:11, esmith2112 <esmith2...@gmail.comwrote:
Our program is showing its age and not meeting the performance levels
we need. Before we commit resources to revamp it, I wanted to see if
anyone knew of any commercial utilities, or other solutions, that
would aid our situation. Any input would be appreciated. (8.2 FP14,
AIX 5.3)

Regards,

Evan
take a look at Jailer, an open-source and java-based data export tool:
http://sourceforge.net/project/stats...260&ugn=jailer

Regards,
Ralf
Aug 14 '07 #3

P: n/a
Thanks to you both, Mark and Ralf. These are both great starting
points and exactly what I was looking for!

Evan

Aug 14 '07 #4

P: n/a
On 14 Aug., 13:57, Ralf <RalfWis...@gmx.dewrote:
On 13 Aug., 21:11, esmith2112 <esmith2...@gmail.comwrote:
Our program is showing its age and not meeting the performance levels
we need. Before we commit resources to revamp it, I wanted to see if
anyone knew of any commercial utilities, or other solutions, that
would aid our situation. Any input would be appreciated. (8.2 FP14,
AIX 5.3)
Regards,
Evan

take a look at Jailer, an open-source and java-based data export tool
sorry for the wrong URL, please try: http://jailer.sourceforge.net/
>
Regards,
Ralf


Aug 14 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.