Stack Overflow
Stack Overflow

Questions tagged [hammerdb]

HammerDB is an open source tool for Load testing and benchmarking built for Linux and Windows for databases like Oracle, SQL Server, IBM Db2, MySQL/MariaDB, PostgreSQL and Redis.

12 questions
3
votes
1 answer

HammerDB: what does 'Number of Warehouses' mean?

In HammerDB in schema building there is an option named 'Number of Warehouses'. But the meaning of this term is unclear. I mean I know what 'warehouse' IS, but I don't understand what it MEANS in context of DB creation. Could anyone explain this…
user17939629
1
vote
1 answer

Oracle XE configuring for benchmark

Have a good day. The task is to configure Oracle XE for performance benchmark using HammerDB. Well, the HammerDB script for creating schema and driver script are both done. But trying to create schema or run a benchmark Oracle XE returns me…
user17939629
0
votes
1 answer

hammerDB libmysqltcl.dll couldn't load

I installed hammerDB v4.6 on a AWS vm and I'm trying to connect to my aurora/mysql database on RDS, but when I start the schema build, I get this error Error in Virtual User 1: Error: Failed to load mysqltcl - couldn't load library…
Benoit Desrosiers
  • 183
  • 1
  • 13
0
votes
1 answer

Benchmarking postgresql in hammerDB

I'm trying to benchmark postgresql in hammerdb getting below error: Vuser 1:Checkpoint and Vacuum Error in Virtual User 1: ERROR: must be superuser to do CHECKPOINT Vuser 1:FINISHED FAILED Vuser 13:FINISHED SUCCESS Vuser 18:FINISHED SUCCESS Vuser…
user3880406
0
votes
1 answer

Checking Postgresqul library from hammerDB

We are trying to test postgresql from hammer db, getting below error when I run the librarycheck in in hammerdbcli. I'm using hammerdb version4.1 in RHEL7.9 Checking database library for PostgreSQL Error: failed to load Pgtcl - couldn't load file…
user3880406
0
votes
1 answer

Benchmarking MySQL with HammerDB

I am trying to benchmark MySQL with HammerDB using their TPROC-C benchmark. This is part of a research I'm doing where I am benchmarking MySQL and PostgreSQL. After running through all benchmarks with PostgreSQL, I started to benchmark MySQL by was…
Luis
  • 13
  • 2
0
votes
1 answer

Connecting to DB2 HammerDB

I am using a Windows Machine to connect to a remote DB2 instance. Ran into this issue SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration…
Edwin
  • 461
  • 1
  • 5
  • 14
0
votes
1 answer

HammerDB - how to do in-memory testing with mysql, TPCC mode?

I was doing TPCC testing with HammerDB 3.1 and with mysql as a backend. By looking at the resources consumption during testing, I don't think it does in-memory testing, as there is a lot of IO activity. So my question is if with mysql server it is…
user3144292
  • 402
  • 2
  • 6
  • 16
0
votes
1 answer

SQL0199N error when trying to connect HammerDB to Db2 for z/OS

I'm trying to generate some data for DB2 11.1 z/OS using HammerDB v3.1 which is running on a Windows remote host. There is no ability to run HammerDB on the same host with DB2. According to the HammerDB documentation I need to set up IBM Data Server…
Sergey Konotop
  • 121
  • 1
  • 13
0
votes
1 answer

SQL0206N error when trying to connect HammerDB to DB2 using db2dsdriver.cfg file

I'm trying to generate some data for DB2 10.5 LUW using HammerDB v3.1 which is running on a Windows remote host. There is no ability to run HammerDB on the same host with DB2. According to the HammerDB documentation I need to set up IBM Data Server…
Sergey Konotop
  • 121
  • 1
  • 13
0
votes
1 answer

extra characters after close brace

When I use hammerDB to test the Oracle 12c database TPM, sometimes I get this error， extra characters after close-brace。 I have 3000 warehouses and 100 virtual users. I only get this error sometimes, not every run. Basic information Red Hat…
han liu
  • 1
  • 1
-3
votes
1 answer

How long it takes to build schema, or my hammerDB not working?

Accoring to this link https://blog.sqlbak.com/how-to-run-sql-server-load-tests-using-hammerdb I run Schema build but it got stuck at this step for around 30 minutes already, is everything ok ?
Chau Loi
  • 1,106
  • 1
  • 14
  • 36