2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content="I feel we've reached a time where we can migrate users over to the new system. I've worked out how to migrate the CQ database, build issues for both the old (salira) and new (salira2) vobs, multisiting is working, by...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>Migration Plan - Status</title>
8 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
9 <link rel="canonical" href="http://defaria.com/blogs/Status/2006/05/post-4.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
13 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
14 <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2006/04/building-salira.html" title="Building salira2">
20 <link rel="next" href="http://defaria.com/blogs/Status/2006/05/trlock.html" title="trlock">
21 <!-- Open Graph Protocol -->
22 <meta property="og:type" content="article">
23 <meta property="og:locale" content="en-us">
24 <meta property="og:title" content="Migration Plan">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2006/05/post-4.html">
26 <meta property="og:description" content="I feel we've reached a time where we can migrate users over to the new system. I've worked out how to migrate the CQ database, build issues for both the old (salira) and new (salira2) vobs, multisiting is working, by...">
27 <meta property="og:site_name" content="Status">
28 <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
30 <meta itemprop="description" content="I feel we've reached a time where we can migrate users over to the new system. I've worked out how to migrate the CQ database, build issues for both the old (salira) and new (salira2) vobs, multisiting is working, by...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2006/05/post-4.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
62 <div id="content-inner">
63 <ul class="breadcrumb breadcrumb-list">
64 <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
65 <li class="breadcrumb-list-item">Migration Plan</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1811" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">Migration Plan</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2006-05-02T14:42:18-08:00" itemprop="datePublished">May 2, 2006</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/salira/">Salira</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
84 <p>I feel we've reached a time where we can migrate users over to the new system. I've worked out how to migrate the CQ database, build issues for both the old (salira) and new (salira2) vobs, multisiting is working, by and large scripts work as well as CQD. The following is a plan for migrating Salira to the new server. Please let me know your comments and concerns.</p>
86 <p><b>Time Spent:</b> 2 hours</p>
87 <h2>1.0 Migrating Clearquest</h2>
89 <p>This migration is a little more critical because not only does the database need to be remigrated since bugs have probably been added since my test migration but clients must also update to the latest version of Clearquest in order to access the new database. Also, CQD (or rather CQD clients) need to ask the new server for information. Luckily the later involves a simply change to a library however timing remains important. This has to be done in one swoop.</p>
91 <p>The following needs to take place:</p>
94 <li>Shutdown access to the database on sons-clearcase</li>
95 <li>Backup the database</li>
96 <li>Use installutil to copy the user db to the new server. <br>
98 <li>Export and import user accounts (since you've made changes)</li>
99 <li>Convert the database to SQL Anywhere 8.0 format</li>
100 <li>Test new database</li>
101 <li>Switch cqc.pm library to default to new server</li>
102 <li>Have client upgrade to the new Clearquest</li>
105 <p>I suspect that the database conversion will take at most 4 hours so doing this on say Saturday or Sunday might be a good idea. As for desktop installations the users should be able to simply type "upgrade clearquest" in a Cygwin window. It will prompt the user to proceed then
106 it will uninstall the old Clearquest, install the new Clearquest and reboot the users desktop. The user will then need to import a Clearquest connection profile and they should be set.</p>
108 <p>Bear in mind that is anything goes wrong the users should be able to use the CQWeb interface by pointing to <a href="http://sons-sc-cc/cqweb/login">http://sons-sc-cc/cqweb/login</a>. China users will need to be made aware of the new server location in the URL but should otherwise be unaffected as I doubt that China users use the Clearquest client directly (way too slow!).</p>
110 <h2>2.0 Migrating Clearcase</h2>
112 <p>In general users need to stop using views that are sons-clearcase oriented. By that I mean they need to start checking in their work and generally getting their views to the state where they can remove them. Then they need to switch-<server> to sons-sc-cc and create new views there. As we are currently multisiting between sons-clearcase and sons-sc-cc they can migrate at their leisure however bear in mind that sons-clearcase should be going away. See also <i>Mastership Issues</i> below.</p>
114 <p>Users don't necessarily need to upgrade their Clearcase software as the old software will work with the new server, however you should urge them to do so. Again I plan on updating the upgrade command to likewise allow desktop users to simply type "upgrade clearcase".</p>
116 <p>One thing that users should do is change the symlink for /etc/site_parms from /view/official/Tools/adm/etc/site_parms.US to /view/official/Tools/adm/etc/site_parms.SC. Most of my scripts rely on this site_parms file to set environment variables to describe particulars about the site. This can be done with the following:</p>
118 <div class="code"><pre>
120 $ ln -s /view/official/Tools/adm/etc/site_arms.SC /etc/site_parms
123 <h2>3.0 Decommissioning sons-clearcase</h2>
125 <p>Sons-clearcase has served you many years as the hub of both Clearcase/Clearquest services as well as a build machine. It has performed many duties and has done them well. Decommissioning such a server so near and dear to Salira's heart will take some doing, some
126 finesse. The overriding concern is to untangle sons-clearcase from day to day operations and assign those duties over to sons-sc-cc in a proper manner before decommissioning sons-clearcase. Than have a nice going away party!</p>
128 <p>As users migrate to using the new server and once all elements are checked in and views are no longer needed they should be removed. We need to get to a place where all Clearcase activity on sons-clearcase is stopped, checked in and removed.</p>
130 <p>There are some ancillary functions that sons-clearcase is still performing that you may be unaware of such as licensing. These too will need to be transfered to the new server.</p>
132 <p>Finally sons-clearcase can be powered down and if there are any things we've missed it could be easily powered back up if need be.</p>
134 <h3>3.1 Lock issues</h3>
136 <p>One thing that is not multisited is locks on label/branch/etc types. Salira relies on these logs. I will need to write a script to evaluate the locks in the vobs on sons-clearcase and to issue the same locks on sons-sc-cc. I will work on this this week.</p>
138 <h3>3.2 Mastership Issues</h3>
140 <p>With multisited vobs comes issues of mastership. As you know a branch can only be mastered by one replica. The current vobs' main branch is mastered on sons-clearcase as are branches such as REL_1.0, etc. Mastership should be transfered to sons-sc-cc before sons-clearcase gets decommissioned.</p>
142 <p>There is a command called chmaster that luckily has a -all option to change the mastership of all objects to the new server. But it wants to have everything checked in and nothing locked.</p>
144 <h3>3.3 Replica removal</h3>
146 <p>With the vobs replicated to sons-sc-cc and all Clearcase views removed and mastership moved to sons-sc-cc, the final act would be to remove the US replica of the vobs from the vob family. This way sons-sc-cc and sons-cc in China would no longer attempt to update the US replicate on sons-clearcase (The replica on sons-sc-cc is called the SantaClara replica and remains in the vob family hosted by sons-sc-cc).</p>
148 <h2>4.0 License Issues</h2>
150 <p>Sons-clearcase also served as a license server for both Clearcase and Clearquest. Salira will need to contact IBM/Rational in order to obtain new licenses for these as they are host based. This can be delayed however it will need to be done before sons-clearcase can be decommissioned.</p>
152 <h2>5.0 Miscellaneous Issues</h2>
154 <p>There are several scripts which use some magic to determine where to find Perl library code (here or in China). That magic hard codes sons-clearcase as the server here to use. That'll need to change to use sons-sc-cc before a complete shutdown of sons-clearcase is doable.</p>
156 <nav class="page-navigation entry-navigation pagination content-nav">
157 <ul class="page-navigation-list">
159 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2006/04/building-salira.html" title="Building salira2">Previous entry</a></li>
162 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2006/05/trlock.html" title="trlock">Next entry</a></li>
167 <aside id="zenback" class="zenback feedback">
168 Please paste Zenback script code here.
175 <aside class="widgets related" role="complementary">
176 <nav class="widget-search widget">
177 <div class="widget-content">
178 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
180 <input type="text" name="search" value="" placeholder="Search...">
182 <input type="hidden" name="IncludeBlogs" value="8">
184 <input type="hidden" name="limit" value="20">
185 <button type="submit" name="button">
186 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
192 <nav class="widget-archive-category widget">
193 <h3 class="widget-header">Categories</h3>
194 <div class="widget-content">
197 <ul class="widget-list">
200 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
208 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
216 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
224 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
232 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
240 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
248 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
256 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
264 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
272 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
280 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
288 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
300 <nav class="widget-archive-dropdown widget">
301 <h3 class="widget-header">Archives</h3>
302 <div class="widget-content">
304 <option>Select a Month...</option>
306 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
310 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
314 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
318 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
322 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
326 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
330 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
334 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
338 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
342 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
346 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
350 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
354 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
358 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
362 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
366 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
370 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
374 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
378 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
382 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
386 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
390 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
394 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
398 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
402 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
406 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
410 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
414 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
418 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
422 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
426 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
430 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
434 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
438 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
442 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
446 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
450 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
454 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
458 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
462 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
466 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
470 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
474 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
478 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
482 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
486 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
490 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
494 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
498 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
502 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
506 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
510 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
514 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
518 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
522 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
526 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
530 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
534 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
538 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
542 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
546 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
550 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
554 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
558 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
562 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
566 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
570 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
574 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
578 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
582 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
586 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
590 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
598 <div class="widget-syndication widget section">
599 <div class="widget-content">
600 <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
608 <footer id="footer" role="contentinfo">
609 <div id="footer-inner">
610 <div id="footer-content">
611 <nav role="navigation">
613 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
619 <p class="license">© Copyright 2016.</p>
620 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
626 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
627 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>