db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r843115 [7/44] - in /websites/production/db/content/derby: ./ binaries/ blogs/ blogs/images/ dev/ docs/ images/ integrate/ integrate/plugin_help/ integrate/plugin_help/images/ logo/ manuals/ papers/ papers/DerbyTut/ releases/ skin/ skin/css...
Date Wed, 19 Dec 2012 18:20:28 GMT
Added: websites/production/db/content/derby/integrate/DOTS_Derby.htm
==============================================================================
--- websites/production/db/content/derby/integrate/DOTS_Derby.htm (added)
+++ websites/production/db/content/derby/integrate/DOTS_Derby.htm Wed Dec 19 18:20:21 2012
@@ -0,0 +1,5034 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to you under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<html xmlns:v="urn:schemas-microsoft-com:vml"
+xmlns:o="urn:schemas-microsoft-com:office:office"
+xmlns:w="urn:schemas-microsoft-com:office:word"
+xmlns:st1="urn:schemas-microsoft-com:office:smarttags"
+xmlns="http://www.w3.org/TR/REC-html40">
+
+<head>
+<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
+<meta name=ProgId content=Word.Document>
+<meta name=Generator content="Microsoft Word 10">
+<meta name=Originator content="Microsoft Word 10">
+<title>Overview</title>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="time"/>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="City"/>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="place"/>
+<!--[if gte mso 9]><xml>
+ <o:DocumentProperties>
+  <o:Author>IBM_User</o:Author>
+  <o:LastAuthor>IBM_User</o:LastAuthor>
+  <o:Revision>36</o:Revision>
+  <o:TotalTime>5685</o:TotalTime>
+  <o:LastPrinted>2004-09-01T18:13:00Z</o:LastPrinted>
+  <o:Created>2004-09-09T04:04:00Z</o:Created>
+  <o:LastSaved>2004-09-16T06:03:00Z</o:LastSaved>
+  <o:Pages>1</o:Pages>
+  <o:Words>5992</o:Words>
+  <o:Characters>34156</o:Characters>
+  <o:Company>IBM</o:Company>
+  <o:Lines>284</o:Lines>
+  <o:Paragraphs>80</o:Paragraphs>
+  <o:CharactersWithSpaces>40068</o:CharactersWithSpaces>
+  <o:Version>10.4219</o:Version>
+ </o:DocumentProperties>
+</xml><![endif]--><!--[if gte mso 9]><xml>
+ <w:WordDocument>
+  <w:Zoom>85</w:Zoom>
+  <w:SpellingState>Clean</w:SpellingState>
+  <w:GrammarState>Clean</w:GrammarState>
+  <w:Compatibility>
+   <w:BreakWrappedTables/>
+   <w:SnapToGridInCell/>
+   <w:ApplyBreakingRules/>
+   <w:WrapTextWithPunct/>
+   <w:UseAsianBreakRules/>
+   <w:UseFELayout/>
+  </w:Compatibility>
+  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
+ </w:WordDocument>
+</xml><![endif]--><!--[if !mso]><object
+ classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
+<style>
+st1\:*{behavior:url(#ieooui) }
+</style>
+<![endif]-->
+<style>
+<!--
+ /* Font Definitions */
+ @font-face
+	{font-family:Wingdings;
+	panose-1:5 0 0 0 0 0 0 0 0 0;
+	mso-font-charset:2;
+	mso-generic-font-family:auto;
+	mso-font-pitch:variable;
+	mso-font-signature:0 268435456 0 0 -2147483648 0;}
+@font-face
+	{font-family:SimSun;
+	panose-1:2 1 6 0 3 1 1 1 1 1;
+	mso-font-alt:\5B8B\4F53;
+	mso-font-charset:134;
+	mso-generic-font-family:auto;
+	mso-font-pitch:variable;
+	mso-font-signature:3 135135232 16 0 262145 0;}
+@font-face
+	{font-family:"\@SimSun";
+	panose-1:2 1 6 0 3 1 1 1 1 1;
+	mso-font-charset:134;
+	mso-generic-font-family:auto;
+	mso-font-pitch:variable;
+	mso-font-signature:3 135135232 16 0 262145 0;}
+ /* Style Definitions */
+ p.MsoNormal, li.MsoNormal, div.MsoNormal
+	{mso-style-parent:"";
+	margin:0in;
+	margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:12.0pt;
+	font-family:"Times New Roman";
+	mso-fareast-font-family:SimSun;}
+h1
+	{mso-style-next:Normal;
+	margin-top:12.0pt;
+	margin-right:0in;
+	margin-bottom:3.0pt;
+	margin-left:0in;
+	mso-pagination:widow-orphan;
+	mso-outline-level:1;
+	font-size:16.0pt;
+	font-family:Arial;
+	mso-font-kerning:16.0pt;}
+h2
+	{mso-style-link:"Heading 2 Char";
+	mso-style-next:Normal;
+	margin-top:12.0pt;
+	margin-right:0in;
+	margin-bottom:3.0pt;
+	margin-left:0in;
+	mso-pagination:widow-orphan;
+	mso-outline-level:2;
+	font-size:14.0pt;
+	font-family:Arial;
+	font-style:italic;}
+h3
+	{mso-style-next:Normal;
+	margin-top:12.0pt;
+	margin-right:0in;
+	margin-bottom:3.0pt;
+	margin-left:0in;
+	mso-pagination:widow-orphan;
+	mso-outline-level:3;
+	font-size:13.0pt;
+	font-family:Arial;}
+p.MsoToc1, li.MsoToc1, div.MsoToc1
+	{mso-style-update:auto;
+	mso-style-noshow:yes;
+	mso-style-next:Normal;
+	margin:0in;
+	margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:12.0pt;
+	font-family:"Times New Roman";
+	mso-fareast-font-family:SimSun;}
+p.MsoToc2, li.MsoToc2, div.MsoToc2
+	{mso-style-update:auto;
+	mso-style-noshow:yes;
+	mso-style-next:Normal;
+	margin-top:0in;
+	margin-right:0in;
+	margin-bottom:0in;
+	margin-left:12.0pt;
+	margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:12.0pt;
+	font-family:"Times New Roman";
+	mso-fareast-font-family:SimSun;}
+a:link, span.MsoHyperlink
+	{color:blue;
+	text-decoration:underline;
+	text-underline:single;}
+a:visited, span.MsoHyperlinkFollowed
+	{color:purple;
+	text-decoration:underline;
+	text-underline:single;}
+pre
+	{margin:0in;
+	margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:10.0pt;
+	font-family:"Courier New";
+	mso-fareast-font-family:SimSun;}
+span.Heading2Char
+	{mso-style-name:"Heading 2 Char";
+	mso-style-link:"Heading 2";
+	mso-ansi-font-size:14.0pt;
+	mso-bidi-font-size:14.0pt;
+	font-family:Arial;
+	mso-ascii-font-family:Arial;
+	mso-fareast-font-family:SimSun;
+	mso-hansi-font-family:Arial;
+	mso-bidi-font-family:Arial;
+	mso-ansi-language:EN-US;
+	mso-fareast-language:ZH-CN;
+	mso-bidi-language:AR-SA;
+	font-weight:bold;
+	font-style:italic;}
+span.mypathsChar
+	{mso-style-name:"mypaths Char";
+	mso-style-link:mypaths;
+	mso-ansi-font-size:12.0pt;
+	mso-bidi-font-size:12.0pt;
+	font-family:"Courier New";
+	mso-ascii-font-family:"Courier New";
+	mso-fareast-font-family:SimSun;
+	mso-hansi-font-family:"Courier New";
+	mso-bidi-font-family:"Courier New";
+	mso-ansi-language:EN-US;
+	mso-fareast-language:ZH-CN;
+	mso-bidi-language:AR-SA;}
+p.mypaths, li.mypaths, div.mypaths
+	{mso-style-name:mypaths;
+	mso-style-link:"mypaths Char";
+	margin-top:0in;
+	margin-right:0in;
+	margin-bottom:0in;
+	margin-left:.5in;
+	margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:12.0pt;
+	font-family:"Courier New";
+	mso-fareast-font-family:SimSun;
+	mso-bidi-font-family:"Times New Roman";}
+span.SpellE
+	{mso-style-name:"";
+	mso-spl-e:yes;}
+span.GramE
+	{mso-style-name:"";
+	mso-gram-e:yes;}
+@page Section1
+	{size:8.5in 11.0in;
+	margin:1.0in 1.25in 1.0in 1.25in;
+	mso-header-margin:.5in;
+	mso-footer-margin:.5in;
+	mso-paper-source:0;}
+div.Section1
+	{page:Section1;}
+ /* List Definitions */
+ @list l0
+	{mso-list-id:236332474;
+	mso-list-template-ids:386930780;}
+@list l0:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l0:level2
+	{mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l0:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l1
+	{mso-list-id:322244911;
+	mso-list-template-ids:-1089299580;}
+@list l1:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l2
+	{mso-list-id:558590366;
+	mso-list-template-ids:895648444;}
+@list l2:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l2:level2
+	{mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l2:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3
+	{mso-list-id:571425864;
+	mso-list-template-ids:-2145878936;}
+@list l3:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l3:level2
+	{mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l3:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l4
+	{mso-list-id:582642858;
+	mso-list-template-ids:-34183018;}
+@list l4:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l5
+	{mso-list-id:765925557;
+	mso-list-template-ids:76719128;}
+@list l5:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l6
+	{mso-list-id:971178979;
+	mso-list-template-ids:-1838756754;}
+@list l6:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l6:level2
+	{mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l6:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l7
+	{mso-list-id:1013409941;
+	mso-list-template-ids:-479146224;}
+@list l7:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l8
+	{mso-list-id:1430000819;
+	mso-list-template-ids:1974870462;}
+@list l8:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l8:level2
+	{mso-level-number-format:bullet;
+	mso-level-text:o;
+	mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:"Courier New";
+	mso-bidi-font-family:"Times New Roman";}
+@list l9
+	{mso-list-id:1500079732;
+	mso-list-template-ids:1480895592;}
+@list l9:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l10
+	{mso-list-id:1833371249;
+	mso-list-template-ids:-2023693618;}
+@list l10:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l10:level2
+	{mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l10:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11
+	{mso-list-id:1916670804;
+	mso-list-template-ids:1378678406;}
+@list l11:level1
+	{mso-level-number-format:bullet;
+	mso-level-text:\F0A7;
+	mso-level-tab-stop:.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:Wingdings;}
+@list l11:level2
+	{mso-level-number-format:bullet;
+	mso-level-text:o;
+	mso-level-tab-stop:1.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;
+	mso-ansi-font-size:10.0pt;
+	font-family:"Courier New";
+	mso-bidi-font-family:"Times New Roman";}
+@list l11:level3
+	{mso-level-tab-stop:1.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level4
+	{mso-level-tab-stop:2.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level5
+	{mso-level-tab-stop:2.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level6
+	{mso-level-tab-stop:3.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level7
+	{mso-level-tab-stop:3.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level8
+	{mso-level-tab-stop:4.0in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+@list l11:level9
+	{mso-level-tab-stop:4.5in;
+	mso-level-number-position:left;
+	text-indent:-.25in;}
+ol
+	{margin-bottom:0in;}
+ul
+	{margin-bottom:0in;}
+-->
+</style>
+<!--[if gte mso 10]>
+<style>
+ /* Style Definitions */
+ table.MsoNormalTable
+	{mso-style-name:"Table Normal";
+	mso-tstyle-rowband-size:0;
+	mso-tstyle-colband-size:0;
+	mso-style-noshow:yes;
+	mso-style-parent:"";
+	mso-padding-alt:0in 5.4pt 0in 5.4pt;
+	mso-para-margin:0in;
+	mso-para-margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:10.0pt;
+	font-family:"Times New Roman";}
+table.MsoTableGrid
+	{mso-style-name:"Table Grid";
+	mso-tstyle-rowband-size:0;
+	mso-tstyle-colband-size:0;
+	border:solid windowtext 1.0pt;
+	mso-border-alt:solid windowtext .5pt;
+	mso-padding-alt:0in 5.4pt 0in 5.4pt;
+	mso-border-insideh:.5pt solid windowtext;
+	mso-border-insidev:.5pt solid windowtext;
+	mso-para-margin:0in;
+	mso-para-margin-bottom:.0001pt;
+	mso-pagination:widow-orphan;
+	font-size:10.0pt;
+	font-family:"Times New Roman";}
+</style>
+<![endif]--><!--[if gte mso 9]><xml>
+ <o:shapedefaults v:ext="edit" spidmax="12290"/>
+</xml><![endif]--><!--[if gte mso 9]><xml>
+ <o:shapelayout v:ext="edit">
+  <o:idmap v:ext="edit" data="1"/>
+ </o:shapelayout></xml><![endif]-->
+</head>
+
+<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
+
+<div class=Section1>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><span
+style='mso-tab-count:1'>        </span><a name="_Toc83045852"></a><a
+name="_Toc81809515"></a><a name="_Toc81803661"><span style='mso-bookmark:_Toc81809515'><span
+style='mso-bookmark:_Toc83045852'><span style='font-size:12.0pt'>Running DOTS
+(Database Open Source Test Suite) with </span></span></span></a><st1:City><st1:place><span
+  style='mso-bookmark:_Toc83045852'><span style='mso-bookmark:_Toc81809515'><span
+  style='mso-bookmark:_Toc81803661'><span style='font-size:12.0pt'>Derby</span></span></span></span></st1:place></st1:City><span
+style='font-size:12.0pt'> <o:p></o:p></span></h1>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><span
+style='mso-tab-count:4'>                                                </span>Sunitha
+Kambhampati <span class=GramE>( skambha@Yngvi.Org</span>)</p>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81809516"></a><a name="_Toc81803662"></a><a name="_Toc83045853"><span
+style='mso-bookmark:_Toc81803662'><span style='mso-bookmark:_Toc81809516'>Preface:</span></span></a></h1>
+
+<p class=MsoNormal>I ran DOTS (Database Open Source Test Suite) with <st1:City><st1:place>Derby</st1:place></st1:City>
+as the underlying database. The setup was simple and it seems like this test
+suite can be used for testing on Linux.<span style='mso-spacerun:yes'> 
+</span>This document talks about how I went about trying to setup DOTS with <st1:City><st1:place>Derby</st1:place></st1:City>.<span
+style='mso-spacerun:yes'>  </span>I hope this will be of some help to the
+community. Please feel free to add your suggestions/ modifications to this
+document.<span style='mso-spacerun:yes'>  </span>Thanks. </p>
+
+<h1><o:p>&nbsp;</o:p></h1>
+
+<h1><a name="_Toc83045854">Table of Contents</a></h1>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><a name="_Toc81803663"><o:p>&nbsp;</o:p></a></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-begin'></span><span style='mso-bookmark:_Toc81803663'><span
+style='mso-spacerun:yes'> </span>TOC \o &quot;1-3&quot; \h \z \u <span
+style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><a href="#_Toc83045855"><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'>1.
+Introduction</span></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045855 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>1</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800350035000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045856"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>2. Environment</span></span><span style='mso-bookmark:
+_Toc81803663'><span style='color:windowtext;display:none;mso-hide:screen;
+mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045856 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>2</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800350036000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045857"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>2.1 Software Requirements</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045857 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>2</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800350037000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045858"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>2.2 The test environment that was used in this study:</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045858 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>2</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800350038000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045859"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>3. Overview of DOTS and test configurations with Derby</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045859 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>3</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800350039000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045860"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4. Steps to setup and run Dots:</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045860 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>3</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360030000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045861"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.1. Installation of DOTS</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045861 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>3</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360031000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045862"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.2. Database (Derby) related setup</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045862 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>4</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360032000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045863"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.3. Start the database server</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045863 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>5</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360033000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045864"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.4. Configuring test run parameters for DOTS client</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'> PAGEREF
+_Toc83045864 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>6</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360034000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045865"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.5. Running the benchmark</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045865 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>7</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360035000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045866"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.6. Checking the output and investigating possible
+problems</span></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045866 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>8</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360036000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045867"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>4.7. Cleaning up</span></span><span style='mso-bookmark:
+_Toc81803663'><span style='color:windowtext;display:none;mso-hide:screen;
+mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045867 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>8</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360037000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045868"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>5. Test Results with Derby</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045868 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>9</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360038000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045869"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>6. Summary</span></span><span style='mso-bookmark:
+_Toc81803663'><span style='color:windowtext;display:none;mso-hide:screen;
+mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045869 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>9</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800360039000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045870"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>7. External Links</span></span><span style='mso-bookmark:
+_Toc81803663'><span style='color:windowtext;display:none;mso-hide:screen;
+mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045870 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>10</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800370030000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045871"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>APPENDIX A: derbydotsscripts.tar.gz contents</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045871 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>10</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800370031000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045872"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>APPENDIX B: Sample result file with Derby</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'>. </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045872 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>11</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800370032000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045873"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>APPENDIX C:<span style='mso-spacerun:yes'> 
+</span>derby.ini</span></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045873 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>16</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800370033000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span style='mso-bookmark:
+_Toc81803663'></span><a href="#_Toc83045874"><span style='mso-bookmark:_Toc81803663'><span
+style='mso-no-proof:yes'>APPENDIX D: derbyNS.ini</span></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'><span
+style='mso-tab-count:1 dotted'> </span></span></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-begin'></span><span
+style='mso-bookmark:_Toc81803663'><span style='color:windowtext;display:none;
+mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:none'>
+PAGEREF _Toc83045874 \h </span><span style='mso-element:field-separator'></span></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'><span
+style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
+text-decoration:none;text-underline:none'>18</span><!--[if gte mso 9]><xml>
+ <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000D0000005F0054006F006300380033003000340035003800370034000000</w:data>
+</xml><![endif]--></span><!--[if supportFields]><span style='mso-bookmark:_Toc81803663'></span><span
+style='mso-element:field-end'></span><![endif]--><span style='mso-bookmark:
+_Toc81803663'></span><span style='mso-bookmark:_Toc81803663'></span></a><span
+style='mso-bookmark:_Toc81803663'><span style='mso-no-proof:yes'><o:p></o:p></span></span></p>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><span
+style='mso-bookmark:_Toc81803663'></span><!--[if supportFields]><span
+style='mso-bookmark:_Toc81803663'></span><span style='mso-element:field-end'></span><![endif]--><span
+style='mso-bookmark:_Toc81803663'><a name="_Toc83045855">1. Introduction</a></span></h1>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal>Database Opensource Test Suite (DOTS) is an open source test
+suite that is used to stress test database systems and to measure database
+reliability (<a href="http://ltp.sourceforge.net/dotshowto.php#SEC1">http://ltp.sourceforge.net/dotshowto.php#SEC1</a>
+. <span class=GramE>DOTS is</span> licensed under GNU General Public License
+(GPL).<span style='mso-spacerun:yes'>  </span>The test cases are in Java and
+make JDBC calls to the database. They are aimed to test 100% JDBC API
+coverage.<span style='mso-spacerun:yes'>   </span>There are two kinds of test
+cases, basic and advanced. There are 8 basic tests prefixed with BTCJ and 2
+advanced tests prefixed by ATCJ.<span style='mso-spacerun:yes'>  </span>The
+advanced test cases simulate real world workloads including user
+authentication/registration scenario and an online auction scenario. </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal><st1:City><st1:place>Derby</st1:place></st1:City> is an
+Apache DB subproject. <st1:City><st1:place>Derby</st1:place></st1:City>
+is a standards based java relational database system<span class=GramE>.(</span><a
+href="http://db.apache.org/derby/">http://db.apache.org/derby/</a>).
+Some main features of derby are it is embedded, has small footprint, <span
+class=GramE>is</span> pure java, easy to use and secure. </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal>The aim of this document is to help setup DOTS to run with <st1:City><st1:place>Derby</st1:place></st1:City>.<span
+style='mso-spacerun:yes'>  </span>The following link <a
+href="http://ltp.sourceforge.net/dotshowto.php#SEC1">http://ltp.sourceforge.net/dotshowto.php#SEC1</a>
+at the DOTS site provides a good overview of the architectural components of
+the test suite as well as the schema details.</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>This
+document basically does a walkthrough of a setup/ run of DOTS with <st1:City><st1:place>Derby</st1:place></st1:City>
+as the database.<span style='mso-spacerun:yes'>  </span>There are some scripts
+that are given with the hope that it will aid in reducing your setup time. </p>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81803664"></a><a name="_Toc83045856"><span style='mso-bookmark:_Toc81803664'>2.
+Environment</span></a></h1>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>This
+section talks about the hardware and software needed to run DOTS. In
+sub-section 2.1, the requirement as stated by DOTS is given.<span
+style='mso-spacerun:yes'>  </span>Sub-section 2.2 lists the actual test
+environment used. </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81803665"></a><a name="_Toc83045857"><span style='mso-bookmark:_Toc81803665'><span
+class=Heading2Char><span style='font-size:14.0pt'>2.1 Software Requirements</span></span></span></a>:</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Database:
+<st1:City><st1:place>Derby</st1:place></st1:City> (derby jars: derby.jar,
+derbynet.jar and derbytools.jar and if using network server, also need the <span
+class=SpellE>drda</span> client – db2jcc.jar and db2jcc_license_c.jar)</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>OS:
+Linux 2.4.4</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>JVM:
+J2SE1.3.1 or higher</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Hardware
+Requirements:</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>CPU:
+<span class=GramE>700Mhz</span> or higher</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Memory:
+512Mb or higher</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Disk
+Capacity: 2 GB or higher</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<h2 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81803666"></a><a name="_Toc83045858"><span style='mso-bookmark:_Toc81803666'>2.2
+The test environment that was used in this study:</span></a></h2>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Test
+machine:</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0
+ style='margin-left:.5in;background:#F3F3F3;border-collapse:collapse;
+ border:none;mso-border-alt:solid windowtext .5pt;mso-padding-alt:0in 5.4pt 0in 5.4pt;
+ mso-border-insideh:.5pt solid windowtext;mso-border-insidev:.5pt solid windowtext'>
+ <tr style='mso-yfti-irow:0'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>OS Name<o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border:solid windowtext 1.0pt;
+  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
+  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><span
+  class=SpellE><i style='mso-bidi-font-style:normal'>Suse</i></span><i
+  style='mso-bidi-font-style:normal'> Linux <o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:1'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>Version<span style='mso-tab-count:1'>            </span><o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>9.0<o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:2'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>System Manufacturer<o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>IBM<o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:3'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>System Model<span style='mso-tab-count:
+  1'>  </span><o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>86473FX<o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:4'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>System Type<span style='mso-tab-count:
+  1'>    </span><o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>X86-based PC<o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:5'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>Processor<span style='mso-tab-count:1'>        </span><o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>x86 Family 15 Model 2 Stepping 7 <span
+  class=SpellE>GenuineIntel</span> ~2400 <span class=SpellE>Mhz</span><o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:6'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>Processor <o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>x86 Family 15 Model 2 Stepping 7 <span
+  class=SpellE>GenuineIntel</span> ~2400 <span class=SpellE>Mhz</span> <o:p></o:p></i></p>
+  </td>
+ </tr>
+ <tr style='mso-yfti-irow:7;mso-yfti-lastrow:yes'>
+  <td width=115 valign=top style='width:1.2in;border:solid windowtext 1.0pt;
+  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
+  padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>Memory<o:p></o:p></i></p>
+  </td>
+  <td width=427 valign=top style='width:4.45in;border-top:none;border-left:
+  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
+  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
+  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
+  <p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><i
+  style='mso-bidi-font-style:normal'>4Gb<o:p></o:p></i></p>
+  </td>
+ </tr>
+</table>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Software
+Used:</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+text-indent:.5in'><st1:City><st1:place>Derby</st1:place></st1:City> jars – </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+text-indent:.5in'><span style='mso-spacerun:yes'>   </span>Instructions to
+build derby jars and downloads are at</p>
+
+<pre style='text-align:justify;text-justify:inter-ideograph'><span style='mso-spacerun:yes'>  </span><span
+style='mso-tab-count:1'>      </span><a
+href="http://db.apache.org/derby/derby_downloads.html">http://db.apache.org/derby/derby_downloads.html</a></pre>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><span
+style='mso-tab-count:1'>            </span>Java -</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><span
+style='mso-tab-count:1'>            </span>Java 1.4.2</p>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc83045859"></a><a name="_Toc81803667"><span style='mso-bookmark:_Toc83045859'>3.
+Overview of DOTS and test configurations with </span></a><st1:City><st1:place><span
+  style='mso-bookmark:_Toc83045859'><span style='mso-bookmark:_Toc81803667'>Derby</span></span></st1:place></st1:City></h1>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>A high
+level overview of the main components of DOTS is as follows </p>
+
+<ul style='margin-top:0in' type=square>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l10 level1 lfo3;tab-stops:list .5in'>There is the database system
+     that DOTS is run against. </li>
+</ul>
+
+<ul style='margin-top:0in' type=square>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l6 level1 lfo6;tab-stops:list .5in'>DOTS client that drives the
+     test run </li>
+</ul>
+
+<ul style='margin-top:0in' type=square>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l3 level1 lfo9;tab-stops:list .5in'>There is a performance
+     monitor that runs on the same machine as the database and communicates with
+     the DOTS client via sockets passing information about the CPU usage and
+     other performance related attributes. </li>
+</ul>
+
+<p class=MsoNormal style='margin-left:.25in;text-align:justify;text-justify:
+inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.25in;text-align:justify;text-justify:
+inter-ideograph'>DOTS can be run in two modes:</p>
+
+<ul style='margin-top:0in' type=square>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l2 level1 lfo12;tab-stops:list .5in'>DOTS client on one machine,
+     and the database server on another machine </li>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l2 level1 lfo12;tab-stops:list .5in'>DOTS client and database
+     server on the same machine. </li>
+</ul>
+
+<p class=MsoNormal style='margin-left:.25in;text-align:justify;text-justify:
+inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.25in;text-align:justify;text-justify:
+inter-ideograph'><st1:City><st1:place>Derby</st1:place></st1:City> with DOTS
+can run in two modes</p>
+
+<ul style='margin-top:0in' type=square>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l11 level1 lfo15;tab-stops:list .5in'><st1:City><st1:place>Derby</st1:place></st1:City>
+     in embedded mode runs as part of the DOTS client (<span class=SpellE>ie</span>
+     in the same JVM as the DOTS client). Hence the only possible configuration
+     would be DOTS client and embedded database as well as the performance
+     monitor program on one machine. </li>
+ <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+     mso-list:l11 level1 lfo15;tab-stops:list .5in'><st1:City><st1:place>Derby</st1:place></st1:City>
+     in client –server mode (Network Server).<span style='mso-spacerun:yes'> 
+     </span>If you use Derby Network Server, then the possible configurations
+     are </li>
+ <ul style='margin-top:0in' type=circle>
+  <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+      mso-list:l11 level2 lfo15;tab-stops:list 1.0in'>Database server and
+      performance monitor on one machine and the DOTS client on another machine
+      </li>
+  <li class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+      mso-list:l11 level2 lfo15;tab-stops:list 1.0in'>Database server,
+      performance monitor and DOTS client on one machine. </li>
+ </ul>
+</ul>
+
+<h1 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81803668"></a><a name="_Toc83045860"><span style='mso-bookmark:_Toc81803668'>4.
+Steps to setup and run Dots:</span></a></h1>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>In
+the example described here:<span style='mso-spacerun:yes'>  </span>the
+database, DOTS client and the performance monitor are all on one machine.<span
+style='mso-spacerun:yes'>  </span>If you decide to have the DOTS client and
+database server on different machines, the steps will be some what similar
+except that you will have to ensure that the necessary jars are present on the
+client and the database server machines. </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>The
+sections 3.1 and 3.2 of the Database Opensource Test Suite User’s Guide provide
+excellent overview. Section 3.1 (<a
+href="http://ltp.sourceforge.net/dotshowto.php#SEC11">http://ltp.sourceforge.net/dotshowto.php#SEC11</a>)
+and </p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph'>Section
+3.2 (<a href="http://ltp.sourceforge.net/dotshowto.php#SEC12">http://ltp.sourceforge.net/dotshowto.php#SEC12</a>)</p>
+
+<h2 style='text-align:justify;text-justify:inter-ideograph'><a
+name="_Toc81803669"></a><a name="_Toc83045861"><span style='mso-bookmark:_Toc81803669'>4.1.
+Installation of DOTS</span></a></h2>
+
+<pre style='margin-left:.5in;text-align:justify;text-justify:inter-ideograph;
+text-indent:-.25in'><span style='font-size:12.0pt;font-family:"Times New Roman";
+mso-fareast-font-family:"Times New Roman"'>1)</span><span style='font-size:
+7.0pt;font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Download the DOTS 1.1.1 (Dots-1.1.1.gz) from here <a
+href="http://sourceforge.net/project/showfiles.php?group_id=3382">http://sourceforge.net/project/showfiles.php?group_id=3382</a><span
+style='font-size:12.0pt;font-family:"Times New Roman"'><o:p></o:p></span></pre>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>Unzip
+the <span class=SpellE>gz</span> file </p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>$
+tar <span class=SpellE>zxvf</span> Dots-1.1.1.gz</p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>After
+this, there will be a Dots directory with different sub directories with source
+of the tests, scripts, make file etc. </p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>In
+this example, Dots has been installed at /home/perftest/Dots. Let $DOTS_ROOT
+refer to your dots installation. Here it will be /home/perftest/Dots. </p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<pre style='margin-left:.5in;text-align:justify;text-justify:inter-ideograph;
+text-indent:-.25in'><span style='font-size:12.0pt;font-family:"Times New Roman";
+mso-fareast-font-family:"Times New Roman"'>2)</span><span style='font-size:
+7.0pt;font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span
+style='font-size:12.0pt;font-family:"Times New Roman"'>Make sure that java is installed, else install it and set the path variable to include <span
+class=SpellE>jvm</span>. <o:p></o:p></span></pre>
+
+<p class=MsoNormal style='margin-left:.25in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;text-indent:-.25in;tab-stops:list .5in'><span style='mso-fareast-font-family:
+"Times New Roman"'>3)</span><span style='font-size:7.0pt;mso-fareast-font-family:
+"Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Compiling the DOTS
+source</p>
+
+<p class=MsoNormal style='margin-left:.75in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>Change
+directory to your Dots installation</p>
+
+<p class=MsoNormal style='margin-left:1.25in;text-align:justify;text-justify:
+inter-ideograph;text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=SpellE><span class=GramE><span style='font-size:10.0pt;font-family:"Courier New"'>cd</span></span></span><span
+style='font-size:10.0pt;font-family:"Courier New"'> /home/<span class=SpellE>perftest</span>/Dots/<o:p></o:p></span></p>
+
+<p class=MsoNormal style='margin-left:57.0pt;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>Before
+running the make command, make sure that you have javac in your path. </p>
+
+<p class=mypaths style='margin-left:1.0in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.5in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:10.0pt'>make</span></span><span
+style='font-size:10.0pt'> all <o:p></o:p></span></p>
+
+<p class=MsoNormal style='margin-left:1.0in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>This
+will compile all the source java files in the <span class=SpellE>src</span>
+subdirectory of your DOTS installation. If this is successful, you will see no
+errors during the make, and there will be two jars under $DOTS_ROOT:<span
+style='mso-spacerun:yes'>  </span><span class=SpellE>PerfMon.jar</span> and the
+<span class=SpellE>Dots.jar</span> </p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.75in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=SpellE>PerfMon.jar</span> – This jar file contains the classes necessary
+to start the performance monitor client. This jar is required to run
+performance monitor.</p>
+
+<p class=MsoNormal style='margin-left:.5in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:.75in;text-align:justify;text-justify:
+inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=SpellE>Dots.jar</span> – This jar file has all the test cases that are
+needed to run tests.<span style='mso-spacerun:yes'>  </span>Also contains the
+DOTS client component needed to drive the test runs. </p>
+
+<h2 style='text-align:justify;text-justify:inter-ideograph;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><a
+name="_Toc83045862"></a><a name="_Toc81803670"><span style='mso-bookmark:_Toc83045862'>4.2.
+Database (</span></a><st1:City><st1:place><span style='mso-bookmark:_Toc83045862'><span
+  style='mso-bookmark:_Toc81803670'>Derby</span></span></st1:place></st1:City><span
+style='mso-bookmark:_Toc83045862'><span style='mso-bookmark:_Toc81803670'>)
+related setup</span></span></h2>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>The
+database related setup involves setting up the necessary database jar files,
+creating the database and loading the schema. For both <st1:City><st1:place>Derby</st1:place></st1:City>
+(embedded or client-server mode), the <span class=SpellE>ij</span> tool that is
+in derbytools.jar is used for creation of database and loading of schema.</p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>There
+is a <span class=SpellE>derbydotsscripts.tar.gz</span> file along with this
+document that has the scripts and sql files necessary for derby. For more
+details on each of the scripts present in the derbydotsscripts.tar.gz file, please
+see APPENDIX A.<span style='mso-spacerun:yes'>  </span>To help reduce the setup
+time, these scripts can be easily modified according to your individual setup.
+Unzip the derbydotsscripts.tar.gz into a directory called derby and execute the
+scripts from the same directory. Modify the myenv.ksh to set the
+DERBY_JARS_ROOT as well as the DOTS_JARS_ROOT environment variables
+appropriately. DERBY_JARS_ROOT refers to the root directory where the derby
+jars are located and DOTS_JARS_ROOT refers to the root directory where the DOTS
+related jars are located. Below, for each step the corresponding script that
+can be used is given enclosed in brackets. In case you are using the scripts,
+make sure that you have first run myenv.ksh or set the DERBY_JARS_ROOT and
+DOTS_JARS_ROOT variables in the shell window that you are executing from<span
+style='font-size:9.0pt;font-family:"Courier New";mso-bidi-font-family:"Times New Roman"'>.
+($. <span class=GramE>./</span>myenv.ksh)<o:p></o:p></span></p>
+
+<p class=MsoNormal style='text-align:justify;text-justify:inter-ideograph;
+tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:27.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:-.25in;tab-stops:list 27.0pt 1.25in'><span
+style='font-family:Wingdings;mso-fareast-font-family:Wingdings;mso-bidi-font-family:
+Wingdings'>§ </span><span style='mso-fareast-font-family:Wingdings'>Open a new shell
+window and if you are using the scripts, set DERBY_JARS_ROOT and DOTS_JARS_ROOT
+appropriately<o:p></o:p></span></p>
+
+<p class=mypaths style='text-align:justify;text-justify:inter-ideograph;
+tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'>($. <span class=GramE>./</span>myenv.ksh)<o:p></o:p></span></p>
+
+<p class=MsoNormal style='margin-left:27.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:-.25in;tab-stops:list 27.0pt 1.25in'><span
+style='mso-fareast-font-family:Wingdings'><o:p>&nbsp;</o:p></span></p>
+
+<p class=MsoNormal style='margin-left:27.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:-.25in;tab-stops:list 27.0pt 1.25in'><span
+style='font-family:Wingdings;mso-fareast-font-family:Wingdings;mso-bidi-font-family:
+Wingdings'>§</span><span style='font-size:7.0pt;mso-fareast-font-family:Wingdings'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+</span>Obtain derby jars – derby.jar, <span class=GramE>derbytools.jar<span
+style='mso-spacerun:yes'>  </span>(</span> for embedded mode)</p>
+
+<p class=MsoNormal style='margin-left:9.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>For
+network server mode, also need derbynet.jar</p>
+
+<p class=MsoNormal style='margin-left:9.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'>Set
+classpath to derby jars. </p>
+
+<p class=MsoNormal style='margin-left:9.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:9.0pt'>export</span></span><span
+style='font-size:9.0pt'> DERBY_JARS=&quot;/home/perftest/derby&quot;<o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:9.0pt'>export</span></span><span
+style='font-size:9.0pt'> CLASSPATH=&quot;$DERBY_JARS/<span class=SpellE>derby.jar:$DERBY_JARS/derbytools.jar</span>&quot;<o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'><o:p>&nbsp;</o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:9.0pt'>or</span></span><span
+style='font-size:9.0pt'> <o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'><o:p>&nbsp;</o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'>($. <span class=GramE>./</span><span class=SpellE>cpderby.ksh</span>
+)<o:p></o:p></span></p>
+
+<p class=MsoNormal style='margin-left:9.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><o:p>&nbsp;</o:p></p>
+
+<p class=MsoNormal style='margin-left:27.0pt;text-align:justify;text-justify:
+inter-ideograph;text-indent:-.25in;tab-stops:list 27.0pt 1.25in'><span
+style='font-family:Wingdings;mso-fareast-font-family:Wingdings;mso-bidi-font-family:
+Wingdings'>§</span><span style='font-size:7.0pt;mso-fareast-font-family:Wingdings'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+</span>Ensure JVM is in your path. </p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:9.0pt'>export</span></span><span
+style='font-size:9.0pt'>
+PATH=&quot;/home/perftest/jdk1.4.2_04/bin:${PATH}&quot;<o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'><o:p>&nbsp;</o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+class=GramE><span style='font-size:9.0pt'>or</span></span><span
+style='font-size:9.0pt'><o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'><o:p>&nbsp;</o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;
+text-indent:.25in;tab-stops:list .5in left 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt'><span
+style='font-size:9.0pt'>($. <span class=GramE>./</span><span class=SpellE>jvm.ksh</span>)<o:p></o:p></span></p>
+
+<p class=mypaths style='margin-left:.25in;text-align:justify;text-justify:inter-ideograph;

[... 3415 lines stripped ...]


Mime
View raw message