2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Managed to migrate the production user database Clearquest desktop users need to upgrade their software. Meantime they can use the web interface Verified cqd and triggers work Documented how to switch a desktop to the new server Documented how...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>Production User Database Migrated - 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/04/production-user.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/more-fun-with-s.html" title="More fun with SQL ANYWHERE">
20 <link rel="next" href="http://defaria.com/blogs/Status/2006/04/ant-rant.html" title="Ant Rant">
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="Production User Database Migrated">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2006/04/production-user.html">
26 <meta property="og:description" content=" Managed to migrate the production user database Clearquest desktop users need to upgrade their software. Meantime they can use the web interface Verified cqd and triggers work Documented how to switch a desktop to the new server Documented how...">
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=" Managed to migrate the production user database Clearquest desktop users need to upgrade their software. Meantime they can use the web interface Verified cqd and triggers work Documented how to switch a desktop to the new server Documented how...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2006/04/production-user.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">Production User Database Migrated</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1804" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">Production User Database Migrated</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2006-04-15T18:55:17-08:00" itemprop="datePublished">April 15, 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">
85 <li>Managed to migrate the production user database</li>
87 <li>Clearquest desktop users need to upgrade their software. Meantime they can use the web interface</li>
89 <li>Verified cqd and triggers work</li>
91 <li>Documented how to switch a desktop to the new server</li>
93 <li>Documented how to build on the new server</li>
96 <p><b>Time Spent:</b> 4 Hours</p>
97 <h2>Production User Database Migrated!</h2>
99 <p>More progress in this area.</p>
101 <p>I decided to try to use the Sybase Central tool to see if I could
102 verify or otherwise fix this potentially bad database. I also looked at
103 running Chkdisk as the eventlog was reporting some bad sectors on the
104 disk. Unfortunately chkdisk cannot fully check the disk since the
105 database is on the C drive and the C drive is currently busy. Normally
106 you just set a flag and chkdisk will run after next boot. But such a
107 chkdisk will take a long time on a big disk.</p>
109 <p>Meantime in Sybase Central I decide to do fresh backups of the
110 databases which seem to go OK. These backup databases look no different
111 really than the regular databases so I run validate on the backup
112 database. Hmmm.... Doesn't seem to have any errors. So I tried the
113 installutil copyuserdb to copy the <b>backup</b> database <b>as if is
114 was the real production database</b> to the new server. Hmmm.... That
117 <p>Next I had to go into Clearquest Maintenance Tool and select Schema
118 Respository: Upgrade: Selected Connection and upgrade the production
119 user database. That worked!</p>
121 <p>I checked the Clearquest web (<a href="http://sons-sc-cc/cqweb/login">http://sons-sc-cc/cqweb/login</a>) and the
122 new database is indeed there and working!</p>
124 <h2>Clearquest Desktop Clients Need to Upgrade</h2>
126 <p><font color="#ff0000"><b>Problem:</b> Clearquest 2002.05.00 desktop
127 clients cannot access this new database!</font></p>
129 <p>I tried creating a connection profile to this new database and then
130 importing it on the old server running 2002.05.00.This did not work!
131 Later I read in the Rational Suite Migration Guide:</p>
133 <blockquote>Your network environement can contain misxed versions of
134 ClearCase and ClearQuest clients (where some clients are at v2003 and
135 some clients are at ealier versions) if these products are in a
136 standalone environment, that is:</p>
141 <p>If your vendor database is SQL Anywhere, you do not plan to upgrade to
142 SQL Anywhere 8.0 until all ClearQuest clients and databases have been
143 upgraded to version 2003.</p>
146 <p>So we'll have to upgrade desktop clients to 2003.06.00! Luckily people
147 can use the Clearquest Web Client...</p>
149 <h2>Clearquest Daemon Works with Minor Tweaks</h2>
151 <p>Checked that cqd and cqc work with the new server. All that need to be
152 changed is to change the default server from sons-clearcase ->
153 sons-sc-cc in cqc.pm.</p>
155 <h2>Checked and Triggers Work in New Environment</h2>
157 <p>I was able to check to see that the triggers function in the new
160 <h2>Switching Your Desktop to the New Server</h2>
162 <p>Use the following steps switch your desktop to the new server:</p>
165 <li>Stop all Clearcase activity. Close any Clearcase Explorer windows
166 and any shells in Clearcase views.</li>
167 <li>In a Cygwin shell type ct umount -all to unmount all vobs.</li>
168 <li>Go to Control Panel: Clearcase</li>
169 <li>Click on the Services tab then Stop Clearcase</li>
170 <li>Click OK to the dialog saying Clearcase has stopped</li>
171 <li>Click OK to <b>close</b> the Clearcase Control Panel Applet</li>
172 <li>Start the Clearcase Control Panel <b>again</b></li>
173 <li>On the registry tag, change the registry server to sons-sc-cc</li>
174 <li>Click OK to close the Clearcase Control Panel <b>again</b></li>
175 <li>On the Registry tab click the drop down arrow for Windows Region.
176 You should see the new SC region. Select it.</li>
177 <li>Click on <b>Apply</b></li>
178 <li>Click on the Services Startup tab and then Start Clearcase</li>
179 <li>Close the Clearcase Control Panel</li>
180 <li>Start a Cygwin shell and type ct hostinfo -l. You should see
183 <div class=code><pre>
184 <font color="blue"><b>[ccadmin] adefaria:</b></font><u>ct hostinfo -l</u>
186 Product: ClearCase 2002.05.00+
187 Operating system: Windows NT 5.1 (build 2600) Service Pack 2
188 Hardware type: Pentium
189 Registry host: <b>sons-sc-cc</b>
190 Registry region: <b>SC</b>
191 License host: sons-clearcase
194 <p>As you can see we are now pointing to the sons-sc-cc registry
195 host and the SC region. Sons-clearcase is still the license server at
196 this time. Type ct lsview and you should see:</p>
198 <div class="code"><pre>
199 <font color="blue"><b>[ccadmin] adefaria:</b></font><u>ct lsview</u>
200 official \\sons-sc-cc\Views\SALIRA\ccadmin\official.vws
201 3.1.ccadmin \\sons-sc-cc\Views\SALIRA\ccadmin\3.1.ccadmin.vws
202 szhu_view_2 \\sons-sc-cc\Views\SALIRA\szhu\szhu_view_2.vws
205 <p>A noticeably smaller list of views that are on sons-sc-cc in
209 <p>Follow a similar set of steps to switch back to the old registry server
210 (sons-clearcase) and region (US). No reboots required (provided you
211 properly stop Clearcase and do things like get out of views and umount
214 <h2>Attempting an Official Build on sons-sc-cc</h2>
216 <p>This procedure can be done either by following the procedure above to
217 switch your desktop to the new server or simply use rsh/telnet to log
218 into sons-sc-cc. Once there:</p>
221 <li>Make user that the 3.1.ccadmin view is started<br>
222 <div class=code><pre>
223 $ ct startview 3.1.ccadmin
225 <li>Make sure the salira vob is mounted:<br>
227 <div class=code><pre>
230 <li>Change directory to the build area:<br>
232 <div class=code><pre>
233 $ cd /dview/3.1.ccadmin/salira/neopon/build
236 <div class=code><pre>
241 <nav class="page-navigation entry-navigation pagination content-nav">
242 <ul class="page-navigation-list">
244 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2006/04/more-fun-with-s.html" title="More fun with SQL ANYWHERE">Previous entry</a></li>
247 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2006/04/ant-rant.html" title="Ant Rant">Next entry</a></li>
252 <aside id="zenback" class="zenback feedback">
253 Please paste Zenback script code here.
260 <aside class="widgets related" role="complementary">
261 <nav class="widget-search widget">
262 <div class="widget-content">
263 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
265 <input type="text" name="search" value="" placeholder="Search...">
267 <input type="hidden" name="IncludeBlogs" value="8">
269 <input type="hidden" name="limit" value="20">
270 <button type="submit" name="button">
271 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
277 <nav class="widget-archive-category widget">
278 <h3 class="widget-header">Categories</h3>
279 <div class="widget-content">
282 <ul class="widget-list">
285 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
293 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
301 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
309 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
317 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
325 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
333 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
341 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
349 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
357 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
365 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
373 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
385 <nav class="widget-archive-dropdown widget">
386 <h3 class="widget-header">Archives</h3>
387 <div class="widget-content">
389 <option>Select a Month...</option>
391 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
395 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
399 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
403 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
407 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
411 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
415 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
419 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
423 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
427 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
431 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
435 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
439 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
443 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
447 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
451 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
455 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
459 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
463 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
467 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
471 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
475 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
479 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
483 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
487 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
491 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
495 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
499 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
503 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
507 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
511 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
515 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
519 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
523 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
527 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
531 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
535 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
539 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
543 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
547 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
551 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
555 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
559 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
563 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
567 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
571 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
575 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
579 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
583 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
587 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
591 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
595 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
599 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
603 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
607 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
611 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
615 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
619 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
623 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
627 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
631 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
635 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
639 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
643 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
647 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
651 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
655 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
659 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
663 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
667 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
671 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
675 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
683 <div class="widget-syndication widget section">
684 <div class="widget-content">
685 <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>
693 <footer id="footer" role="contentinfo">
694 <div id="footer-inner">
695 <div id="footer-content">
696 <nav role="navigation">
698 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
704 <p class="license">© Copyright 2016.</p>
705 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
711 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
712 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>