Specifications

30
Principled Technologies, Inc.: Dell PowerVault MD3000i high-availability testing on
Windows Server 2008 R2 and Hyper-V
The ds2connect routine in the ds2sqlserverfns.cs module defines sConnectionString. We used the following
string; the changes we made appear in bold.
string sConnectionString = “User ID=ds2User;Initial Catalog=“+dbname+”;Max
Pool Size=200;Connection Timeout=120;Data Source=“ + Controller.target;
Recompiling the ds2sqlserverdriver.exe executable
We recompiled the ds2xdriver.cs and ds2sqlserverfns.cs module on Windows by following the instructions in the
header comments. Because the DS2 instructions were for compiling from the command line, we used the
following steps:
1. Open a command prompt.
2. Use the cd command to change to the directory containing our sources.
3. Run the batch file C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\vsvars32.bat. This sets
up the environment variables for us.
4. Execute the following command:
csc /out:ds2sqlserverdriver.exe ds2xdriver.cs ds2sqlserverfns.cs
/d:USE_WIN32_TIMER /d:GEN_PERF_CTRS
Creating a script to delete and recreate the DB2 database
We created the following script, DS2_Drop_and_Restore.sql, to delete and recreate the DB2 database between
each run:
USE [master]
GO
/****** Object: Database [test] Script Date: 10/16/2008 12:27:59 ******/
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'DS2_1')
DROP DATABASE [DS2_1]
GO
RESTORE DATABASE [DS2_1] FROM DISK = N'B:\SQLBackup\250GB_DVDStore.bak' WITH FILE
= 1,
MOVE N'primary' TO N'E:\SQLData\DS2_1.mdf', MOVE N'cust1' TO
N'E:\SQLData\DS2_1_1.ndf',
MOVE N'cust2' TO N'F:\SQLData\DS2_1_2.ndf', MOVE N'cust3' TO
N'E:\SQLData\DS2_1_3.ndf',
MOVE N'cust4' TO N'F:\SQLData\DS2_1_4.ndf', MOVE N'cust5' TO
N'E:\SQLData\DS2_1_5.ndf',
MOVE N'cust6' TO N'F:\SQLData\DS2_1_6.ndf', MOVE N'cust7' TO
N'E:\SQLData\DS2_1_7.ndf',
MOVE N'cust8' TO N'F:\SQLData\DS2_1_8.ndf', MOVE N'ind1' TO
N'E:\SQLData\DS2_1_9.ndf',
MOVE N'ind2' TO N'F:\SQLData\DS2_1_10.ndf', MOVE N'ind3' TO
N'E:\SQLData\DS2_1_11.ndf',
MOVE N'ind4' TO N'F:\SQLData\DS2_1_12.ndf', MOVE N'ind5' TO
N'E:\SQLData\DS2_1_13.ndf',
MOVE N'ind6' TO N'F:\SQLData\DS2_1_14.ndf', MOVE N'ind7' TO
N'E:\SQLData\DS2_1_15.ndf',
MOVE N'ind8' TO N'F:\SQLData\DS2_1_16.ndf', MOVE N'ds_misc1' TO
N'E:\SQLData\DS2_1_17.ndf',
MOVE N'ds_misc2' TO N'F:\SQLData\DS2_1_18.ndf', MOVE N'ds_misc3' TO
N'E:\SQLData\DS2_1_19.ndf',