defaria.com/blogs/Status/archives/2004_06.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
  11
  12    <title>Status for Andrew DeFaria: June 2004 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/2004_05.html" title="May 2004" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/2004_07.html" title="July 2004" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/2004_05.html">&laquo; May 2004</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/2004_07.html">July 2004 &raquo;</a>
  38                      </p>
  39
  40
  41
  42
  43                      <h2 class="date-header">June 25, 2004</h2>
  44                      <a id="a000205"></a>
  45                      <div class="entry" id="entry-205">
  46                         <h3 class="entry-header">Finished backup script</h3>
  47                         <div class="entry-content">
  48                            <div class="entry-body">
  49                               <p>The backup script is ready for deployment. It was determined to lock all vobs at once, back them all up then unlock the vobs. I also implemented the 7 days of history option. History is stored under d:\vobstore\backup as numbered directories (0-6 for Sun-Sat). The script now manages that area by first moving the current backup under d:\backup -> d:\vobstore\backup\<current day #> after first clearing out d:\vobstore\backup\<current day #> (if it existed). It was decided to put the history stuff under vobstore because this way we can tell the backup people "Just exclude d:\vobstore but get everything else".</p>
  50
  51 <p>I was experiencing "Access denied" errors irradically until I found out that there may be .being-deleted files as described <a href="http://www-1.ibm.com/support/docview.wss?rs=0&q1=being-deleted&uid=swg21129318&loc=en_US&cs=utf-8&cc=us&lang=en">here</a>. To solve this I implemented exclusions on the xcopy command (/exclude:d:\backup\exclude.strings) which tells xcopy to exclude things in the "c" directory - i.e. the cleartext pool - which Clearcase can easily recreate without data loss. This also has the effect of reducing the backup copy size in some cases significantly (e.g. \ASAP_Docs goes from 2.1 gig down to 1 gig!).</p>
  52
  53 <p>Here's a rough psuedo code of what the script does:</p>
  54
  55 <div id="code">
  56 <pre>
  57 Obtain a list of all vobs
  58 Lock all vobs
  59 foreach @vobs
  60   if d:\vobstore\backup\$current_day\$vob exists then
  61     remove it
  62   end if
  63   move d:\backup\$vob -> d:\vobstore\backup\$current_day\$vob
  64   copy $vob's storage area -> d:\backup\$vob
  65 Next
  66 Unlock all vobs
  67 </pre>
  68 </div>
  69 <p>Cutting out the copying of cleartext pool has reduced the current backup time from 56 minutes (yes it grew) to 33 minutes.</p>
  70
  71 <p>Now, where are we WRT the SQL backup scripts?....</p>
  72
  73                               <p class="entry-footer">
  74                                  <span class="post-footers">Posted by  at  3:37 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000205.html">Permalink</a>
  75
  76
  77                               </p>
  78                            </div>
  79                         </div>
  80                      </div>
  81
  82
  83
  84                      <h2 class="date-header">June 23, 2004</h2>
  85                      <a id="a000202"></a>
  86                      <div class="entry" id="entry-202">
  87                         <h3 class="entry-header">Multisite/backup.pl</h3>
  88                         <div class="entry-content">
  89                            <div class="entry-body">
  90                               <p>Spent some time trying to multisite a test vob (\defaria). Realized that we will have a problem in that we will need a machine (server or client) dedicated to handling the multisite region in order to lock vobs and backup things.</p>
  91
  92 <p>Had a meeting WRT multisite approach. It was determined that will we switch to using a script to make a copy of the vobs and back up from there. Started writing script...</p>
  93
  94                               <p class="entry-footer">
  95                                  <span class="post-footers">Posted by  at  9:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000202.html">Permalink</a>
  96
  97
  98                               </p>
  99                            </div>
 100                         </div>
 101                      </div>
 102
 103
 104
 105                      <h2 class="date-header">June 21, 2004</h2>
 106                      <a id="a000204"></a>
 107                      <div class="entry" id="entry-204">
 108                         <h3 class="entry-header">XML</h3>
 109                         <div class="entry-content">
 110                            <div class="entry-body">
 111                               <p>Spent most of the day investigating XML and XSL.</p>
 112
 113                               <p class="entry-footer">
 114                                  <span class="post-footers">Posted by  at  9:29 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000204.html">Permalink</a>
 115
 116
 117                               </p>
 118                            </div>
 119                         </div>
 120                      </div>
 121
 122
 123
 124                      <h2 class="date-header">June 18, 2004</h2>
 125                      <a id="a000201"></a>
 126                      <div class="entry" id="entry-201">
 127                         <h3 class="entry-header">XML</h3>
 128                         <div class="entry-content">
 129                            <div class="entry-body">
 130                               <ul>
 131
 132 <li>Spent most of the day studying XML</li>
 133
 134 <li>Added debugging code to LogActivity trigger</li>
 135
 136 <li>Worked on problem Sujay's people had with 0 length document</li>
 137
 138 </ul>
 139
 140                               <p class="entry-footer">
 141                                  <span class="post-footers">Posted by  at  1:55 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000201.html">Permalink</a>
 142
 143
 144                               </p>
 145                            </div>
 146                         </div>
 147                      </div>
 148
 149
 150
 151                      <h2 class="date-header">June 16, 2004</h2>
 152                      <a id="a000199"></a>
 153                      <div class="entry" id="entry-199">
 154                         <h3 class="entry-header">AD/CC Registry</h3>
 155                         <div class="entry-content">
 156                            <div class="entry-body">
 157                               <ul>
 158
 159 <li>Activated reporting of Active Directory groups</li>
 160
 161 <li>Cleaned up Clearcase Registry</li>
 162
 163 </ul>
 164
 165                               <p class="entry-footer">
 166                                  <span class="post-footers">Posted by  at  2:17 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000199.html">Permalink</a>
 167
 168
 169                               </p>
 170                            </div>
 171                         </div>
 172                      </div>
 173
 174
 175
 176                      <h2 class="date-header">June 15, 2004</h2>
 177                      <a id="a000200"></a>
 178                      <div class="entry" id="entry-200">
 179                         <h3 class="entry-header">BUCS/VOB Snapshots/RequistePro</h3>
 180                         <div class="entry-content">
 181                            <div class="entry-body">
 182                               <ul>
 183
 184 <li>More working with Babu re: BUC$ build script</li>
 185
 186 <li>Investigated and prototyped vob_snapshot backups</li>
 187
 188 <li>Incorporated Requisite Pro into a FAQ web page</li>
 189
 190 </ul>
 191
 192                               <p class="entry-footer">
 193                                  <span class="post-footers">Posted by  at  2:21 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000200.html">Permalink</a>
 194
 195
 196                               </p>
 197                            </div>
 198                         </div>
 199                      </div>
 200
 201
 202
 203
 204                      <a id="a000198"></a>
 205                      <div class="entry" id="entry-198">
 206                         <h3 class="entry-header">Clearcase Web Server</h3>
 207                         <div class="entry-content">
 208                            <div class="entry-body">
 209                               <p>The Clearcase web service died today. I don't know why but the following is what I did to get it back up and running. </p>
 210
 211 <p>Server is back up.</p>
 212
 213 <p>Problem analysis:</p>
 214
 215 <p>Not really sure where things went wrong however when I looked at it the Rational Web Platform (rwp - which is really just Apache with Tomcat under the hood) was not running. rwp creates error logs but they are hard to parse because there are many of them with apparently random numbers tacked on. I believe these numbers represent the date in some form but haven't figured out how to decode them.</p>
 216
 217 <p>Anyway, I tried moving them aside and to restart the rwp server so that it would be clear what the error file was. Couldn't move all the log files out of the way because some were busy. Wish I had a good tool to figure out who has a file open.</p>
 218
 219 <p>The error message when trying to start rwp was "The Rational Web Platform HTTP Service Terminated with Service-Specific Error 1". Searching the Rational Support site yielded that the reason the service could not start was because some other process was using port 80. Typically this is due to somebody else runnig IIS. No IIS running. Tried netstat but could not find who was using port 80. Tried telneting to port 80 and got "Connection failed" so whoever was using port 80 did not want to talk to me! :-)</p>
 220
 221 <p>Finally I tried running rwp.exe from the command line with --help hoping for help about rwp's possible command line opts. Instead rwp started and ran! Clearcase web was back up but I did not like having rwp running in a console window and if I were to log out I feared that the rwp process would end. So I went to the Services applet and tried to start (since there was no stop) rwp. It started and the rwp running in the console ended. For safety's sake I restarted the rwp service through the Services applet. I believe Clearcase web is OK for now and we are doign server maintainance tonight anyway...<br />
 222 </p>
 223
 224                               <p class="entry-footer">
 225                                  <span class="post-footers">Posted by  at 10:44 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000198.html">Permalink</a>
 226
 227
 228                               </p>
 229                            </div>
 230                         </div>
 231                      </div>
 232
 233
 234
 235                      <h2 class="date-header">June  9, 2004</h2>
 236                      <a id="a000197"></a>
 237                      <div class="entry" id="entry-197">
 238                         <h3 class="entry-header">PB/ASAP VOB Moves</h3>
 239                         <div class="entry-content">
 240                            <div class="entry-body">
 241                               <ul>
 242
 243 <li>Joined PowerBuilder newsgroup to try to find out how to solve the Orca Script problems. Looks like I'm gonna learn way more about PB than I wanted to</li>
 244
 245 <li>Tested moving PVOB and Src vob from vobstore to ASAP_VOBS. Works OK.</li>
 246
 247 <li>Learned that we can use the DOS command MOVE which moves the VOBs simply by manipulating the directory entries. This means moving a large vob takes no longer than a small vobs. This is probably possible because we are on the same filesystem</li>
 248
 249 <li>WRT these ASAP vobs, we need to <tt>ct find -all -exec "cleartool protect -chown &lt;owner&gt; %CLEARCASE_PN%"</tt></li>
 250
 251 </ul>
 252
 253
 254                               <p class="entry-footer">
 255                                  <span class="post-footers">Posted by  at  7:08 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000197.html">Permalink</a>
 256
 257
 258                               </p>
 259                            </div>
 260                         </div>
 261                      </div>
 262
 263
 264
 265                      <h2 class="date-header">June  8, 2004</h2>
 266                      <a id="a000196"></a>
 267                      <div class="entry" id="entry-196">
 268                         <h3 class="entry-header">ActiveState Perl</h3>
 269                         <div class="entry-content">
 270                            <div class="entry-body">
 271                               <ul>
 272
 273 <li>Spent most of the day installing a Networked ActiveState Perl. Had permission problems with making elements in my dynamic view! Don't know why? Tried a clearfsimport and that caused the Perl to fail. I think it didn't properly copy permissions. So I ended up having to <b>Add to Source Control</b> all the files by hand (since I don't have scripting tools)</li>
 274
 275 <li>Consulted with Subba about ASAP VOB Move test</li>
 276
 277 <li>Babu gave me an assignment to learn <i>OrcaScript</i> which is a scripting language for PowerBuidlder. Oh boy!</li>
 278
 279 </ul>
 280
 281                               <p class="entry-footer">
 282                                  <span class="post-footers">Posted by  at  7:07 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000196.html">Permalink</a>
 283
 284
 285                               </p>
 286                            </div>
 287                         </div>
 288                      </div>
 289
 290
 291
 292                      <h2 class="date-header">June  4, 2004</h2>
 293                      <a id="a000195"></a>
 294                      <div class="entry" id="entry-195">
 295                         <h3 class="entry-header">AD Groups</h3>
 296                         <div class="entry-content">
 297                            <div class="entry-body">
 298                               <p>Worked on getccgroups.vbs most of the day. Managed to get it to recurse for groups within groups and to sort the arrays of names. Need to implement the email portion though.</p>
 299
 300                               <p class="entry-footer">
 301                                  <span class="post-footers">Posted by  at  5:43 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000195.html">Permalink</a>
 302
 303
 304                               </p>
 305                            </div>
 306                         </div>
 307                      </div>
 308
 309
 310
 311                      <h2 class="date-header">June  3, 2004</h2>
 312                      <a id="a000194"></a>
 313                      <div class="entry" id="entry-194">
 314                         <h3 class="entry-header">More meetings</h3>
 315                         <div class="entry-content">
 316                            <div class="entry-body">
 317                               <ul>
 318
 319 <li>Yet even more meetings</li>
 320
 321 <li>Documented installation scripts. Fixed them to dynamically mktag for \ccverify</li>
 322
 323 <li>Helped Rick Cunneen with VOB questions</li>
 324
 325 </ul>
 326
 327                               <p class="entry-footer">
 328                                  <span class="post-footers">Posted by  at  7:23 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000194.html">Permalink</a>
 329
 330
 331                               </p>
 332                            </div>
 333                         </div>
 334                      </div>
 335
 336
 337
 338                      <h2 class="date-header">June  2, 2004</h2>
 339                      <a id="a000193"></a>
 340                      <div class="entry" id="entry-193">
 341                         <h3 class="entry-header">Meetings, Bloody Meetings</h3>
 342                         <div class="entry-content">
 343                            <div class="entry-body">
 344                               <ul>
 345
 346 <li>Attended several (3) meetings today so not much got done</li>
 347
 348 <li>Fixed some minor problems with verification scripts</li>
 349
 350 </ul>
 351
 352                               <p class="entry-footer">
 353                                  <span class="post-footers">Posted by  at  7:10 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000193.html">Permalink</a>
 354
 355
 356                               </p>
 357                            </div>
 358                         </div>
 359                      </div>
 360
 361
 362
 363                      <h2 class="date-header">June  1, 2004</h2>
 364                      <a id="a000192"></a>
 365                      <div class="entry" id="entry-192">
 366                         <h3 class="entry-header">CMVerify</h3>
 367                         <div class="entry-content">
 368                            <div class="entry-body">
 369                               <ul>
 370
 371 <li>Worked mostly on [cm|cc|cq]verify scripts. Got them checked in as working</li>
 372
 373 <li>Worked a little bit on the GetCCGroups vbs scripts</li>
 374
 375 </ul>
 376
 377                               <p class="entry-footer">
 378                                  <span class="post-footers">Posted by  at  7:34 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000192.html">Permalink</a>
 379
 380
 381                               </p>
 382                            </div>
 383                         </div>
 384                      </div>
 385
 386                   </div>
 387                </div>
 388             </div>
 389          </div>
 390       </div>
 391    </div>
 392 </body>
 393 </html>