Skip to main content

Software  >  Rational  >  

Upgrading a schema version in a ClearQuest MultiSite environment

 Technote (FAQ)
 
Question
What are the steps for schema version upgrades in an IBM® Rational® ClearQuest® MultiSite environment?
 
Answer
This procedure describes how to introduce a new schema version to a ClearQuest MultiSite clan by synchronizing the new schema to all sites before upgrading any user databases. Rational requires that you follow this procedure to ensure a stable and reliable ClearQuest MultiSite environment.

In addition to following this procedure, you must not do the following when using ClearQuest MultiSite:
  • Delete record types and states.
  • Change the working master if all databases are not using the same schema version.
  • Change mastership of package-owned queries

Schema Upgrade Instructions:
  1. Make the desired schema changes and test them against a local test database.

  2. Notify all users that maintenance is scheduled and they must disconnect from all user databases in the ClearQuest MultiSite clan.

  3. Suspend automated synchronization between ALL user databases in the ClearQuest MultiSite clan.

  4. Stop and restart your vendor database server to ensure that there are no open connections to the schema repository or user database.

  5. Synchronize all sites in the ClearQuest MultiSite clan. After synchronization, check the incoming and outgoing storage bays to make sure that all packets were sent and imported. Run the lsepoch command at each site to verify that all replicas report the same epoch estimates.

  6. Back up all schema repositories and user databases in the ClearQuest MultiSite clan.

  7. Check in the new schema version at the master schema repository replica, but DO NOT upgrade the user database.

  8. Export and send an update packet from the MASTR family only (not the user database family) to all other sites in the clan.

    multiutil syncreplica -export -clan DEMO -site SITEA
    -family MASTR -u admin -p "" -out c:\cqms\syncA.xml SITEB
    Multiutil: Packet file 'c:\cqms\syncA.xml' generated
  9. Import the update packet at all sites.

    multiutil syncreplica -import -clan DEMO -site SITEB
    -family MASTR -u admin -p "" c:\cqms\syncA.xml
    Multiutil: 1 transactions from SITEA have been replayed into the MASTR database
    Multiutil: Deleting packet c:\cqms\syncA.xml

    Note: At this point, the schema version exists at all the sites in the clan, but the user databases have not been upgraded.

  10. Upgrade the user databases by performing the following steps. This ensures that all replicas in the family are running the same version of the schema before synchronization is restarted.
    1. Upgrade the user database at the working master site.
    2. Upgrade the user databases at all remaining sites.
    3. Synchronize all sites.

  11. Restart synchronization among the user databases at your sites.

  12. Confirm that synchronization was successful and that all user databases in the clan are using the same schema version.

  13. Notify users that the replicas are available.




Do you need more help?

For additional assistance, contact IBM Rational Client Support:
Submit a Service Request (SR)
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Software DevelopmentRational ClearQuest MultiSiteMultiutil
 
Historical Number
154455207
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Software Development
 Change, Configuration, & Release Management
 Rational ClearQuest MultiSite
 Multiutil
 Operating system(s):
  Windows
 Software version:
  7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5, 7.0.0.6, 7.0.0.7, 7.0.0.8, 7.0.1, 7.0.1.1, 7.0.1.2, 7.0.1.3, 7.0.1.4, 7.0.1.5, 7.0.1.6, 7.0.1.7, 7.1, 7.1.0.1, 7.1.0.2, 2003.06.00, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16
 Reference #:
  1132117
 IBM Group:
 Software Group
 Modified date:
 2009-11-01

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.