Home

UPDATE: The project is currently at https://bitbucket.org/openscg/benchmarksql/overview

This project is a copy of the sources form the release files of the BenchmarkSQL project.

There is not LICENSE file in the release files, however in the project's homepage in SourceForge it says the project has a license GPL v2. That means that I can modify the code, if I publish it and license it under the same terms.

There are some bugs in the released files:

• Version 2.2. There is a zip problem.
• Version 4.0.3. There are coding problem. Also, the Mac files not included.
• Version 4.0.4. There are coding problem. Also, the Mac files not included.

There is another project that takes the sources from SourceForge, however it was a short time development: https://github.com/andl/benchmarkSQL

This article explain a real test using BenchmarkSQL. You can use it in order to create your own performance test: http://www.redhat.com/pdf/rhel/bmsql-postgres-sqlsrvr-v1.0-1.pdf

This is another article where a test is explained, however it only uses Postgres: http://get.enterprisedb.com/whitepapers/White_Paper_PPAS_Updated_Performance_Benchmark.pdf

Installation

This is the installation process in order to run BenchmarkSQL in your database. You can see a working example by looking at Travis-CI (DB2 part).

First, you need to change the paths of the batch files.

• Change to the bin directory
  • cd bin
• Open the runSQL.sh file.
• In the myCP= variable, please include the location of the DB2 java driver. Then, save and close the file.
• myCP=/opt/ibm/db2/V10.5/java/db2jcc4.jar
• Open the runBenchmark.sh file.
• Include the DB2 java driver in the classpath. Put the driver after the first colon. Then, save and close the file.
• -cp .:...
• -cp .:/opt/ibm/db2/V10.5/java/db2jcc4.jar:...
• Open the runLoader.sh file.
• Perform the same task as in the previous step: include the DB2 java driver in the classpath.
• Modify the connection parameters according to your environment:
• Database name
• Hostname
• Instance port
• Connection username
• Password

Once the scripts are correctly configured, you can proceed to create the test environment.

./runSQL.sh props.db2 sqlTableCreates_DB2
./runLoader.sh props.db2 numWarehouses 1
./runSQL.sh props.db2 sqlIndexCreates_DB2
./runBenchmark.sh props.db2

If you want to check the execution, you can open the following files

• cat log/BenchmarkSQLError.log
• cat log/benchmarksql.log