We are planning to upgrade-optim dir database (DB2 version 9.1 to 9.7).
Our existing Optim directory database(“optimdev”) is on DB2 9.1- If we upgrade the database(DB2) the instance and port number will be changed so-Optim clients need to be modified to reflect these changes.
We are taking backup of exiting optimdev dir database.
Can you please suggest any other precaution measures while doing the upgrade?
This topic has been locked.
2 replies Latest Post - 2012-11-19T02:11:57Z by SystemAdmin
Pinned topic Optim dir database upgrade precautions
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-19T02:11:57Z at 2012-11-19T02:11:57Z by SystemAdmin
Nissad 270003PXUY10 PostsACCEPTED ANSWER
Re: Optim dir database upgrade precautions2012-10-18T19:47:12Z in response to NissadConfig.pdf
Update DBMS Version for an Optim Directory
Tasks to update DBMS version for an Optim Directory
1. Select the Optim Directory to update and select the new DBMS version.
2. Drop the old packages, plans, or procedures and create new ones for the Optim Directory.
3. Update the database signature for the Optim Directory.
- any other suggestion... *
SystemAdmin 110000D4XK304 PostsACCEPTED ANSWER
Re: Optim dir database upgrade precautions2012-11-19T02:11:57Z in response to NissadNissad,
If you can keep the name of the database in the db2 catalog entry the same for all the client machines, and simply update the catalog entries with the new instance/port combo, then it should make the Optim part much easier since all your workstations simply know the Optim Directory by its connect string. Optim doesn't care that the database known on the workstation as OPTIMDIR is now pointed at a totally new database and port, just that there's a database there and hopefully it finds the directory tables and a matching signature. So follow the instructions in the Config guide as you were planning and update all the catalog entries on all your machines - don't forget all your servers as well.
Hope it works out smoothly!