Preparing DB2® for large data sets migration | HCL Digital Experience
If you use DB2® and have a large amount of content in the JCR repository (for example, Web Content Manager data), prepare the DB2® for migration. You must update several settings that are related to performance.
About this task
Important: The settings
described here are optimized for migration rather than day-to-day
operation. After migration completes successfully, you can revert
any changes back to the values in use before migration.
Procedure
- Update the lock list size for the database. A value of at least 10000 is recommended.
- Disable all automatic maintenance on the database, including health monitoring.
- Increase the package cache size. A value of at least 24000 is recommended.
- Increase the statistics heap size. A value of at least 16384 is recommended.
- Perform a complete reorganization of the tables and indexes on the database that is used for migration.
- Collect detailed statistics with distribution for all tables
and indexes.Note: While the migration is in progress, it might be necessary to collect detailed statistics to continue to allow the database optimizer to select efficient access plans.