Activity for HammerDB
-
HammerDB released /readme.txt
-
Prathyusha modified a comment on discussion Open Discussion
Hi Steve, Thanks for the response. Can you please assist me with the issue: https://github.com/TPC-Council/HammerDB/issues/154 Thanks & Best Regards, Prathyusha
-
-
Hi Steve, Thanks for the response. Please assist me with the issue: https://github.com/TPC-Council/HammerDB/issues/154 Thanks & Best Regards, Prathyusha
-
Hi Steve, Thanks for the response. Please assist me with the issue: https://github.com/TPC-Council/HammerDB/issues/154 Thanks & Best Regards, Prathyusha
-
Steve Shaw posted a comment on discussion Open Discussion
Hi, THe HammerDB project has moved, you need to post support questions here https://github.com/TPC-Council/HammerDB/issues to receive assistance.
-
As note before: The HammerDB project has moved to gitHub and HammerDB support can be found here https://github.com/TPC-Council/HammerDB/issues You need to post questions on https://github.com/TPC-Council/HammerDB/issues to receive assistance
-
Hi , Facing this error : loading history file ... 0 events added Main console display active (Tcl8.6.9 / Tk8.6.9) The xml is well-formed, applying configuration Error in Virtual User 1: [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved. Reason code: "3". Details: DB2 version: 11.5.4.0 driver: go driver (tried with ODBC driver as well, facing the same issue) env vars: export DB2HOME=/home/user/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver export CGO_CFLAGS=-I$DB2HOME/include export...
-
Hi , Facing this error : loading history file ... 0 events added Main console display active (Tcl8.6.9 / Tk8.6.9) The xml is well-formed, applying configuration Error in Virtual User 1: [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved. Reason code: "3". Details: DB2 version: 11.5.4.0 driver: go driver (tried with ODBC driver as well, facing the same issue) env vars: export DB2HOME=/home/user/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver export CGO_CFLAGS=-I$DB2HOME/include export...
-
Roja modified a comment on discussion Open Discussion
These are the details i am using to create schema and run the test
-
These are the details i am using to create schema and run the test
-
The HammerDB project has moved to gitHub and HammerDB support can be found here https://github.com/TPC-Council/HammerDB/issues You will need to provide a lot more detail on what you are doing to create the schema and run the test.
-
1
-
did 7 TPM and and 0 NOPM issue is solved?please let me now how it is solve .I am also using oracle aws RDS 19.0 enterprise edition .Please help me with this
-
Hi, I am using HammerDB to do some automated TPCC performance testing of Oracle database engine instance is created on AWS RDS. The performance tests end up with around 7 TPM and and 0 NOPM. Let me know what is causing the issue.Thanks in advance
-
I am using HammerDB to do some automated TPCC performance testing of Oracle database engine instance is created on AWS RDS. The performance tests end up with around 7 TPM and and 0 NOPM. Let me now what is causing the issue
-
HammerDB support can be found here https://github.com/TPC-Council/HammerDB/issues
-
I am new to hammerDB using version 3.3 .While schema build for oracle got the abve error .Please help me with this Thanks
-
While schema build for oracle got the obve error .Please help me with this Thanks
-
While schema build for oracle got the obve error
-
Sagy Volkov posted a comment on discussion Open Discussion
Thanks Steve. I've opened an issue in github. Thx. On Thu, Sep 17, 2020 at 1:32 AM Steve Shaw smshaw@users.sourceforge.net wrote: Hi, The HammerDB project has moved to GitHub so the support site for question is here: https://github.com/TPC-Council/HammerDB/issues If you repost here then that is the best way to get answers and also maintain a long-term record of support information. Thanks, Steve counter of failed queries https://sourceforge.net/p/hammerdb/discussion/292312/thread/6a585659c4/?limit=25#458a...
-
Hi, The HammerDB project has moved to GitHub so the support site for question is here: https://github.com/TPC-Council/HammerDB/issues If you repost here then that is the best way to get answers and also maintain a long-term record of support information. Thanks, Steve
-
Hi, I'm testing hammerdb on SQL server using some SDS (Software Define Storage). I'm doing some resiliency tests for the SDS while running hammerdb (like pullint out a drive or shutting down a node). These actions should create some kind of a period of time where IOs can not complete (for example, if the SDS lost a node, it has to update its metadata so all clients will know where to get another copy of the data), so I'm pretty sure some queries failed or maybe were retried (not that much of an expert...
-
Sreejith modified a comment on discussion Open Discussion
Thanks Steve. I am using the superuser credentials ( postgres ) user
-
Thanks Steve. I am using the superuser credentials ( posgres ) user
-
Hi, HammerDB support has moved here https://github.com/TPC-Council/HammerDB/issues. You will need to provide more details on the username and passwords you are trying to use especially if the '@' symbol is used. HammerDB does not use ODBC it uses the C interface. Steve
-
Hi Team, I am a first time user of HammerDB. Trying to run benchmark for Postgres Enterprise DB using HammerDB(Version 3.2) in Windows server 2019. Odbc test connection has been succesful . Hammerdb is throwing error Error in Virtual User 1: ERROR: syntax error at or near "@" while trying to build schema. Any help to resolve this is appreciated. Regards, Sree
-
Hi Team, I am a first time user of HammerDB. Trying to run benchmark for Postgres Enterprise DB using HammerDB in Windows server 2019. Odbc test connection has been succesful . Hammerdb is throwing error Error in Virtual User 1: ERROR: syntax error at or near "@" while trying to build schema. Any help to resolve this is appreciated. Regards, Sree
-
Vikram, Yes this is expected. The best way to think of the default Master/Slave mode is with Oracle RAC. One database with multiple instances - so the Master does the timing and the Slaves run against their target instances. It is not configured for the Master to gather all the Slave results. (However this is a good suggestion for a future enhancement). If you have done the Mater Distribution you need to check the script for the line: set mode "Local" ;# HammerDB operational mode If you have distributed...
-
Vikram Umachagi posted a comment on discussion Help
Hi Steve, Thanks for response. Sure i will create account and post queries on github forum. For my setup here is the following : 2 VMs each configured with a single instance Oracle 19c database with a TPCC schema . Both VMs are clones hence the oracle SID etc is similar for both VMs. Both VMs are created on different storage inculding their datbase. Once i setup the tnsnames.ora and listner.ora with load balance enabled. If i just invoke a HammerDB GUI (local mode) in client host and start test in...
-
Hi, HammerDB has moved here and will get a quicker response as it has more visibility https://github.com/TPC-Council/HammerDB. But to give a quick answer -what you are doing is very typical. By default the Oracle environment for Master/Slave is more focused to RAC so only the Master retrieves results - however if you want all of the Slaves to report in the EDITABLE OPTIONS section set "mode" to "Local" and then it will also run the monitor virtual user to time the test and capture results. Steve
-
Hi, When we have 2 VMs configured for Oracle Single Instance database and we want to execute the HammerDB TPC-C benchmark from a single Client (Master) HammerDB to get the aggregate result from all slaves. How should we set up the HammerDB environment?
-
Alan Cranfield posted a comment on discussion Help
Thanks for the quick response, Steve. I will update our my testing and reporting accordingly. I'm glad to have found the root cause. In fact I recall this being mentioned to me a while ago and I didn't pay attention! And I'll be sure to switch over to GitHub.. Alan
-
Hi, HammerDB support has moved to Github Issues - however clearly there is a strong preference for the sourceforge support forum instead of GitHub and to provide a quick response I will answer this here. So yes the change in TPM is intentional for SQL Server from 3.2 to 3.3. As background there was a bug raised for the previous ODBC v1 interface tclodbc https://github.com/TPC-Council/HammerDB/issues/72 - the fix to this was to move to a newer ODBCv3 interface tdbc::odbc. The previous interface essentially...
-
I am using TPCC HammerDB version 3.3 on a windows client (Driver 17) with SQL server 2019. I am seeing much lower TPM reported for version 3.3 than on the previous version 3.2. I'm using a TPCC 1000 warehouse workload and the exact same settings on each client. I had been checking all settings in hardware and storage trying to find the performance difference from previous runs until I noticed that the HammerDB versions were different. Any ideas why? e.g. 55 users I get 503,646 TPM on version 3.3...
-
Ronak J Patel posted a comment on discussion Help
thx but can some one help i have posted this on github
-
Hi, hammerDB has moved from sourceforge to GitHub - the Issues forum is here for support questions https://github.com/TPC-Council/HammerDB/issues
-
Hi, hammerDB has moved from sourceforge to GitHub - the Issues forum is here for support questions https://github.com/TPC-Council/HammerDB/issues
-
i am trying to run benchmark test for SQL 2019 on linux , i have creaed schema and nwo when i try to run virtual user or automated scritp i am keep getting error and only 1 user run the test. Error in Virtual User 6: can't use empty string as operand of "+" below is the build script. SQL is installed on linux and i am runnig test from widows machine connected to linux. !/usr/local/bin/tclsh8.6 EDITABLE OPTIONS global allwarehouses myposition totalvirtualusers set library tdbc::odbc ;# SQL Server...
-
i am running benchmark test setup as below. SQL server is on linux machine. runnig hammerdb on Windows server as master. i am able to build tpcc database, one its completed when i run virtual user, users tats failing with error Error in Virtual User 2: Connection to DRIVER=ODBC Driver 17 for SQL Server;SERVER=tcp:16001;UID=test;PWD=test could not be established : can't create object "odbc": command already exists with that name. in virtual user i have used 4 virtual user. not sure what am i doing...
-
Hi, hammerDB has moved from sourceforge to GitHub - the Issues forum is here for support questions https://github.com/TPC-Council/HammerDB/issues
-
Matthew modified a comment on discussion Open Discussion
Test Environment 1. Oracle 12c R2 RAC 2. Two nodes 3. HannmerDB 3.3 4. 2 centos clients working in Master and Slave mode Questions 1. Does hammerdb support to automatically aggregate TPM on master node from slave ? 2. Do I need select "RAC global transactions" on Transactions Options? I found the TPM will be double compared with if not selected "RAC global transactions" on Transactions Options Thanks, Matthew
-
Test Environment 1. Oracle 12c R2 RAC 2. Two nodes 3. HannmerDB 3.3 4. 2 centos clients working in Master and Slave mode Questions 1. Does hammerdb support to automatically aggregate TPM on master node from slave ? 2. Do I need select "RAC global transactions" on Transactions Options? I found the TPM will be double compared with if not selected "RAC global transactions" on Transactions Options
-
sravan posted a comment on discussion Help
Thanks Steve, created an issue there.
-
Hi, hammerDB has moved from sourceforge to GitHub - the Issues forum is here for support questions https://github.com/TPC-Council/HammerDB/issues
-
Hi, We are seeing different performance numbers when the user has db_owner vs when the user is the owner of the database. This seems to be specific to hammerdb load. We are seeing ~35 - 40% performance drop. Does this have to do with hammerdb? Is this expected? Looks like it is taking more time to process each wait event when the user has db_owner privs. This is reproducable. I created 50 warehouses with 160 vusers. Thanks.
-
Hi, hammerDB has moved from sourceforge to GitHub - so the Issues forum is here https://github.com/TPC-Council/HammerDB/issues - it would be good feedback if GitHub issues doesn't seem as usable for this sort of discussion topic to try and reach a better solution for HammerDB questions. but to give a quick answer - So there are a couple of things to check. Firstly HammerDB selects the TPM from the AWR repository if its standard edition then this will not enabled more information is here https://sourceforge.net/p/hammerdb/discussion/292313/thread/84dc50002c/....
-
David posted a comment on discussion Help
Ok.. so apparently there is a switch.... diset tpcc ora_driver timed. I'm getting results now... unfortunately I'm getting 0 TPM and a value for NOPM: Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 0 Oracle TPM at 6139 NOPM Vuser 1:FINISHED SUCCESS Any ideas why?
-
Hey, so I am running the latest hammerdb build 3.3 on Oracle Linux 7.6 and a 19c Oracle database using CLI. However, for the life of mine I am not able to make CLI display the TPM or any reults: $ ./hammerdbcli auto autorun_hammerdb2.tcl HammerDB CLI v3.3 Copyright (C) 2003-2019 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration SETTING CONFIGURATION Database set to Oracle Value inconso01 for connection:system_password is the same as existing value inconso01,...
-
Jack posted a comment on discussion Help
Thanks, Steve. Will do.
-
HammerDB has moved to GitHub https://github.com/TPC-Council/HammerDB and is no longer supported on sourceforge. Please open an issue on https://github.com/TPC-Council/HammerDB/issues to ask questions
-
Hi, I'm running Hammedbcli on Postgres and hammerdb setup looks as below. Both running buildschema and vurun complete with out reporting any issue but the test results are not shown on the console or in the hammerdb.log file. Not sure why? Any advice ? dbset db pg dbset bm TPC-C diset connection pg_host localhost diset connection pg_port 5432 diset tpcc pg_superuser postgres diset tpcc pg_superuserpass postgres diset tpcc pg_user tpcc diset tpcc pg_pass tpcc diset tpcc pg_dbase tpcc diset tpcc pg_total_iterations...
-
Hi, HammerDB has moved to GitHub https://github.com/TPC-Council/HammerDB and is no longer supported on sourceforge. This issue and the current status is here https://github.com/TPC-Council/HammerDB/issues/19. the most recent update is the current status (ie hardware availability) If you wish to add to this issue please do so on GitHub Thanks, Steve
-
Sumit Sengupta posted a comment on discussion Open Discussion
Hello Steve, reviving this thread. I came across your tool and heard a lot of good things about this. However I have the same problem with the font. And im my windows ( surface2, 3240x2160 resolution ) and hammerdb 3.3 version, I do not see the components directory or the hdb_ed.tcl file. However I do see some files in "C:\Program Files\HammerDB-3.3\lib\tk8.6" directory but not sure which ones to tweak. Can you probvide some guidance ? Many thanks ! ( BTW the link on wiki is broken.
-
Anju modified a comment on discussion Help
thanks Steve, can you point me to the new site ? I have tried the command posted in the above blog. it worked when I called like below: ./hammercli auto test.tcl thanks!
-
thanks Steve, can you point me to the new site ? I have tried the command posted in the above blog before I created a sqlrun.tcl file as below: !/bin/tclsh dbset db mssqls dbset bm TPC-C diset connection mssqls_server sql-sl-sq diset connection mssqls_authentication sql diset connection mssqls_uid sa diset connection mssqls_pass SQlare15! diset tpcc mssqls_total_iterations 1000000 loadscript vuset vu 4 vuset iterations 1000 vuset logtotemp 1 vucreate vurun vwait forever then, I created a bat file...
-
thanks Steve, can you point me to the new site ? I have tried the command posted in the above blog before I created a sqlrun.tcl file as below: !/bin/tclsh dbset db mssqls dbset bm TPC-C diset connection mssqls_server sql-sl-sq diset connection mssqls_authentication sql diset connection mssqls_uid sa diset connection mssqls_pass SQlare15! diset tpcc mssqls_total_iterations 1000000 loadscript vuset vu 4 vuset iterations 1000 vuset logtotemp 1 vucreate vurun vwait forever then, I created a bat file...
-
Please note that HammerDB has moved and questions should be posted on the new site. Reference for your question. https://www.hammerdb.com/blog/uncategorized/automating-cli-tests-on-windows/
-
I wanted to run a bat file, which should start the hammerdbcli and run a tcl script. I tried different options available in hammerdb documentation, but did not work. Can anyone know whether I can do this ? I use Hammerdb3.3
-
HammerDB has moved to GitHub. Please raise issues there. When doing so please give full information so you can be helped such as the database you are testing. Also give details on the database statistics that are captured during the run that can account for the variation.
-
Diogo posted a comment on discussion Help
I'm also experiencing throughput (TPM) variations up to 20% when testing HammerDB using autopilot, with a database installed at a virtual machine. Could this variation be expected when using a virtualized environment?
-
HammerDB has now moved here https://github.com/TPC-Council/HammerDB please use GitHub Issues on this project for support requests.
-
K Viswanath posted a comment on discussion Help
Hi Steve, We are working on to setup the HammerDB for MariaDB OpenSource Database . But we don't see the diset commands, does HammerDB supports for MariaDB database . Please confirm how can we setup MariaDB manually and also please provide the steps . Thanks, Viswanath. K
-
Home
-
Many thanks for the update, For the specific configuration on workload balancing getting help from Db2 experts using PureScale would be the best approach. Steve
-
Hi, For tuning it is best that you go to the sites for the relevant database experts. For example this is a very good link for Db2 https://datageek.blog/about/. Also the HammerDB blog can give you some recent examples for PostgreSQL - nevertheless there is not going to be an absolute configuration that is suitable for every different environment, instead think of HammerDB as a tool to find this configuration for your particular setup. Steve
-
db2cli posted a comment on discussion Help
Hi, thanks for your answer. I've added the configuration for reconnecting and workload balancing in the db2dsdriver.cfg before, but it doesn't work. I now used four different Db2 clients where each connects first to another member and run HammerDB with it.
-
Hi Steve, Thank you so much . Now, I am able to see the TPM count and NOPM. I ran the script for schema build from command prompt by using 4 VU's and 300 warehouses. But ,for schema build it took 6+ hours.After Schema build ,ran the setup and load test script by using 4 VU’s with 300 warehouses and 1000000 transactions, it took 27 minutes. Please suggest how many VU's can give with 300 warehouses while schema build and load test for better performance. We are working on benchmark testing for databases...
-
Hi, I have not actually tested pureScale however I would think that for questions 1 & 2 the configuration for load balancing would be in the db2dsdriver.cfg or db2cli.ini rather than on the HammerDB side https://www.ibm.com/developerworks/community/blogs/IMSupport/entry/DB2_pureScale_Workload_Balancing_setup_made_simple?lang=en - nevertheless if someone knows better then this can be suggested as a feature enhancement. Unfortunately The master/slave configuration that can be used in the GUI is not...
-
I wanted to use HammerDB for Benchmarking our pureScale environment with four Db2 Members. I use the CLI. I started with 4 virtual users with a simple test without changing the configurations. By taking a look to the database, I was surprised. The complete workload was just on one of these members. So I shutdown this member and HammerDB gives a failure. A new start of HammerDB brings the complete workload to the second member. Is there a possibility to manage the connections to all members? Is there...
-
Thats great many thanks for the update. Its really appreciated taking the time to add a solution to an issue as this can help other people experiencing the same. I for one did not know of this connection time threshold. Also just as an FYI there is a post here on optimizing PostgreSQL performance https://www.hammerdb.com/blog/uncategorized/how-to-maximize-cpu-performance-for-postgresql-12-0-benchmarks-on-linux/ the grpah shows the level of NOPM PostgreSQL can reach until it is limitied by lock c...
-
Pete posted a comment on discussion Help
The issue was with a timeout setting. I was able to run tests up to 59 minutes, but once I crossed the 60 minute threshold, the connections were terminated. I've modified that parameter, so the load tests are able to complete normally. Thanks again for your help.
-
Hi, As noted before, everything is running the same SQL query so is selecting the same data. The code for transaction counter is in the file src/mssqlserver/mssqlsotc.tcl and you can print the variable "outc" to see the data that the transaction counter is using. Also as noted I couldn't replicate the issue and therefore cannot help to debug if it cannot be reproduced. (This is not to say there may not be an issue - just that it cannot be reproduced). HammerDB is in the process of moving to GitHub...
-
Bhakti Hinduja posted a comment on discussion Open Discussion
Hi Steve. This is useful. I was able to validate the result shown by HammerDB using select cntr_value from sys.dm_os_performance_counters where counter_name = 'Batch Requests/sec' But the Tx counter value still seems different. How can i get intermediate values to print a nice graph for the run? The Tx counter matches the SQL Server statistics perfmon counter. Can you help debug this more? I can setup a meeting to discuss more. Thanks!
-
GEOMEAN is a standard function in any spreadsheet - so if you put the query times in a spreadsheet then you should be able to highlight them all and select GEOMEAN Steve
-
sanjay posted a comment on discussion Open Discussion
Steve, Thank you very much. Issue resolved after setting the scale factor in the driver script to the same value as the schema build. I need one more help regarding How to calculate grometric mean ? Please provide the details... Regards Sanjay
-
Steve, Thanks for quick reply. I did a mistake in setting the scale factor in the driver script to the same value as the schema build. The scale factor set to 1 where as the scale factor for the schema build is 300. Currently importing the tpch schema from export dump and will extecute the power test with refresh function and will set the correct scale factor as 300 . Update you soon. Regards Sanjay
-
The refresh function will only work once per schema creation so make sure that if you want to use the refresh you backup and restore the tables being refreshed each also. Also make sure that you set the scale factor in the driver script to the same value as the schema build.
-
Hi Steve , I am working on TPC-H workload on Oracle 19c database for the first time. Created a new database with Scale factor of 300 and executed the power test as per the HammerDB documentation. The driver output file is attached. Select the refresh function TRUE and executed the workload with one virtual user. As soon as the test begins, getting ORA-02291 error continuously. Hammerdb Log @ Sun Oct 13 05:09:34 EDT 2019 +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Timestamp 1 @ Sun Oct 13 05:10:33...
-
OK, This is an issue I can't replicate but I'll explain exactly what it is doing to help troubleshooting in your configuration. So the SQL Statement being used for both the transaction counter and the TPM value in the driver script is identical as follows: select cntr_value from sys.dm_os_performance_counters where counter_name = 'Batch Requests/sec' You can run this in SSMS as well to verifiy. The transaction counter samples this value over (by default) a 10 second interval and extrapolates the...
-
Hi, The documentation has been moved online to here https://www.hammerdb.com/docs/ch10.html. The previous documentation was for version 2 and is no longer relevant. The spreadsheet and information on calculating the QphH was removed as requested by the TPC. Steve
-
Hi Steve, I need to run DSS workload on Oracle 19c database. Request to provide the link to download "hammerdb_oracle_dss.pdf" file as this document explains prerequisites and running power tests and throughput tests. Regards Sanjay
-
Hello I am using TPCC HammerDB 3.2 on a windows client (Driver 17) with SQL server 2017. I am seeing different values reported by HammerDB results in virtual user output(5.5M) but the Tx counter reports a different TPM (3.3M). The delta between the two values is huge. I also veriffied the counter batch requests/sec from SQL Statistics in Perfmon, it matches the value of the Tx counter. In this case what is the correct TPM for my test? Thank you
-
My suggestion would be to run the test for an hour and then try running the query (and other queries) manually at the same time or near to the same time as HammerDB to see if it completes. It is possible that for example the connection is hanging for internal/admin overhead related to database space and then timesout. There is an example of some of the connection configuration parameters here https://www.hammerdb.com/docs/ch04s02.html Steve
-
Thanks for your response. I changed the test duration from 60 minutes to 15 minutes, and the test completed successfully. Prior to that, I ran the SELECT query as the tpcc user, and it returned results. Does this give you any clues as to what's happening? I didn't see anything in the error logs that indicated why the server closed the connection. Meanwhile, I will try a 60 minute test and update this thread with the results.
-
To troubleshoot - HammerDB is running the following SQL. Therefore you will need to login with the same account and run this SQL to see if it returns the correct data: select sum(xact_commit + xact_rollback) from pg_stat_database Also try running for a shorter timescale just to test. At the same time check the error logs as the message does say that the server closed the connection, therefore the question is why it would do this while running this statement. Steve
-
I've been trying to run a timed test against an Aurora PostgreSQL instance, and the test fails at the very end. I see the Monitor user output count up to the time limit, then display "Test complete, Taking end Transaction Count", but the actual counts don't show up. The lower pane reads "Error in Virtual User 1: server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request", and Virtual User 1 shows red X status. I have verified...
-
I have run a check with HammerDB 3.2 against Db2 11.1.2.2 (Database server = DB2/NT64 11.1.2.2) - this is on Windows (because I'm happening to be working on SQL Server at the moment) - and its a 1 warehouse database for a quick check so ignore the performance however the result I get is: Vuser 1:2 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 49338 Db2 TPM at 11196 NOPM and querying the table gives me the following: ... 1 160480 1 record(s) selected. db2 => select total_app_commits...
-
Hi, Many thanks for the update - so we now know why HammerDB reports 0 TPM because the values are not changing in sysibmadm.mon_db_summary. I will need to look into this to see if it is a configuration issue or whether something has changed between IBM releases. It does not look like a permission issue as you can select from it. Many thanks, Steve
-
Thank you Steve. I ran the command multiple times the value is same 25 in every time. The value is not increasing , not sure why DB2 is not the increasing the values eventhough I ran the mulitple times. Please let me know if anything need to test and I attached the scripts in my last post. Advance thanks.
-
Hi, For the driver scripts with and without output the "test" script prints its output to the screen, this is intended as a test to make sure that the schema is created ok and everything is working as expected rather than a measured test. The issue is that printing output requires printing to the screen and this can only be handled by one thread (by the OS) and is therefore a bottleneck. The timed tests are the ones for measuring. So the next test is to run this command: $ db2 "select total_app_commits...
-
Hi Steve, Thank you for the information . I ran the below command on HammerDB server and can see the value 25 ,I followed to run first command line setup file which is mention all the commands then ran test script. I can see the TPM 0 in output file. Below are the details of DB2 and OS. Attaching the setup and test file . I observed the other RDBMS databases output , the transactions with output surppressed is their any difference without and with ? **Processing 100000 transactions without output...
-
Hi Steve, Thank you for the information . I ran the below command on HammerDB server and can see the value 25 ,I followed to run first command line setup file which is mention all the commands then ran test script. I can see the TPM 0 in output file. Below are the details of DB2 and OS. Attaching the setup and test file . I observed the other RDBMS databases output , the transactions with output surppressed is their any difference without and with ? **Processing 100000 transactions without output...
-
You need to provide more details and the versions and OS you are using. HammerDB runs the following SQL Statement to capture the TPM: "select total_app_commits + total_app_rollbacks from sysibmadm.mon_db_summary" So log in as the user you are running HammerDB under and see if you can run the SQL statement, this will determine if there are for example permission or version issues that prevent you querying this table. Steve
-
Hi Steve, I am testing HammerDB for DB2 LUW. Need help to resolve the issue 0 TPM after execution of command line script. First ,I tested in GUI after build the schema,load test and virtual user create and run , the output showing is 0 TPM and didn't show any graph and Metrics(agent/hostname is mentioned ). So I tried to run the command line , I can see the same output with 0 TPM a. Please help me if anything I missed ? Vuser 1:Connection established Vuser 1:Beginning rampup time of 0 minutes Vuser...
-
Hi Steve, I am testing HammerDB for DB2 LUW. Need help to resolve the issue 0 TPM after execution of command line script. First ,I tested in GUI after build the schema,load test and virtual user create and run , the output showing is 0 TPM and didn't show any graph and Metrics(agent/hostname is mentioned ). So I tried to run the command line , I can see the same output with 0 TPM a. Please help me if anything I missed ? Vuser 1:Connection established Vuser 1:Beginning rampup time of 0 minutes Vuser...
-
Hi Steve, I am testing HammerDB for DB2 LUW. Need help to resolve the issue 0 TPM after execution of command line script. First ,I tested in GUI after build the schema,load test and virtual user create and run , the output showing is 0 TPM and didn't show any graph and Metrics(agent/hostname is mentioned ). So I tried to run the command line , I can see the same output with 0 TPM a. Please help me if anything I missed ? Vuser 1:Test complete, Taking end Transaction Count. Vuser 1:4 Active Virtual...
-
Hi Steve, I am testing HammerDB for DB2 LUW. Need help to resolve the issue 0 TPM after execution of command line script. First ,I tested in GUI after build the schema,load test and virtual user create and run , the output showing is 0 TPM and didn't show any graph and Metrics(agent/hostname is mentiones in Display). So I tried to run the command line , I can see the same output with 0 TPM a. Please help me if anything I missed ? Vuser 1:Test complete, Taking end Transaction Count. Vuser 1:4 Active...
-
I am testing HammerDB for DB2 LUW. Need help to resolve the issue 0 TPM after exection of command line script. First ,I tested in GUI after build the schema,load test and virtual user create and run , the output is 0 TPM and didn't show any graph and Metrics(agent/hostname is mentiones in Display). So I tried to run the command line but it looks the same output with no TPM. Please help me if anything I missed ? Vuser 1:Test complete, Taking end Transaction Count. Vuser 1:4 Active Virtual Users configured...
1 >