Is it possible to transfer the data from a non-partitioned table to a partitioned table using the ADMIN_MOVE_TABLE procedure in db2 10.5 version?
As the records in the non-partitioned table is almost 500 million and the performance is degrading day by day on that table.
Runstats and Reorg are performed on those tables on a regular basis.
Purging the old data is also I have thought but business team is taking a lot of time to conclude with what data they need.
Please suggest if anything can be done to improve the performance...
As the records in the non-partitioned table is almost 500 million and the performance is degrading day by day on that table.
Runstats and Reorg are performed on those tables on a regular basis.
Purging the old data is also I have thought but business team is taking a lot of time to conclude with what data they need.
Please suggest if anything can be done to improve the performance...