Archiving Older Data

esmith2112

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

Mark 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

Ralf

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

esmith2112

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

Ralf

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