defaria.com/blogs/Status/2006/04/more-sql-anywhe.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" Installed SQL Anywhere 8.0.3 Patch to fix problem with Services folder not appearing in Sybase Central Spent time trying to figure out how to get a service configured. Eventually figured out that I need to specify -n &lt;machine&gt; as...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>More SQL Anywhere Wrestling - 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/more-sql-anywhe.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  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>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2006/04/save-the-logfil.html" title="Save the logfiles! IFrames">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2006/04/build-bugs-test.html" title="Build bugs, Test suite still not runing nightly">
  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="More SQL Anywhere Wrestling">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2006/04/more-sql-anywhe.html">
  26     <meta property="og:description" content=" Installed SQL Anywhere 8.0.3 Patch to fix problem with Services folder not appearing in Sybase Central Spent time trying to figure out how to get a service configured. Eventually figured out that I need to specify -n &amp;lt;machine&amp;gt; as...">
  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">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" Installed SQL Anywhere 8.0.3 Patch to fix problem with Services folder not appearing in Sybase Central Spent time trying to figure out how to get a service configured. Eventually figured out that I need to specify -n &lt;machine&gt; as...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2006/04/more-sql-anywhe.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  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">More SQL Anywhere Wrestling</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1801" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">More SQL Anywhere Wrestling</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-11T00:37:08-08:00" itemprop="datePublished">April 11, 2006</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/salira/">Salira</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Installed SQL Anywhere 8.0.3 Patch to fix problem with Services folder not appearing in Sybase Central</li>
  86
  87   <li>Spent time trying to figure out how to get a service configured. Eventually figured out that I need to specify -n &lt;<i>machine</i>&gt; as part of the parms or starting the service would just hang</li>
  88
  89   <li>Instructions given from Rational spoke of converting databases on a single server. This is not what we are doing there. Tried various things in an attempt to extend the directions to two servers and get the installutil command to run. Nothing was working.</li>
  90
  91   <li>Scoured the Rational documents and the net for "preparedbforupgrade" - turned up little except some guys personal web site talking about how the <i>Rational Suite - Upgrade Guide</i> describes the upgrade procedure with two servers and here's the single server procedure. That's nice, and it's pretty much the exact technote that the Rational support engineer pointed me to. However where's the double server procedure!</li>
  92
  93   <li>Scoured the Rational site, this time for <i>Rational Suite - Upgrade Guide</i>. Found it! It was a in a pdf file! Apparently the Rational site search engine doesn't search inside pdf files. They should take a lesson from Google! Also searched the system for this pdf file (rs_upgrade.pdf) and it was not on the system. Now why isn't it part of what gets installed?</li>
  94
  95   <li>Started doing the steps for converting the database as described in the <i>Rational Suite - Upgrade Guide</i>. See below for more.</li>
  96 </ul>
  97
  98 <p><b>Time Spent:</b> 4 hours</p>
  99                   <h3>Still issues with SQL Anywhere upgrade</h3>
 100
 101 <p>According to the <i>Rational Suite - Upgrade Guide</i> I need to import the connection profile from the SQL Anywhere 5.0 server then update it to add on the new SERVER_VER connection option (I believe I need to specify SERVER_VER=8.0.3 since I've now patched to 8.0.3) then save that connection profile. If I change the database server name to the new name but leave the Physical Database Name pointing to the old server then I get an error. If I change the database server name and point the Physical Database Name to a copy of the schema.db on the new server I can't connect either. If I leave those pointing to the old server and only add on the SERVER_VER parm then the connection updates. But now access to Clearquest fails on the old server complaining that SERVER_VER is invalid! How are you supposed to do this?!? Step by step instructions would be great!</p>
 102
 103 <p>Even if I were to be able to get the above done I would hesitant to perform the next step because it describes using the Clearquest Maintainance Tool to <b>move</b> the schema and user databases!</p>
 104
 105 <blockquote>
 106 Move your schema repository. In the ClearQuest Maintenance Tool, in the <strong>Existing Connections</strong> area, select the connection to your existing SQL Anywhere 5.0 databases, then click <strong>Schema Repository > Move</strong>. Enter database information for a new database under your SQL Anywhere 8.0 server. For example, enter a different filename in the same directory as the existing
 107 database. Click <strong>Finish</strong>.
 108 </blockquote>
 109 <p>I don't want to <b>move</b> databases - I want to simply <b>copy</b> them. Moving them would mean that current production would have to halt until I got it back up and running on the new server.
 110                 </div>
 111                 <nav class="page-navigation entry-navigation pagination content-nav">
 112                   <ul class="page-navigation-list">
 113
 114                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2006/04/save-the-logfil.html" title="Save the logfiles! IFrames">Previous entry</a></li>
 115
 116
 117                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2006/04/build-bugs-test.html" title="Build bugs, Test suite still not runing nightly">Next entry</a></li>
 118
 119                   </ul>
 120                 </nav>
 121                 <!--
 122 <aside id="zenback" class="zenback feedback">
 123   Please paste Zenback script code here.
 124 </aside>
 125 -->
 126
 127
 128               </article>
 129             </div>
 130             <aside class="widgets related" role="complementary">
 131               <nav class="widget-search widget">
 132   <div class="widget-content">
 133     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 134       <div>
 135         <input type="text" name="search" value="" placeholder="Search...">
 136
 137         <input type="hidden" name="IncludeBlogs" value="8">
 138
 139         <input type="hidden" name="limit" value="20">
 140         <button type="submit" name="button">
 141           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 142         </button>
 143       </div>
 144     </form>
 145   </div>
 146 </nav>
 147 <nav class="widget-archive-category widget">
 148   <h3 class="widget-header">Categories</h3>
 149   <div class="widget-content">
 150
 151
 152     <ul class="widget-list">
 153
 154
 155       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 156
 157
 158       </li>
 159
 160
 161
 162
 163       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 164
 165
 166       </li>
 167
 168
 169
 170
 171       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 172
 173
 174       </li>
 175
 176
 177
 178
 179       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 180
 181
 182       </li>
 183
 184
 185
 186
 187       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 188
 189
 190       </li>
 191
 192
 193
 194
 195       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 196
 197
 198       </li>
 199
 200
 201
 202
 203       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 204
 205
 206       </li>
 207
 208
 209
 210
 211       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 212
 213
 214       </li>
 215
 216
 217
 218
 219       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 220
 221
 222       </li>
 223
 224
 225
 226
 227       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 228
 229
 230       </li>
 231
 232
 233
 234
 235       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 236
 237
 238       </li>
 239
 240
 241
 242
 243       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 244
 245
 246       </li>
 247
 248     </ul>
 249
 250
 251   </div>
 252 </nav>
 253
 254
 255 <nav class="widget-archive-dropdown widget">
 256   <h3 class="widget-header">Archives</h3>
 257   <div class="widget-content">
 258     <select>
 259       <option>Select a Month...</option>
 260
 261       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 262
 263
 264
 265       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 266
 267
 268
 269       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 270
 271
 272
 273       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 274
 275
 276
 277       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 278
 279
 280
 281       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 282
 283
 284
 285       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 286
 287
 288
 289       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 290
 291
 292
 293       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 294
 295
 296
 297       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 298
 299
 300
 301       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 302
 303
 304
 305       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 306
 307
 308
 309       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 310
 311
 312
 313       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 314
 315
 316
 317       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 318
 319
 320
 321       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 322
 323
 324
 325       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 326
 327
 328
 329       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 330
 331
 332
 333       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 334
 335
 336
 337       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 338
 339
 340
 341       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 342
 343
 344
 345       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 346
 347
 348
 349       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 350
 351
 352
 353       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 354
 355
 356
 357       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 358
 359
 360
 361       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 362
 363
 364
 365       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 366
 367
 368
 369       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 370
 371
 372
 373       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 374
 375
 376
 377       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 378
 379
 380
 381       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 382
 383
 384
 385       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 386
 387
 388
 389       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 390
 391
 392
 393       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 394
 395
 396
 397       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 398
 399
 400
 401       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 402
 403
 404
 405       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 406
 407
 408
 409       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 410
 411
 412
 413       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 414
 415
 416
 417       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 418
 419
 420
 421       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 422
 423
 424
 425       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 426
 427
 428
 429       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 430
 431
 432
 433       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 434
 435
 436
 437       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 438
 439
 440
 441       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 442
 443
 444
 445       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 446
 447
 448
 449       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 450
 451
 452
 453       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 454
 455
 456
 457       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 458
 459
 460
 461       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 462
 463
 464
 465       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 466
 467
 468
 469       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 470
 471
 472
 473       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 474
 475
 476
 477       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 478
 479
 480
 481       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 482
 483
 484
 485       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 486
 487
 488
 489       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 490
 491
 492
 493       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 494
 495
 496
 497       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 498
 499
 500
 501       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 502
 503
 504
 505       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 506
 507
 508
 509       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 510
 511
 512
 513       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 514
 515
 516
 517       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 518
 519
 520
 521       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 522
 523
 524
 525       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 526
 527
 528
 529       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 530
 531
 532
 533       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 534
 535
 536
 537       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 538
 539
 540
 541       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 542
 543
 544
 545       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 546
 547     </select>
 548   </div>
 549 </nav>
 550
 551
 552
 553 <div class="widget-syndication widget section">
 554   <div class="widget-content">
 555     <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>
 556
 557   </div>
 558 </div>
 559
 560             </aside>
 561           </div>
 562         </div>
 563         <footer id="footer" role="contentinfo">
 564           <div id="footer-inner">
 565             <div id="footer-content">
 566   <nav role="navigation">
 567           <ul>
 568             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 569
 570
 571           </ul>
 572         </nav>
 573
 574   <p class="license">&copy; Copyright 2016.</p>
 575   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 576 </div>
 577           </div>
 578         </footer>
 579       </div>
 580     </div>
 581     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 582     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 583   </body>
 584 </html>