Is there a best practice or suggestion for moving our older data in our history logs tables to another database and still having the data available along with the newer history log data (i.e. union the old and new history logs)? We have many terabytes of data that is causing database maintenance problems keeping it in our main schema but we need to retain the older data for audit purposes.
Deleting is the mother of all housekeeping! :)
If you need the data for historical reports move it to a data warehouse.
Don’t try to join huge tables of old data in the IFS Cloud DB.
There is a data archive concept in IFS Cloud to move/delete old data:
https://docs.ifs.com/techdocs/23r2/030_administration/050_data_management/020_data_archiving/
IFS Cloud is a OLTP db not a data warehouse - you should delete or move old transactional data.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.