Archiving business data

Dear experts, The live environment database contains 10 years of data. It is a OLTP environment. We are planning to archive the historical data like on every financial year the old data need to be archived from production. what is the best way to archive the old data and whenever the old data is required it need to be easily accessed. Our environment: Version IDS 12.10 FC8 Platform: Windows Suggest the best way

Hi, it very much depends on the type of archiving you want to establish. There is no "easy" solution to this requirement. You probably have a number of tables to consider if these are referenced or not by the old data. The table layout plays an important role. 1) do you want to delete the history data from your active live database and want to be able to access the old data in a separate environment read-only ? -> maybe you should just make a copy of your environment and put it in a virtual machine together with the current status of the application, so you can start this instance on demand. 2) do you want to move the old data just to other "long term" disks ? -> partitioning is your friend then, but I assume you need to delete 3) do you want to archive also "old" masterdata, which is not referenced any more ? -> you need to make a concept which handles each table in your environment. Marcus Haarmann Von: "MUKESH TANUKU" <mukeshbt1328@gmail.com> An: "ids" <ids@iiug.org> Gesendet: Donnerstag, 22. Februar 2018 09:32:55 Betreff: Archiving business data [40731] Dear experts, The live environment database contains 10 years of data. It is a OLTP environment. We are planning to archive the historical data like on every financial year the old data need to be archived from production. what is the best way to archive the old data and whenever the old data is required it need to be easily accessed. Our environment: Version IDS 12.10 FC8 Platform: Windows Suggest the best way ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thank for your immediate response. - actually we implemented HDR environment. - we are having nearly 20 tables with lacks of records, which we thought to delete/move the data in these tables to other. - is partitioning the tables will help us in this scenario. - the main 20 tables are linked/reference to other tables as well. - any disadvantages if we go with table partitioning. which process we need to plan. In rare scenarios the old data get accessed.

Hi. You can partition the old tables, using RANGE specifications per a specific retention period, and then detach (manually, or even automatically, since you are in 12.10) your old fragments to external tables, keeping them in a separated array of disks, or wherever you want. You can even remove your disk and keep it safe, in case you need it, just mount it again, and your external data will be there. Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Informix on Cloud - Database Administrator - 2017 IBM dashDB Managed Service for Analytics and Transactions - 2017 DB2 Advanced DBA - v10.5 for LUW IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero Informix independent consultant ________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de MUKESH TANUKU <mukeshbt1328@gmail.com> Enviado: quinta-feira, 22 de fevereiro de 2018 05:32 Para: ids@iiug.org Assunto: Archiving business data [40731] Dear experts, The live environment database contains 10 years of data. It is a OLTP environment. We are planning to archive the historical data like on every financial year the old data need to be archived from production. what is the best way to archive the old data and whenever the old data is required it need to be easily accessed. Our environment: Version IDS 12.10 FC8 Platform: Windows Suggest the best way ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.