Posted on 2011-03-14
We are running DB2 on IBM Mainframe Z/OS. We have records in a table which has approximately 5 million records per year and has been growing for the past 15 years.
We need to look into possible archiving solutions available within DB2. Can anyone suggest archiving solutions (for example, SQL Server has something called Partitioning) - is there anything that DB2 offers to archive tables, which does not involve modifying our software layer?