Do the live applications generally have 'Data Archival' process whereby the data is moved to a separate database and from there it is read by the same application (read only mode) ? Is there any writeup / whitepaper on this topic ? Saving Changes...
Sort By:
Mark Price PerryBusiness Driven PMO Evangelist| BOT InternationalOrlando, Fl, United States
Dear Anonymous, yes. Live applications generally have data archival processes. This is a standard feature of most database products; DB2, Oracle, SQL, Access, etc. and there are a number of white papers and vendor/product specific "how to" guides for automated operations, triggering, user-controlled, etc. Can you post back a little more information on your environment and which database that you are using and how you would like to invoke the archive? I would be happy to reply again. Cheers. -- Mark Perry, VP of Customer Care, BT International Saving Changes...
Anonymous
Thanks Mr. Perry. The application is developed using DB2 (UDB) with Websphere (Java). Please give me good sites/guides on 'how to archive'. Saving Changes...
Mark Price PerryBusiness Driven PMO Evangelist| BOT InternationalOrlando, Fl, United States
Dear Anonymous, you might have a look at the DB2 tool called the DB2 Data Archive Expert. The DB2 Data Archive Expert is a comprehensive data archiving tool that enables you to move seldom-used data to a less costly storage medium, without any programming. Using this tool, you can save storage space and associated costs, while improving the performance of your IBM DB2 Universal Database (UDB) environment. See the following link: http://www-306.ibm.com/software/data/db2im...hiveexpert.html Also, there are other vendor products like StorageTek's Information Life Cycle Management (ILM) offering. With StorageTek's Lifecycle Director software, DB2 managers in enterprise legacy IBM OS/390 or IBM z/OS environments can automate the movement of older or less frequently accessed files from expensive disk storage systems to lower cost storage media, such as tape, while maintaining speedy data recall. I would start with looking at the IBM DB2 tool, Data Archive Expert. Good luck. -- Mark Perry, VP of Customer Care, BOT International Saving Changes...
