defaria.com/blogs/Status/2006/04/sql-anywhere.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=" Attempted to migrate Clearquest databases to new server. I was unable to. I've opened up a PMR with IBM Rational #8552849R and expect to get email from them tomorrow. Attempting to switch the machine adefaria over to this newly...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>SQL Anywhere - 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/sql-anywhere.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/new-registry-se.html" title="New Registry Server">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2006/04/save-the-logfil.html" title="Save the logfiles! IFrames">
  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="SQL Anywhere">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2006/04/sql-anywhere.html">
  26     <meta property="og:description" content=" Attempted to migrate Clearquest databases to new server. I was unable to. I've opened up a PMR with IBM Rational #8552849R and expect to get email from them tomorrow. Attempting to switch the machine adefaria over to this newly...">
  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=" Attempted to migrate Clearquest databases to new server. I was unable to. I've opened up a PMR with IBM Rational #8552849R and expect to get email from them tomorrow. Attempting to switch the machine adefaria over to this newly...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2006/04/sql-anywhere.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">SQL Anywhere</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1799" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">SQL Anywhere</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-09T19:07:50-08:00" itemprop="datePublished">April  9, 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>Attempted to migrate Clearquest databases to new server. I was unable to. I've opened up a PMR with IBM Rational #8552849R and expect to get email from them tomorrow.</li>
  86
  87   <li>Attempting to switch the machine adefaria over to this newly created registry server (sons-sc-cc). Decided to reboot the machine. It never came back up! If you can boot this machine that would be great. You might need to go into the Clearcase Control Panel and set the registry server back to sons-clearcase and set the region to US. It might require a reboot to be effective. Why, when I rebooted it, it failed to come back up?</li>
  88 </ul>
  89
  90 <p><b>Time Spent:</b> 4 hours</p>
  91                   <h2>Migrating databases to new SQLAnywhere 8.x</h2>
  92
  93 <p>Spent most of the day banging against SQL Anywhere. We need to migrate the databases (both the schema.db and the salira_bugs.db) to the new server. With the new server comes new DBMS software (Sorry but SQL Anywhere 5.5.05 which is what you have on sons-clearcase is being sunsetted anyway).</p>
  94
  95 <p>Now I've done some extensive Clearquest work over at <a href="http://defaria.com/blogs/Status/archives/cat_pqa.html">Broadcom</a> it was all MS SQL based in the back end.</p>
  96
  97 <p>The first problem I have is that there is not service for SQL Anywhere like there used to be over on sons-clearcase. I managed to find C:\Program Files\Rational\SQLAnywhere8\win32\dbeng8.exe and dbsrv8.exe and that appears to be the process to start, there still isn't any automatically starting service for SQL Anywhere 8. That plus when run it prompts with a dialog box that queries about the database to use. I was always under the impression that a DBMS server just runs for any and all databases on the machine. I can just specify the server and leave the database blank but other times when running Sybase Central it complains that it can't start the DB server.</p>
  98
  99 <p>I thought that I could simply use Sybase Central to backup the databases on sons-clearcase then use the restore function of Sybase Central on sons-sc-cc. There are also options like Migrate Database, etc. to deal with differences in databases between old and new versions of SQL Anywhere. All of these had problems for me...</p>
 100
 101 <h2>Backup/Restore</h2>
 102
 103 <p>I backed up the salira_bugs.db file over to \\sons-sc-cc\Clearquest\backup\salira_bugs.db. Next I attempted to restore it on sons-sc-cc I get "Unable to start database server".</p>
 104
 105 <h2>Connect to backup database</h2>
 106
 107 <p>When I attempt to simply connect to that db I get:</p>
 108
 109 <blockquote>
 110   <p>You are attempting to connect to a version 5.5.03 database running on a version 8.0.2-3601 server. In order for the Sybase Central to use this database, the database must be unloaded and reloaded into a new database (Sybase Central only supports version 7.0.0 and later database). The Unload Database wizard can step you through this process, after which Sybase Central will diconnect from this database.</p>
 111
 112   <p>Do you want to unload and reload this database? (If not, Sybase Central will disconnect from this database now.)</p>
 113 </blockquote>
 114
 115 <p>If I step through this wizard I eventually get:</p>
 116
 117 <div class=code><pre>
 118 java.lang.UnsatisfiedLinkError: unloadDatabase
 119 Could not unload the database 'salira_bugs'.
 120 </pre></div>
 121
 122 <h2>Migrate Database</h2>
 123
 124 <p>If I attempt to Migrate Database I get a message saying "You must be connected to the database to which you want to migrate" which, of course, I can't...</p>
 125
 126 <h2>Creating and Erase Database</h2>
 127
 128 <p>I have not managed to create a database through Sybase Central (but I have been able to create it through Clearquest Maintainance Tool and the Clearquest Designer - see below). When I try I get: Unable to start database server.</p>
 129
 130 <p>For databases created via Clearquest tools I cannot erase them using Erase database. Instead I get the same thing: Unable to start database server. So far when I need to delete a database I merely remove the databse files themselves.</p>
 131
 132 <p>I can create a schema database and even user databases through the Clearcase Maintainance Tool and Clearquest Designer respectively. But we don't want a new schema nor empty user databases - we want to migrate the old scheme that has our modifications and we want to migrate our old database!</p>
 133
 134 <h2>Moving Databases</h2>
 135
 136 <p>There's also an option to move a database from one server to another. Now I don't want to move databases right yet - I want to copy them. However this move seems to copy the database and then lock the original database. So I tried it out on the test2 database. Effectively you go into the Clearquest Designer on sons-clearcase and then select Database: Move Database then go through the dialog box specifying that you want to move the database over to sons-sc-cc. That works and test2.db does appear over on sons-sc-cc. But when I attempt to connect to it Sybase Central again goes through the unload/load procedure which fails the same way as described above.</p>
 137                 </div>
 138                 <nav class="page-navigation entry-navigation pagination content-nav">
 139                   <ul class="page-navigation-list">
 140
 141                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2006/04/new-registry-se.html" title="New Registry Server">Previous entry</a></li>
 142
 143
 144                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2006/04/save-the-logfil.html" title="Save the logfiles! IFrames">Next entry</a></li>
 145
 146                   </ul>
 147                 </nav>
 148                 <!--
 149 <aside id="zenback" class="zenback feedback">
 150   Please paste Zenback script code here.
 151 </aside>
 152 -->
 153
 154
 155               </article>
 156             </div>
 157             <aside class="widgets related" role="complementary">
 158               <nav class="widget-search widget">
 159   <div class="widget-content">
 160     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 161       <div>
 162         <input type="text" name="search" value="" placeholder="Search...">
 163
 164         <input type="hidden" name="IncludeBlogs" value="8">
 165
 166         <input type="hidden" name="limit" value="20">
 167         <button type="submit" name="button">
 168           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 169         </button>
 170       </div>
 171     </form>
 172   </div>
 173 </nav>
 174 <nav class="widget-archive-category widget">
 175   <h3 class="widget-header">Categories</h3>
 176   <div class="widget-content">
 177
 178
 179     <ul class="widget-list">
 180
 181
 182       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 183
 184
 185       </li>
 186
 187
 188
 189
 190       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 191
 192
 193       </li>
 194
 195
 196
 197
 198       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 199
 200
 201       </li>
 202
 203
 204
 205
 206       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 207
 208
 209       </li>
 210
 211
 212
 213
 214       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 215
 216
 217       </li>
 218
 219
 220
 221
 222       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 223
 224
 225       </li>
 226
 227
 228
 229
 230       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 231
 232
 233       </li>
 234
 235
 236
 237
 238       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 239
 240
 241       </li>
 242
 243
 244
 245
 246       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 247
 248
 249       </li>
 250
 251
 252
 253
 254       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 255
 256
 257       </li>
 258
 259
 260
 261
 262       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 263
 264
 265       </li>
 266
 267
 268
 269
 270       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 271
 272
 273       </li>
 274
 275     </ul>
 276
 277
 278   </div>
 279 </nav>
 280
 281
 282 <nav class="widget-archive-dropdown widget">
 283   <h3 class="widget-header">Archives</h3>
 284   <div class="widget-content">
 285     <select>
 286       <option>Select a Month...</option>
 287
 288       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 289
 290
 291
 292       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 293
 294
 295
 296       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 297
 298
 299
 300       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 301
 302
 303
 304       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 305
 306
 307
 308       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 309
 310
 311
 312       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 313
 314
 315
 316       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 317
 318
 319
 320       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 321
 322
 323
 324       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 561
 562
 563
 564       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 565
 566
 567
 568       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 569
 570
 571
 572       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 573
 574     </select>
 575   </div>
 576 </nav>
 577
 578
 579
 580 <div class="widget-syndication widget section">
 581   <div class="widget-content">
 582     <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>
 583
 584   </div>
 585 </div>
 586
 587             </aside>
 588           </div>
 589         </div>
 590         <footer id="footer" role="contentinfo">
 591           <div id="footer-inner">
 592             <div id="footer-content">
 593   <nav role="navigation">
 594           <ul>
 595             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 596
 597
 598           </ul>
 599         </nav>
 600
 601   <p class="license">&copy; Copyright 2016.</p>
 602   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 603 </div>
 604           </div>
 605         </footer>
 606       </div>
 607     </div>
 608     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 609     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 610   </body>
 611 </html>