Is DB2 partitioning a possiblity. for a database with 1TB size and single partition
Posted on 2011-03-07
One of the database is approx 1TB in size and it is currently defined into 1 partition within a limited number of mountpoints.
As the database continues to grow, this large sized database would take an excessive amount of time to recover if that was ever necessary.
Also, DB2 performance is hindered as the database continues to grow without the aid of db2 partitions.
Can any one provide recommendation / suggestions that can be made to address this issue. Also, provide a detailed plan in other ways to address this issue.
Few of the questions:
Is DB2 partitioning a possiblity. If so, what is required to migrate the database to multi-partitioning?
What would be required from a migration or conversion effort?
Would the db2 backups work the same way? Benefits in recovery?
What is required to test this?Are there other suggestions / definitions that can be made in the way the data is organized to improve backup times, performance and recovery SLA's ?
Additional questions would will be added as more info is known.