DB2

Database migration is one of the most time consuming portions of the migration process. If we are migrating from DB2 , review the following topics to improve the speed of the database migration process.

• Configure transaction logging space
  When we migrate from earlier versions of WebSphere Portal, certain portions of the actual database migration use database transactions that can contain large volumes of data change. In order for the database to accommodate these transaction changes, the amount of space available to the database transaction logs might need to be increased.

• Update database statistics
  Statistics are information that is collected about the contents of the database tables and indexes. They are used by the cost-based optimizer in the database to influence the approach (query plan) used to run SQL queries. By collecting updated or new statistics, you provide the database optimizer the most up-to-date information about the tables and indexes. Therefore, the query execution plans are generated as efficiently as possible.

• Prepare DB2 for large data sets migration
  If we use DB2 and have a large amount of content in the JCR repository (for example, Web Content Manager data), prepare the DB2 for migration. We must update several settings related to performance.

Parent Database considerations