Monday, 10 September 2018

Upgrade ODS on Notes Databases, Templates And Mail.Box Files

We are currently working on the final preparation for the upgrade to Domino 9.0.1 Feature Pack 9 next week. One of the new features in Feature Pack 9 relates to performance, namely that databases and views can be opened more quickly in databases that are enabled for transaction logging. It takes less time to open databases and views that are at ODS 52 or higher and enabled for transaction logging. Previously, performance for opening databases or views could be slow in frequently updated databases. This improvement is due to the implementation of less contention with update operations.
Therefore it is very important to update the ODS to ODS52. Below the steps I performed to update all databases, templates and files to ODS52 after the upgrade to Feature Pack 9 in our test environment. In Domino 9 there is a new compact switch "-upgrade". "-upgrade Upgrades databases created with older DB classes to the most recent class."

1. Domino Server - NOTES.INI
First I added the parameter Create_R9_Databases=1 to the NOTES.INI file.

In addition it is extremely important that the Transaction Logging is enabled on the Domino server! Enabling transaction logging can improve server performance in most cases. Transaction logging saves processing time because it allows Domino to defer database updates to disk during periods of high server activity. Transactions are recorded sequentially in the log files, which is much quicker than database updates to random, non-sequential parts of a disk. Because the transactions are already recorded, Domino can safely defer database updates until a period of low server activity.

In case Transaction Logging is not enabled on the Domino Server you can enable Transaction Logging by following the steps below.

Ensure that all databases to be logged reside in the Domino data directory, either at the root or in subdirectories.
From the Domino Administrator, click the Configuration tab.
In the "Use Directory on" field, choose the server's Domino Directory.
Click Server Configuration, and then click Current Server Document.
Click the Transaction Logging Tab.
Complete all fields on the Transaction Logging Tab and then save the document.

For more information regarding Transaction Logging on Domino Server see the IBM Support document Transaction Logging on Domino Servers.

2. Upgrade ODS
Next shut down the Domino Server en start the Command Prompt. Navigate to Program Directory of Domino and enter the following command: ncompact -ODS -* -upgrade

Remarks: In this case I use -ODS -* instead of compact -c because I want to upgrade all Notes databases, Templates and Mail.Box files and not just the Notes databases. -ODS -* will upgrade Notes databases, Templates and Mail.Box files which have an older ODS and compact -c will only compact / upgrade all Notes database except the Templates and Mail.Box files.
The upgrade can take some time but runs without any problems on a Domino 9.0.1 Feature Pack 9 server.

No comments:

Post a Comment