Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Online Table Move

Status
Not open for further replies.

Prince26

Systems Engineer
May 17, 2019
8
IN
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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top