Is there a software-based method for archiving seldom used data? The data cannot be purged, as we may need it for business or legal conformity reasons. We run both DB2 and Oracle databases.
The word "archiving" has a number of different definitions. It sounds like you are looking for a way to maintain this data on off-line storage or on near-line storage.
The important thing is that you use the facilities included by the database vendor or by software vendors that specifically work with the database system and are certified by the DB vendor.
Options for databases include extract operations and exports. I would look for companies that provide database management software, not necessarily storage software.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in our Storage Networking discussion forum.
This was first published in March 2002