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
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...
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 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...
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...