Migration estimates for Release 9.5
The time it takes to upgrade from Release 9.4 to Release 9.5 varies due to numerous factors. However, you can review this information for a migration estimate.
It is recommended that you use the information in this topic as a rough estimate and not as a guarantee.
The following hardware configuration was used to arrive at the time estimates:
DB Version: 10.5.5
DB Server OS: RHEL 7.2
Number of CPUs on the DB Server: eight 2.3 GHz processors
RAM on Database Server: 32 GB
Disk Filesystem: EXT4
Application Server (The server on which the migration was performed):
Number of CPUs: two 2.3 GHz processors
RAM: 8 GB
OS: RHEL 6.7
Row counts for key tables
Table 1 provides row counts for key tables in the sample database for Release 9.5.
| Data | Current Data Size | History Data Size |
|---|---|---|
| Number of Orders | 2546778 | 4200133 |
| Number of Order Lines | 6252203 | 8856835 |
| Number of Items | 1718266 | N/A |
| Number of Inventory Items | 2176060 | N/A |
| Number of Resource Pool Capacity Consumptions | 175224 | N/A |
Migration estimate
Table 2 provides time estimates
pertaining to the migration process based on the data in Table 1.
Note: Time
is dependent on database tuning when retrieving count of records on
the database.
| Time | Task |
|---|---|
| 7 sec. | copyextensions |
| 3 min. 58 sec. | initupgrade |
| 4 sec. | migration-validation |
| ~20 sec. | update-metadata-tables (For sharded environments only) |
| ~7 sec. | delete-stale-colony-pool (For sharded environments only) |
| 10 sec. | alter-history-tables |
| 10 sec. | install-history-indexes |
| 32 sec. | upgrade-history-tables |
| 12 sec. | alter-transaction-tables |
| 9 sec. | install-transaction-indexes |
| 4 min. 12 sec. | upgrade-transaction-tables |
| 31 sec. | migrate-doc-params |
| 1 min. 58 sec. | Add-in upgrade-transaction-tables |
| 25 sec. | Add-in upgrade-history-tables |
| 41 sec. | run-history-drop |
| 55 sec. | run-transaction-drop |
| ~ 40 sec. | migrate-custom-doc-types |
| ~ 40 sec. | migrate-char-to-varchar-h |
| ~ 40 sec. | migrate-char-to-varchar |